JDBC 2 Concurrent Connections

General Usage
2

To use multiple drivers, just need to set the classpath before calling init. So something like:

using JDBC
JDBC.usedriver("path_to_oracle_driver")
JDBC.usedriver("path_to_mysql_driver")
JDBC.init()

conn1 = DriverManager.getConnection(<oracle connection string>)
conn2 =  DriverManager.getConnection (<mysql connection string>)
.....
<use conn and conn2 to make queries and fetch data>
......
close(conn1)
close(conn2)
1 Like