# How to connect to oracle with jruby

**URL:** <https://www.ruby-forum.com/t/how-to-connect-to-oracle-with-jruby/254444>\
**Category:** Uncategorized\
**Created:** [February 10, 2020, 2:25pm UTC](https://www.ruby-forum.com/t/how-to-connect-to-oracle-with-jruby/254444 "2020-02-10T14:25:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![HansS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/a6a055/32.png) [@HansS](https://www.ruby-forum.com/u/HansS)\
**Post date:** [February 10, 2020, 2:25pm UTC](https://www.ruby-forum.com/t/how-to-connect-to-oracle-with-jruby/254444/1 "2020-02-10T14:25:54Z")

</div>

Hi,

My version of jruby is:  
jruby 9.2.8.0 (2.5.3) 2019-08-12 a1ac7ff OpenJDK 64-Bit Server VM 25.212-b04 on 1.8.0\_212-b04 +indy +jit [linux-x86\_64]

I want to connect to an Oracle database.  
A jdbc gem is installed.  
Do I need additional things to install?  
I’d rather not install the complete Oracle Client software.

To connect to a SQLServer database I used  
require “jdbc/mssql”

And I have the following:  
jdbc (0.1.1 java)  
jdbc-mssql (0.7.0 java)

What is the best way (the least amount of maintenance)?

Regards Hans

---

<div class="post-metadata">

**Author:** ![HansS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/a6a055/32.png) [@HansS](https://www.ruby-forum.com/u/HansS)\
**Post date:** [February 12, 2020, 7:49am UTC](https://www.ruby-forum.com/t/how-to-connect-to-oracle-with-jruby/254444/2 "2020-02-12T07:49:40Z")

</div>

Turns out it is relatively simple:  
You need a ojdbc8 jar and include it.

require ‘java’  
require “/u01/apps//lib/jars/ojdbc8-19.3.0.0.jar”

java\_import 'java.sql.DriverManager

user = 'system  
password = ‘manger’  
sql\_statement = ‘select \* from dual’  
connect\_string = ‘(DESCRIPTION=(SOURCE\_ROUTE=OFF)(ADDRESS\_LIST=(ADDRESS=PROTOCOL=TCP)(HOST=saturn)(PORT=1521)))(CONNECT\_DATA=(SID=MOON)(SRVR=DEDICATED)))’

connection = java.sql.DriverManager.getConnection(  
“jdbc:oracle:thin:@” + connect\_string,  
user,  
password  
)  
statement = connection.create\_statement  
results=statement.execute\_query(sql\_statement)

while(results.next())  
puts rs.getObject(1)  
end