If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > problem in connecting to DB2 in Windows 2003

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-10-07, 14:00
marad marad is offline
Registered User
 
Join Date: Sep 2007
Posts: 3
problem in connecting to DB2 in Windows 2003

When I attempt to connect to DB2 running in windows server 2003 machine, I get the following error message:

com.ibm.db2.jcc.c.DisconnectException: [ibm][db2][jcc][t4][2034][11148] Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x2110.

What am I missing there? I used JDBC type 4 driver (driver class=com.ibm.db2.jcc.DB2Driver). Please help me to overcome this problem.
Reply With Quote
  #2 (permalink)  
Old 10-10-07, 14:38
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Version mismatch between the client and the server?
Reply With Quote
  #3 (permalink)  
Old 10-11-07, 11:56
marad marad is offline
Registered User
 
Join Date: Sep 2007
Posts: 3
I don't think it is a version issue. We are using DB2 Express 9.1 version.

Client is a pure java application that uses hibernate and C3P0 to communicate with DB2. Surprisingly, a test java code using driver.connect method turns out successful. The error occurs while attempting to connect to the DB2 server using hibernate and C3P0.

Any specific requirements or considerations to use hibernate with DB2? No difficulties with other databases like MySQL or SQLServer-2005.


The JDBC URL used is jdbc:db2://<ip-address>:50000/<database-name>

I am a kind of stuck. Gurus, help me.



Quote:
Originally Posted by n_i
Version mismatch between the client and the server?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On