Design approach for multiple database connection like DB2, MySQL etc using JDBC

Question

Hi I have Java application which connects to different databases like DB2, MySQL etc. One way I can think of is in a configuration file we configure databases and create different JDBC Connection objects and connect to the databases.

Is this the best way to achieve this task? Or we can achieve this in a better way with minumum efficient code.

Please guide. Thanks in advance.

Juned Ahsan · Accepted Answer · 2013-06-19 17:16:14Z

2

Put the details of databases, connections strings, drivers etc in a configuration/properties file.
Read that property file on application startup or on first database connection request
Implement a factory of connections and use typeofDB as the input to the factory, which will return a connection object for that database using the configuration.
You can control the number of connections etc in your factory if you want.

Hope it helps!

answered Jun 19, 2013 at 17:16

Juned Ahsan

68.9k12 gold badges101 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Design approach for multiple database connection like DB2, MySQL etc using JDBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related