You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by David Selvaraj <ds...@hotmail.com> on 2005/10/31 17:32:34 UTC
Getting error when using DB2 type 4 driver
Hi,
I am getting the following error when connecting to Derby 10.1.1 network
server using a db2 type 4 driver. I am using Squirrel as the client.
The driver class is com.ibm.db2.jcc.DB2Driver and the url is
jdbc:db2://localhost:1555/DEMODOC.
The network server is starting fine and I am able to get the Sysinfo to work
fine.
Execution failed because of a Distributed Protocol Error:
DRDA_Proto_SYNTAXRM;
CODPNT arg = 2135; Error Code Value = e
org.apache.derby.impl.drda.DRDAProtocolException
at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown
Source)
at
org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.checkRequired(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
Source)
at
org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
null
org.apache.derby.impl.drda.DRDAProtocolException
at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown
Source)
at
org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.checkRequired(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
Source)
at
org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
And I am getting the following error in the client side:
DEMODOC: Execution failed due to a distribution protocol error that caused
deallocation of the conversation. A DRDA Data Stream Syntax Error was
detected. Reason: 0x2135
com.ibm.db2.jcc.b.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the conversation. A
DRDA Data Stream Syntax Error was detected. Reason: 0x2135
at com.ibm.db2.jcc.a.ab.l(ab.java:1214)
at com.ibm.db2.jcc.a.bb.Y(bb.java:1935)
at com.ibm.db2.jcc.a.bb.z(bb.java:599)
at com.ibm.db2.jcc.a.bb.p(bb.java:550)
at com.ibm.db2.jcc.a.bb.l(bb.java:363)
at com.ibm.db2.jcc.a.bb.d(bb.java:145)
at com.ibm.db2.jcc.a.b.Sb(b.java:1274)
at com.ibm.db2.jcc.a.b.a(b.java:1166)
at com.ibm.db2.jcc.a.b.q(b.java:934)
at com.ibm.db2.jcc.a.b.a(b.java:702)
at com.ibm.db2.jcc.a.b.<init>(b.java:305)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:367)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Any help on this will be greatly appreciated.
Thanks,
David
Re: Getting error when using DB2 type 4 driver
Posted by Rajesh Kartha <ka...@Source-Zone.Org>.
David Selvaraj wrote:
> Hi,
> I am getting the following error when connecting to Derby 10.1.1
> network server using a db2 type 4 driver. I am using Squirrel as the
> client.
>
> The driver class is com.ibm.db2.jcc.DB2Driver and the url is
> jdbc:db2://localhost:1555/DEMODOC.
>
> The network server is starting fine and I am able to get the Sysinfo
> to work fine.
>
> Execution failed because of a Distributed Protocol Error:
> DRDA_Proto_SYNTAXRM;
> CODPNT arg = 2135; Error Code Value = e
> org.apache.derby.impl.drda.DRDAProtocolException
> at
> org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.checkRequired(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> null
> org.apache.derby.impl.drda.DRDAProtocolException
> at
> org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.checkRequired(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>
> And I am getting the following error in the client side:
> DEMODOC: Execution failed due to a distribution protocol error that
> caused deallocation of the conversation. A DRDA Data Stream Syntax
> Error was detected. Reason: 0x2135
>
> com.ibm.db2.jcc.b.DisconnectException: Execution failed due to a
> distribution protocol error that caused deallocation of the
> conversation. A DRDA Data Stream Syntax Error was detected. Reason:
> 0x2135
>
> at com.ibm.db2.jcc.a.ab.l(ab.java:1214)
>
> at com.ibm.db2.jcc.a.bb.Y(bb.java:1935)
>
> at com.ibm.db2.jcc.a.bb.z(bb.java:599)
>
> at com.ibm.db2.jcc.a.bb.p(bb.java:550)
>
> at com.ibm.db2.jcc.a.bb.l(bb.java:363)
>
> at com.ibm.db2.jcc.a.bb.d(bb.java:145)
>
> at com.ibm.db2.jcc.a.b.Sb(b.java:1274)
>
> at com.ibm.db2.jcc.a.b.a(b.java:1166)
>
> at com.ibm.db2.jcc.a.b.q(b.java:934)
>
> at com.ibm.db2.jcc.a.b.a(b.java:702)
>
> at com.ibm.db2.jcc.a.b.<init>(b.java:305)
>
> at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
>
> at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)
>
>
> at
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
>
>
> at
> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:367)
>
>
> at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>
>
> at java.lang.Thread.run(Unknown Source)
>
>
>
> Any help on this will be greatly appreciated.
>
> Thanks,
> David
>
>
Hi david,
For the DB2 Universal driver:
instead of jdbc:db2://localhost:1555/DEMODOC. (db2 is for connecting
to DB2)
the url should be like
jdbc:derby:net://localhost:1555/DEMODOC:user=app;password=app;
|
||( another example:
'jdbc:derby:net://localhost:1527/SAMPLE;create=true:user=app;password=app;')
||
|Derby has a new Network Client - derbyclient.jar, you can connect to
the same database
using: jdbc:derby://localhost:1555/DEMODOC.
-Rajesh
Re: Getting error when using DB2 type 4 driver
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
David Selvaraj wrote:
> Hi,
> I am getting the following error when connecting to Derby 10.1.1 network
> server using a db2 type 4 driver. I am using Squirrel as the client.
>
> The driver class is com.ibm.db2.jcc.DB2Driver and the url is
> jdbc:db2://localhost:1555/DEMODOC.
Try this url for the db2 universal jdbc driver:
jdbc:derby:net://localhost:1555/DEMODOC
Also, 10.1.1 includes a client jdbc driver (the jar file is
derbyclient.jar). The URL for that would be:
jdbc:derby://localhost:1555/DEMODOC
I hope this helps.
regards,
-jean
>
> The network server is starting fine and I am able to get the Sysinfo to
> work fine.
>
> Execution failed because of a Distributed Protocol Error:
> DRDA_Proto_SYNTAXRM;
> CODPNT arg = 2135; Error Code Value = e
> org.apache.derby.impl.drda.DRDAProtocolException
> at
> org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.checkRequired(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> null
> org.apache.derby.impl.drda.DRDAProtocolException
> at
> org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.checkRequired(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.parseACCRDB(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>
> And I am getting the following error in the client side:
> DEMODOC: Execution failed due to a distribution protocol error that
> caused deallocation of the conversation. A DRDA Data Stream Syntax
> Error was detected. Reason: 0x2135
>
> com.ibm.db2.jcc.b.DisconnectException: Execution failed due to a
> distribution protocol error that caused deallocation of the
> conversation. A DRDA Data Stream Syntax Error was detected. Reason:
> 0x2135
>
> at com.ibm.db2.jcc.a.ab.l(ab.java:1214)
>
> at com.ibm.db2.jcc.a.bb.Y(bb.java:1935)
>
> at com.ibm.db2.jcc.a.bb.z(bb.java:599)
>
> at com.ibm.db2.jcc.a.bb.p(bb.java:550)
>
> at com.ibm.db2.jcc.a.bb.l(bb.java:363)
>
> at com.ibm.db2.jcc.a.bb.d(bb.java:145)
>
> at com.ibm.db2.jcc.a.b.Sb(b.java:1274)
>
> at com.ibm.db2.jcc.a.b.a(b.java:1166)
>
> at com.ibm.db2.jcc.a.b.q(b.java:934)
>
> at com.ibm.db2.jcc.a.b.a(b.java:702)
>
> at com.ibm.db2.jcc.a.b.<init>(b.java:305)
>
> at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
>
> at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)
>
>
> at
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
>
>
> at
> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:367)
>
>
> at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>
> at java.lang.Thread.run(Unknown Source)
>
>
>
> Any help on this will be greatly appreciated.
>
> Thanks,
> David
>
>