首页 >数据库 >mysql教程 >Simultaneous MySql and PostgreSql Data Connections in Java_MySQL

Simultaneous MySql and PostgreSql Data Connections in Java_MySQL

WBOY
WBOY原创
2016-06-01 13:15:58867浏览

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().

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.

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();

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn