Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Cannot Reproduce
-
10.1.3.1
-
None
-
None
-
AIX 64
-
Urgent
Description
I use cloudscape JDBC to develope an application for some pressure test. When I call preparedstatement, it through error, but if I reconnect the jdbc connection, this SQL can be successfully executed. I do not know the reason. Because the jdbc log is too big, so I copy piece of JDBC log for analyzation.
If you want to get the whole log, please contact me with email: liming01@gmail.com. Thank you!
======================= JDBC LOG ===============================
[derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
[derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] finalize () called
[derby] [net][time:1168278886300][thread:main][tracepoint:1][Request.flush]
[derby] SEND BUFFER: PRPSQLSTT (ASCII) (EBCDIC)
[derby] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[derby] 0000 006FD05100010069 200D005B21130023 .o.Q...i ..[!..# .?}........$....
[derby] 0010 84826D93945EA399 818385C68993857E ..m..^.........~ db_lm;traceFile=
[derby] 0020 6188969485618989 8485A5F86183A24B a....a......a..K /home/iidev8/cs.
[derby] 0030 96A4A30012D5E4D3 D3C9C44040404040 ...........@@@@@ out..NULLID
[derby] 0040 4040404040404000 12E2E8E2D3C8F0F0 @@@@@@@......... ..SYSLH00
[derby] 0050 F040404040404040 4040405359534C56 .@@@@@@@@@@SYSLV 0 ...<.
[derby] 0060 4C30310004000521 16F10005214604 L01....!....!F. <........1.....
[derby]
[derby] SEND BUFFER: (ASCII) (EBCDIC)
[derby] 0000 001AD05300010014 2450000000000A57 ...S....$P.....W ..}......&......
[derby] 0010 49544820484F4C44 20FF007BD0430001 ITH HOLD ..
...
[derby] 0020 0075241400000000 6B494E5345525420 .u$.....kINSERT ........,.+.....
[derby] 0030 494E544F20225553 52222E2254424943 INTO "USR"."TBIC .+.|............
[derby] 0040 3030543622202820 224335222C202022 00T6" ( "C5", " ................
[derby] 0050 4331222C20202243 32222C2020224333 C1", "C2", "C3 ................
[derby] 0060 222C202022433422 292056414C554553 ", "C4") VALUES ............<...
[derby] 0070 2028203F2020202C 20203F2020202C20 ( ? , ? , ................
[derby] 0080 203F2020202C2020 3F2020202C20203F ? , ? , ? ................
[derby] 0090 20202029FF006AD0 0100020064200800 )..j.....d .. ......|}........
[derby] 00A0 5B2113002384826D 93945EA399818385 [!..#..m..^..... $....db_lm;trace
[derby] 00B0 C68993857E618896 94856189898485A5 ....~a....a..... File=/home/iidev
[derby] 00C0 F86183A24B96A4A3 0012D5E4D3D3C9C4 .a..K........... 8/cs.out..NULLID
[derby] 00D0 4040404040404040 404040400012E2E8 @@@@@@@@@@@@.... ..SY
[derby] 00E0 E2D3C8F0F0F04040 4040404040404040 ......@@@@@@@@@@ SLH000
[derby] 00F0 5359534C564C3031 00040005214605 SYSLVL01....!F. ...<.<.........
[derby]
[derby] [net][time:1168278886300][thread:main][tracepoint:2][Reply.fill]
[derby] RECEIVE BUFFER: (ASCII) (EBCDIC)
[derby] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[derby] 0000 0300040500023E00 0705000205000205 ......>......... ................
[derby] 0010 0002050002330015 3E00223E000F3E00 .....3..>.">..>. ................
[derby] 0020 0F3E000F3E00043E 00043E00043E000F .>..>..>..>..>.. ................
[derby] 0030 3E000F3E000F0500 020971E0540001D0 >..>......q.T... ...........\...}
[derby] 0040 00010671F0E00000 03BAD003000103B4 ...q............ ....0\....}.....
[derby] 0050 241BFF0000000100 0001000001000000 $............... ................
[derby] 0060 0000000000000000 0100000100000100 ................ ................
[derby] 0070 0000000000000000 0000000000010000 ................ ................
[derby] 0080 E3414C4941532C42 4947494E542C424F .ALIAS,BIGINT,BO T.<........+...|
[derby] 0090 4F4C45414E2C4341 4C4C2C434C415353 OLEAN,CALL,CLASS |<..+...<<..<...
[derby] 00A0 2C434F50592C4442 324A5F4445425547 ,COPY,DB2J_DEBUG ..|&............
[derby] 00B0 2C45584543555445 2C4558504C41494E ,EXECUTE,EXPLAIN ...........&<..+
[derby] 00C0 2C46494C452C4649 4C5445522C474554 ,FILE,FILTER,GET ...<....<.......
[derby] 00D0 43555252454E5443 4F4E4E454354494F CURRENTCONNECTIO .......|+....|
[derby] 00E0 4E2C494E4445582C 494E5354414E4345 N,INDEX,INSTANCE ............
[derby] 00F0 4F462C4D4554484F 442C4E45572C4F46 OF,METHOD,NEW,OF |..(...|..+...|.
[derby] 0100 462C50524F504552 544945532C505542 F,PROPERTIES,PUB ..&.|&.......&..
[derby] 0110 4C49434154494F4E 2C5245434F4D5049 LICATION,RECOMPI <.....|+....|(&.
[derby] 0120 4C452C5245465245 53482C52454E414D LE,REFRESH,RENAM <............+.(
[derby] 0130 452C52554E54494D 4553544154495354 E,RUNTIMESTATIST ....+..(........
[derby] 0140 4943532C53544154 454D454E542C5354 ICS,STATEMENT,ST .........(.+....
[derby] 0150 4154495354494353 2C54494D494E472C ATISTICS,TIMING, ...........(.+..
[derby] 0160 5741495400000841 42532C5351525400 WAIT...ABS,SQRT. ................
[derby] 0170 002F4C454E475448 2C4C4F5745522C4C ./LENGTH,LOWER,L ..<.+....<|....<
[derby] 0180 5452494D2C525452 494D2C5355425354 TRIM,RTRIM,SUBST ...(.....(......
[derby] 0190 522C535542535452 494E472C55505045 R,SUBSTRING,UPPE .........+...&&.
[derby] 01A0 5200005443555252 454E545F55534552 R..TCURRENT_USER .........+......
[derby] 01B0 2C67657443757272 656E74436F6E6E65 ,getCurrentConne .........>..?>>.
[derby] 01C0 6374696F6E2C7275 6E54696D65537461 ction,runTimeSta ...?>...>.._.../
[derby] 01D0 746973746963732C 53455353494F4E5F tistics,SESSION_ .............|+.
[derby] 01E0 555345522C555345 522C43555252454E USER,USER,CURREN ...............+
[derby] 01F0 5420534348454D41 0000434355524441 T SCHEMA..CCURDA ......(.........
[derby] 0200 54452C4355525449 4D452C4355525245 TE,CURTIME,CURRE ........(.......
[derby] 0210 4E545F444154452C 43555252454E545F NT_DATE,CURRENT_ ..............
[derby] 0220 54494D452C435552 52454E545F54494D TIME,CURRENT_TIM ..(.......+....(
[derby] 0230 455354414D502C45 5854524143540000 ESTAMP,EXTRACT.. ....(&..........
[derby] 0240 0000000000000100 0001000001000131 ...............1 ................
[derby] 0250 0000010000000000 0000000100000100 ................ ................
[derby] 0260 0001000001000001 0000000000000000 ................ ................
[derby] 0270 0000000000000000 0001000000000001 ................ ................
[derby] 0280 000006534348454D 4100000950524F43 ...SCHEMA...PROC .......(....&.|.
[derby] 0290 4544555245000007 434154414C4F4700 EDURE...CATALOG. ............<|..
[derby] 02A0 0000000000000001 0000010000010000 ................ ................
[derby] 02B0 0100000100000000 0000000000000000 ................ ................
[derby] 02C0 0000000000010000 0100000100000100 ................ ................
[derby] 02D0 0001000001000001 0000000000000000 ................ ................
[derby] 02E0 0100000000000000 0000000000000000 ................ ................
[derby] 02F0 0000800000000000 0000000000000000 ................ ................
[derby] 0300 0000000000000000 0000000000000000 ................ ................
[derby] 0310 0000000000800000 0000000000000080 ................ ................
[derby] 0320 0000000080000000 0000000000000000 ................ ................
[derby] 0330 0001000000000000 0000000000000000 ................ ................
[derby] 0340 8000000000000000 00001E0000000002 ................ ................
[derby] 0350 0000010007312C32 2C342C3800000100 .....1,2,4,8.... ................
[derby] 0360 0000000000000000 000009313030332C ...........1003, ................
[derby] 0370 3130303400223130 30332C313030383B 1004."1003,1008; ................
[derby] 0380 313030342C313030 383B313030352C31 1004,1008;1005,1 ................
[derby] 0390 3030372C31303038 0000000000000004 007,1008........ ................
[derby] 03A0 3130303300043130 3033000431303033 1003..1003..1003 ................
[derby] 03B0 0000000000000000 0100000000643032 .............d02 ................
[derby] 03C0 3030304353533130 3031310000000000 000CSS10011..... ................
[derby] 03D0 0000000100000000 0000000000000000 ................ ................
[derby] 03E0 0000000020202020 2020202020202000 .... . ................
[derby] 03F0 00000B456E64206F 6620446174610000 ...End of Data.. ....>..?..././..
[derby] 0400 FFFF .. ..
[derby]
SQLException: SQLState(58009) vendor code(-4499)
org.apache.derby.client.am.DisconnectException: Execution failed due to a distribution protocol error that caused deallocation of the conversation. A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x3
at org.apache.derby.client.net.Reply.doSyntaxrmSemantics(Unknown Source)
at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at com.ibm.db2.jdbcwrapper.JavaFunc.prepareStatement(JavaFunc.java:65)
[derby] BEGIN TRACE_DIAGNOSTICS
[derby][SQLException@7dad7dad] java.sql.SQLException
[derby][SQLException@7dad7dad] SQL state = 58009
[derby][SQLException@7dad7dad] Error code = -4499
[derby][SQLException@7dad7dad] Message = Execution failed due to a distribution protocol error that caused deallocation of the conversation. A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x3
[derby][SQLException@7dad7dad] Stack trace follows
org.apache.derby.client.am.DisconnectException: Execution failed due to a distribution protocol error that caused deallocation of the conversation. A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x3
at org.apache.derby.client.net.Reply.doSyntaxrmSemantics(Unknown Source)
at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at com.ibm.db2.jdbcwrapper.JavaFunc.prepareStatement(JavaFunc.java:65)
[derby] END TRACE_DIAGNOSTICS
[derby][Time:1168278892287][Thread:main][ResultSet@78f578f5] close () called
[derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] close () called