Python > Connection with JDBC to Oracle service name (jaydebeapi)

Question

This sample code is used to connect in Python to Oracle SID.

import jpype
import jaydebeapi
jHome = jpype.getDefaultJVMPath()
jpype.startJVM(jHome, '-Djava.class.path=/path/to/ojdbc6.jar')
conn = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver','jdbc:oracle:thin:user/password@DB_HOST_IP:1521:DB_NAME')

How can we connect to Oracle Service Name?

PKey · Accepted Answer · 2016-09-19 15:24:33Z

4

Regarding your connection string, you could use TNS syntax (read on, here), as opposed to host:port:sid syntax you're using now. In that case you would describe SERVICE_NAME inside CONNECT_DATA, as follows:

   jaydebeapi.connect('oracle.jdbc.driver.OracleDriver','[MYUSER]/[MYPASS]@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[MYHOST])(PORT=1521))(CONNECT_DATA=(SERVER=dedicated) (SERVICE_NAME=[MYSERVICENAME])))')

By the way - you could also use cx_Oracle to connect to oracle - no java hassle. (just a suggestion)

edited Sep 19, 2016 at 15:24

answered Sep 19, 2016 at 9:00

PKey

3,8712 gold badges21 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yuriy Brovko · Accepted Answer · 2016-09-22 08:10:35Z

4

This way should work

  conn = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver','jdbc:oracle:thin:user/password@//DB_HOST_IP:1521/DB_NAME')

answered Sep 22, 2016 at 8:10

Yuriy Brovko

811 gold badge2 silver badges7 bronze badges

Collectives™ on Stack Overflow

Python > Connection with JDBC to Oracle service name (jaydebeapi)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related