Suppose I do not want to use JDBC-ODBC bridge because I want improved performance of JDBC Drive for a specific DBMS but I do not know what sort of DBMS that the application will be using. How can I make my application open to use any DBMS without having to change the source everytime?
Thanks Thomas Paul. How do I go about finding the properties file of a database and when I find it how do I find out what type it is?
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
You misunderatnd. Create a properties file (mydatabase.properties) and put in it the information about your database: db.driver=com.sybase.jdbc.SybDriver db.user=user db.password=password db.url=jdbc:sybase:Tds:myserver:5150/mydatabase Instead of hardcoding this information into your program, read it in. Now if you change databases, you just change the properties file.