Simultaneous MySql and PostgreSql Data Connections in Java_MySQL

we’re importing records from a mysql database and entering them into postgresql in java. in the process we’ll be modifying the mysql data a bit, but that’s for another blog post. today we’re going to show supporting both input and output database providers which enables us to seamlessly hand-off objects from one data source to another.

We have two providers as you see here, a MySql provider as input and PostgreSql as output.

In the base provider class, be it MySql or PostgreSql we use a Connections class to retrieve ourInputConnection()or ourOutputConnection().

立即学习“Java免费学习笔记（深入）”；

To retrieve the “NixImportConnection” object we rely on the Configuration class which we’ll see next. Here is where we call the Configuration class in NixImportConnection.

We’re one step closer to the connection’s properties in the Configuration class where we’ll retrieve the configuration name of the input and output connections from the app’s properties file.

音疯

音疯是昆仑万维推出的一个AI音乐创作平台，每日可以免费生成6首歌曲。

178

查看详情

The properties file is where we define the connection name, giving us the ability to change it at any time based on environment or development needs.

We arrive at our Connections.xml file where the information to populate our Connection Properties formysql.burkey_nixmash andpostgresql.nixmashupdb.

With dual data providers for MySql and PostgreSql we can easily hand-off objects from one source to another with

NixImportMySql db = NixImportMySql.loadProvider();

and

NixImportPostgreSql db = NixImportPostgreSql.loadProvider();