Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | DB2 SQLCODE -243 on query against joined tables | ||
---|---|---|---|
Product: | Base | Reporter: | boothcs <colin.booth> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | UNCONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | djb, dvcroft, issues, mhakman |
Version: | OOo 2.0 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
boothcs
2005-11-25 14:58:56 UTC
does it still occure in current version (http://download.openoffice.org/680/index.html)? thx set keyword 'needmoreinfo' lower prio tried with a current version src680m180 and queries with joins generally works fine no repro, no respond -> close do not hestitate to reopen if still occure in current version and you have anything to add This is still happening. Using Openoffice.org v3.0 - OOO300m9 (Build:9358) Error: SQL Status: 36001 Error code: -243 DB2 SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C1 The SQL command leading to this error is: SELECT * FROM "ZCOREINV"."MASTPRD_CUSTFIELDS" This is about as simple as it gets. This is a simple view across two tables. This works in eclipse datatools, db2 control center and my own java programs. Can this issue be repopened please as it's still an issue. Thanks re-opening per kango_v's request. Can't confirm due to lacking DB2 access. Removing needmoreinfo, as the bug description seems sufficient to reproduce when you have access to the setup described above. Have the same problem. Running on Ubuntu 8.10 Using JDBC driver for DB2. Got following error: SQL Status: 36001 Error code: -243 DB2 SQL Error: SQLCODE=-243, SQLSTATE=36001, SQLERRMC=SQL_CURSH200C2, DRIVER=3.50.152 The data content could not be loaded. SELECT "000_HM"."FILE_SN", "000_TEST"."DUMP0" FROM "000"."TEST" AS "TEST", "000"."000_HM" AS "000_HM" WHERE "000_TEST"."ID" = "000_HM"."TESTID" Whenever I try to access a DB2 View I receive the same SQLCODE -243. I'm running OpenOffice 3.4.1 on OS X 10.7.5. There is a free DB2 to download at IBM should you need it for problem investigation. Thanks. This is a problem on many queries. I ran into it trying to do column functions like count(), avg(), max(), min(), etc. The solution is to modify the connection string. You need to add the following at the end :cursorSensitivity=2; In my case that means the Datasource URL becomes: db2://andromeda:50000/ARBMAIN:cursorSensitivity=2; |