Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Created by: null on 16-05-2003 10:34:36 PM Currently I am using the JDBC driver jtds-0.5.1.jar from http://jtds.sourceforge.net/.
This requires an update to the server.xml, but I need to be able to access different databases with the same application. Is this possible?
Do you have a recommendation for a JDBC driver for our production environment that can accomodate multiple databases?
Thanks,
Tracey La Rue
Subject: RE: JDBC Driver for multiple DB Replied by: null on 19-05-2003 04:12:04 PM Hi Tracey,
Any Java application server can support accessing multiple databases siply by using a different JNDI name for each database. So when you edit the server.xml, give different JNDI names for each database. Then, in the Builder, when you use the database element, you refer to the appropriate JNDI name.
If you are using two separate database types (like Oracle and Informix), you simply get the drivers for both of them and place them in the Tomcat common/lib directory. If both databases are the same type, just different machines, then you only need the one driver, you don't need a separate driver to support multiple databases.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: