To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58446 Issue #:|58446 Summary:|DB2 SQLCODE -243 on query against joined tables Component:|Database access Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|boothcs
------- Additional comments from [EMAIL PROTECTED] Fri Nov 25 06:58:56 -0800 2005 ------- SUSE Linux 10 (32 bit) SUn JDK 1.5.0 DB2 ese 8.2.3 JDBC access via the jcc driver in type 2 mode. N.B. openoffice is the Novell build shipped with SUSE 10 and subsequently updated from their site Any query that contains a join appears to fail with SQLCODE -243. I ran a JDBC trace and base was requesting sensitive and updateable resultset. I do not believe that this is allowed for joined tables. I have not been able to find a way of forcing base to make the query insensitive and read only which would resolve the problem A part of the JDBC trace from base follows and the sensitive and update request can be clearly seen. [ibm][db2][jcc][Time:1132748292377][Thread:[EMAIL PROTECTED] prepareStatement (SELECT DISTINCT "MACHINES"."MACHINE_ID", "MACHINES"."MANUFACTURER", "HOSTS"."HOST_NAME", "INSTANCES"."INSTANCE_NAME", "DATABASES"."DBNAME" FROM "DDBIDBI0"."INSTANCES" "INSTANCES", "DDBIDBI0"."HOSTS" "HOSTS", "DDBIDBI0"."MACHINES" "MACHINES", "DDBIDBI0"."DATABASES" "DATABASES" WHERE ( "INSTANCES"."HOST_ID" = "HOSTS"."HOST_ID" AND "HOSTS"."MACHINE_ID" = "MACHINES"."MACHINE_ID" AND "DATABASES"."INSTANCE_NAME" = "INSTANCES"."INSTANCE_NAME" ), 1005, 1008) called [ibm][db2][jcc][Time:1132748292377][Thread:[EMAIL PROTECTED] prepareStatement () returned [EMAIL PROTECTED] [ibm][db2][jcc][Time:1132748292377][Thread:Thread-2066] [EMAIL PROTECTED] executeQuery () called [ibm][db2][jcc] [t4][time:1132748292378][thread:Thread-2066][tracepoint:5] [Request.flush] [ibm][db2][jcc][t4] SEND BUFFER: PRPSQLSTT (ASCII) (EBCDIC) [ibm][db2][jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF [ibm][db2][jcc][t4] 0000 0058D05100010052 200D00442113E8C3 .X.Q...R ..D!... ..}...........YC [ibm][db2][jcc][t4] 0010 C4C4C4F0F0F34040 4040404040404040 ......@@@@@@@@@@ DDD003 [ibm][db2][jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID [ibm][db2][jcc][t4] 0030 4040E2E8E2E2C8F2 F0F0404040404040 @@........@@@@@@ SYSSH200 [ibm][db2][jcc][t4] 0040 404040405359534C 564C303100010005 @@@@SYSLVL01.... ...<.<...... [ibm][db2][jcc][t4] 0050 2116F10005214604 !....!F. ..1..... [ibm][db2][jcc][t4] [ibm][db2][jcc][t4] SEND BUFFER: SQLATTR (ASCII) (EBCDIC) [ibm][db2][jcc][t4] 0000 0033D0530001002D 2450000000002353 .3.S...-$P....#S ..}......&...... [ibm][db2][jcc][t4] 0010 454E534954495645 2053544154494320 ENSITIVE STATIC .+.............. [ibm][db2][jcc][t4] 0020 5343524F4C4C2046 4F52205550444154 SCROLL FOR UPDAT ...|<<..|...&... [ibm][db2][jcc][t4] 0030 4520FF E . ... [ The following is a java application that uses the same OS/JDK/DB2 as base. It works with insensitive and read only It is possible that I have missed a feature of base and it will work but I can't find it. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
