Connect to DB2 via JayDeBeApi JDBC in Python

python jdbc db2 jaydebeapi
Alessandro Mariani picture Alessandro Mariani · Aug 29, 2014 · Viewed 14.2k times · Source

I've been struggling for a while to connect to DB2 via Python client on OSX (maveriks). A valid option seem to be using JayDeBeApi but, running the following code...

import jaydebeapi
import jpype

jar = '/opt/IBM/db2/V10.1/java/db2jcc4.jar' # location of the jdbc driver jar
args='-Djava.class.path=%s' % jar
jvm = jpype.getDefaultJVMPath()
jpype.startJVM(jvm, args)

jaydebeapi.connect('com.ibm.db2.jcc.DB2Driver',
'jdbc:db2://server:port/database','myusername','mypassword')

I'll get the following error

Traceback (most recent call last):
  File "<pyshell#67>", line 2, in <module>
    'jdbc:db2://server:port/database','myusername','mypassword')
  File "/Library/Python/2.7/site-packages/jaydebeapi/dbapi2.py", line 269, in connect
    jconn = _jdbc_connect(jclassname, jars, libs, *driver_args)
  File "/Library/Python/2.7/site-packages/jaydebeapi/dbapi2.py", line 117, in _jdbc_connect_jpype
    return jpype.java.sql.DriverManager.getConnection(*driver_args)
com.ibm.db2.jcc.am.SqlSyntaxErrorExceptionPyRaisable: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][3.63.123] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815

So basically I'm connecting to the server, but for some reason I'm not using the username & password provided. Any idea on how to pass correctly username and password? I can't find further specification for this problem exactly, and any suggestion or tips are welcome.

Answer

Alessandro Mariani picture Alessandro Mariani · Aug 29, 2014

nevermind... I wasn't passing the LIST of parameters.... with the following changes it now works:

jaydebeapi.connect(
    'com.ibm.db2.jcc.DB2Driver', 
    ['jdbc:db2://server:port/database','myusername','mypassword']
)

Related questions

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

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/…

Read More
How do I list all files of a directory?

How can I list all files of a directory in Python and add them to a list?

Read More
Iterating over dictionaries using 'for' loops

I am a bit puzzled by the following code: d = {'x': 1, 'y': 2, 'z': 3} for key in d: print key, 'corresponds to', d[key] What I don't understand is the key portion. How does Python recognize that it needs only to …

Read More