# JDBC 2 Concurrent Connections

**URL:** <https://discourse.julialang.org/t/jdbc-2-concurrent-connections/37608>\
**Category:** General Usage\
**Tags:** mysql\
**Created:** [April 15, 2020, 2:30am UTC](https://discourse.julialang.org/t/jdbc-2-concurrent-connections/37608 "2020-04-15T02:30:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dburch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/dburch/32/8741_2.png) [@dburch](https://discourse.julialang.org/u/dburch)\
**Post date:** [April 15, 2020, 2:30am UTC](https://discourse.julialang.org/t/jdbc-2-concurrent-connections/37608/1 "2020-04-15T02:30:55Z")

</div>

I am able to use JDBC to connect to an Oracle DB or a MySQL DB. It works great. Now I am trying to connect to both databases at the same time. How do I do that? Can I use two different drivers at the same time?

Here’s an example of the MySQL connection. How would I also add a connection to Oracle in the same script?

```julia
using JDBC

JDBC.usedriver(MYSQL_DRIVER)
JDBC.init()
mysqlConn = JDBC.Connection("jdbc:mysql://$MYSQL_SERVER:$MYSQL_PORT/$MYSQL_SCHEMA?user=$MYSQL_USER&password=$MYSQL_PASS&useSSL=false")
mysqlCursor = cursor(mysqlConn)

strSQL = "select * from manu_history limit 5 "
println(strSQL)
execute!(mysqlCursor, strSQL)

column_names = map(x -> Symbol(x), JDBC.colnames(JDBC.Source(mysqlCursor)))
println(column_names)

for r in rows(mysqlCursor)
    println(r)
end

close(mysqlCursor)
close(mysqlConn)

JDBC.destroy()

```

---

<div class="post-metadata">

**Author:** ![avik](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/avik/32/17_2.png) [@avik](https://discourse.julialang.org/u/avik)\
**Post date:** [April 18, 2020, 1:04pm UTC](https://discourse.julialang.org/t/jdbc-2-concurrent-connections/37608/2 "2020-04-18T13:04:22Z")

</div>

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

```julia
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)

```