#585 DB2 error - SQLSTATE=HY010

[Chris]

I am receiving an error each time I execute a query that does not return any result.

This prevent me from doing multiple command in the same execution like Create table, create index, insert into table.

The database behind is DB2.

The error is:
Error: [IBM][CLI Driver] CLI0125E Function Sequence Error. SQLSTATE=HY010
SQLState: HY010
ErrorCode: -99999

Thanks

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Could you take a look at the log file for exceptions, and post what you find here?

Rob

[Chris]

Logged In: YES
user_id=1941000
Originator: YES

16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - # Starting Client SQL SQuirreL Version 2.6.1 at 07-11-19 14:18
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Client SQL SQuirreL Version 2.6.1 started: Mon Nov 19 14:18:14 EST 2007
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Copyright (c) 2001-2006 Colin Bell, Gerd Wagner, Rob Manning et autres
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.vendor: Sun Microsystems Inc.
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.version: 1.5.0_05
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.name: Windows XP
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.version: 5.1
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.arch: x86
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.dir: C:\Documents and Settings\E\Squirrel
16 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.home: C:\Documents and Settings\E
32 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.home: C:\Program Files\Java\jre1.5.0_05
32 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.class.path: C:\Documents and Settings\E\Squirrel\squirrel-sql.jar;C:\Documents and Settings\E\Squirrel\lib\antlr-2.7.5H3.jar;C:\Documents and Settings\E\Squirrel\lib\cglib-2.1.3.jar;C:\Documents and Settings\E\Squirrel\lib\commons-cli.jar;C:\Documents and Settings\E\Squirrel\lib\commons-collections-2.1.1.jar;C:\Documents and Settings\E\Squirrel\lib\commons-logging-1.0.4.jar;C:\Documents and Settings\E\Squirrel\lib\dom4j-1.6.1.jar;C:\Documents and Settings\E\Squirrel\lib\ejb3-persistence.jar;C:\Documents and Settings\E\Squirrel\lib\forms.jar;C:\Documents and Settings\E\Squirrel\lib\fw.jar;C:\Documents and Settings\E\Squirrel\lib\hibernate-annotations-3.3.0.jar;C:\Documents and Settings\E\Squirrel\lib\hibernate-commons-annotations-3.3.0.jar;C:\Documents and Settings\E\Squirrel\lib\hibernate-entitymanager-3.3.1.jar;C:\Documents and Settings\E\Squirrel\lib\hibernate3.2.4.sp1.jar;C:\Documents and Settings\E\Squirrel\lib\jxl.jar;C:\Documents and Settings\E\Squirrel\lib\log4j.jar;C:\Documents and Settings\E\Squirrel\lib\nanoxml-2.1.jar;C:\Documents and Settings\E\Squirrel\lib\openide-loaders.jar;C:\Documents and Settings\E\Squirrel\lib\openide.jar;C:\Documents and Settings\E\Squirrel\lib\org-netbeans-modules-editor-fold.jar;C:\Documents and Settings\E\Squirrel\lib\org-netbeans-modules-editor-lib.jar;C:\Documents and Settings\E\Squirrel\lib\org-netbeans-modules-editor-util.jar;C:\Documents and Settings\E\Squirrel\lib\org-netbeans-modules-editor.jar;C:\Documents and Settings\E\Squirrel\lib\squirrel-sql_bg_BG.jar;C:\Documents and Settings\E\Squirrel\lib\squirrel-sql_cs_CZ.jar;C:\Documents and Settings\E\Squirrel\lib\squirrel-sql_de_DE.jar;C:\Documents and Settings\E\Squirrel\lib\squirrel-sql_fr.jar;C:\Documents and Settings\E\Squirrel\lib\squirrel-sql_pt_BR.jar;C:\Documents and Settings\E\Squirrel\lib\squirrel-sql_zh_CN.jar;C:\Documents and Settings\E\Squirrel\lib\syntax.jar;C:\SYBASE\ASEP\Monclass.zip;C:\SYBASE\ASEP\3pclass.zip;.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cisuz.jar;C:\PROGRA~1\IBM\SQLLIB\tools\db2XTrigger.jar;C:\PROGRA~1\IBM\SQLLIB\java\common.jar
9375 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément mysql créé en 0 ms, chargé en 15 ms, initialisé en 31 ms, total 46 ms.
9375 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément dbcopy créé en 0 ms, chargé en 0 ms, initialisé en 31 ms, total 31 ms.
9375 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément sessionscript créé en 0 ms, chargé en 0 ms, initialisé en 32 ms, total 32 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément sqlval créé en 16 ms, chargé en 0 ms, initialisé en 15 ms, total 31 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément derby créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément h2 créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément postgres créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément laf créé en 0 ms, chargé en 4 000 ms, initialisé en 0 ms, total 4 000 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément i18n créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément mssql créé en 16 ms, chargé en 0 ms, initialisé en 16 ms, total 32 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément refactoring créé en 0 ms, chargé en 0 ms, initialisé en 16 ms, total 16 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément informix créé en 15 ms, chargé en 0 ms, initialisé en 0 ms, total 15 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément dataimport créé en 0 ms, chargé en 16 ms, initialisé en 0 ms, total 16 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément codecompletion créé en 0 ms, chargé en 0 ms, initialisé en 15 ms, total 15 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément sqlbookmark créé en 0 ms, chargé en 0 ms, initialisé en 31 ms, total 31 ms.
9391 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément sqlparam créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément graph créé en 0 ms, chargé en 0 ms, initialisé en 16 ms, total 16 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément hibernate créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément db2 créé en 16 ms, chargé en 0 ms, initialisé en 0 ms, total 16 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément firebird créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément syntax créé en 0 ms, chargé en 0 ms, initialisé en 78 ms, total 78 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément editextras créé en 0 ms, chargé en 0 ms, initialisé en 16 ms, total 16 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément sqlscript créé en 0 ms, chargé en 0 ms, initialisé en 15 ms, total 15 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément oracle créé en 16 ms, chargé en 0 ms, initialisé en 32 ms, total 48 ms.
9407 [main] INFO net.sourceforge.squirrel_sql.client.Application - Complément sybase créé en 0 ms, chargé en 0 ms, initialisé en 0 ms, total 0 ms.
26750 [Thread-2] INFO net.sourceforge.squirrel_sql.client.session.Session - Le driver utilisé pour l'alias 'DB2 Dev' nest pas conforma à JDBC 3.0.
Vous devriez installer une version plus récente de ce driver.
26766 [Thread-3] INFO net.sourceforge.squirrel_sql.client.session.Session - Le driver utilisé pour l'alias 'DB2 Prod' nest pas conforma à JDBC 3.0.
Vous devriez installer une version plus récente de ce driver.
27063 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.AxionDialect
27407 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DB2Dialect
27407 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DaffodilDialect
27422 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DerbyDialect
27453 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.FirebirdDialect
27469 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.FrontBaseDialect
27485 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.HADBDialect
27500 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.H2Dialect
27500 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.HSQLDialect
27500 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.InformixDialect
27500 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.InterbaseDialect
27500 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.IngresDialect
27516 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MAXDBDialect
27516 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.McKoiDialect
27516 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MySQLDialect
27516 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MySQL5Dialect
27516 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.Oracle9iDialect
27532 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.PointbaseDialect
27532 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.PostgreSQLDialect
27532 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.ProgressDialect
27532 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SybaseDialect
27532 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SQLServerDialect
27547 [Thread-2] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.TimesTenDialect
31703 [Thread-7] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Initializing plugin
31828 [Thread-10] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Initializing plugin
32157 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - isOS400: session doesn't appear to be an OS/400 DB2
32250 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Adding SQL execution listener.
32563 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - isOS400: session doesn't appear to be an OS/400 DB2
32594 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Adding SQL execution listener.

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Hmmm... no exception stack trace in the log. Could you set the following line in log4j.properties :

log4j.rootLogger=info, SquirrelAppender

to

log4j.rootLogger=debug, SquirrelAppender

restart and try the same sequence of SQL statements that you did previously. Then check to see if there are any stack traces in the log file (near the bottom)

Thanks,

Rob

[Chris]

Logged In: YES
user_id=1941000
Originator: YES

This is where everything happens... I think!

...
23234 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - isOS400: session doesn't appear to be an OS/400 DB2
23266 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.fw.util.Resources - No resource found for action.net.sourceforge.squirrel_sql.plugins.sqlbookmark.CompleteBookmarkAction : image
23266 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Adding SQL execution listener.
23266 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Reusing existing thread
23266 [Thread-5] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Using a thread. 8 threads available
23266 [Thread-5] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Returning thread. 9 threads available
23422 [Thread-4] DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Functions loaded in 203 ms
23422 [Thread-4] DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Chargement des tables
23484 [Thread-4] DEBUG net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData - DBMS/Driver doesn't support getSupertables(): COM.ibm.db2.jdbc.app.DB2DatabaseMetaData.getSuperTables(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;
24375 [Thread-4] DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Tables loaded in 953 ms
24375 [Thread-4] DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Chargement des procédures stockées
24625 [Thread-4] DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - stored procedures loaded in 250 ms
24625 [Thread-4] DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - SchemaInfo.load took 2375 ms
24625 [Thread-4] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Returning thread. 10 threads available
25109 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Reusing existing thread
25109 [Thread-7] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Using a thread. 9 threads available
25109 [Thread-7] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Returning thread. 10 threads available
28172 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.client.session.mainpanel.BaseMainPanelTab - Refreshing SQL main tab.
43031 [AWT-EventQueue-1] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Reusing existing thread
43031 [Thread-6] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Using a thread. 9 threads available
43297 [Thread-6] DEBUG net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter - Error
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Erreur dans la séquence de fonctions. SQLSTATE=HY010
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Statement.getUpdateCount(Unknown Source)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:376)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:228)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
43297 [Thread-6] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool - Returning thread. 10 threads available

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

I've been trying to duplicate the problem to no avail. The section of code that the problem is occurring in is a bit complex as it is designed to work with different databases.
What would be really helpful to me at this point would be a small script that reproduces the problem and to know what are the version(s) of the database and JDBC driver that you
are using. If I can reproduce it, then I'll have a chance to step through the code with a debugger to see what is happening.

Rob

[Chris]

Logged In: YES
user_id=1941000
Originator: YES

This is the information from the server where the command ran.

I hope it helps:

Nom de classe du driver JDBC COM.ibm.db2.jdbc.app.DB2Driver
CLASSPATH du driver JDBC Aucun chemin n'a été indiqué dans l'onglet 'Class Path supplémentaire' du driver
getURL jdbc:db2:dvipci03
isReadOnly false
getDriverName IBM DB2 JDBC 2.0 Type 2
getDatabaseProductName DB2/AIX64
supportsCatalogsInTableDefinitions false
supportsSchemasInTableDefinitions true
getCatalogSeparator .
storesMixedCaseIdentifiers false
storesUpperCaseIdentifiers true
getUserName vbdwhse
supportsSchemasInDataManipulation true
supportsCatalogsInDataManipulation false
getIdentifierQuoteString "
getDriverVersion 08.02.0000
getDatabaseMajorVersion <Non Supporté>
supportsStoredProcedures true
getDatabaseProductVersion 08.02.0004
getResultSetHoldability <Non Supporté>
allProceduresAreCallable false
allTablesAreSelectable false
nullsAreSortedHigh true
nullsAreSortedLow false
nullsAreSortedAtStart false
nullsAreSortedAtEnd false
getDriverMajorVersion 8
getDriverMinorVersion 1
usesLocalFiles false
usesLocalFilePerTable false
supportsMixedCaseIdentifiers false
storesLowerCaseIdentifiers false
supportsMixedCaseQuotedIdentifiers true
storesUpperCaseQuotedIdentifiers false
storesLowerCaseQuotedIdentifiers false
storesMixedCaseQuotedIdentifiers false
getSearchStringEscape \
getExtraNameCharacters @#
supportsAlterTableWithAddColumn true
supportsAlterTableWithDropColumn false
supportsColumnAliasing true
nullPlusNonNullIsNull true
supportsConvert true
supportsTableCorrelationNames true
supportsDifferentTableCorrelationNames false
supportsExpressionsInOrderBy true
supportsOrderByUnrelated true
supportsGroupBy true
supportsGroupByUnrelated false
supportsGroupByBeyondSelect true
supportsLikeEscapeClause true
supportsMultipleResultSets true
supportsMultipleTransactions true
supportsNonNullableColumns true
supportsMinimumSQLGrammar true
supportsCoreSQLGrammar true
supportsExtendedSQLGrammar true
supportsANSI92EntryLevelSQL true
supportsANSI92IntermediateSQL false
supportsANSI92FullSQL false
supportsIntegrityEnhancementFacility true
supportsOuterJoins true
supportsFullOuterJoins true
supportsLimitedOuterJoins true
getSchemaTerm schema
getProcedureTerm stored procedure
getCatalogTerm
isCatalogAtStart false
supportsSchemasInProcedureCalls true
supportsSchemasInIndexDefinitions true
supportsSchemasInPrivilegeDefinitions true
supportsCatalogsInProcedureCalls false
supportsCatalogsInIndexDefinitions false
supportsCatalogsInPrivilegeDefinitions false
supportsPositionedDelete true
supportsPositionedUpdate true
supportsSelectForUpdate true
supportsSubqueriesInComparisons true
supportsSubqueriesInExists true
supportsSubqueriesInIns true
supportsSubqueriesInQuantifieds true
supportsCorrelatedSubqueries true
supportsUnion true
supportsUnionAll true
supportsOpenCursorsAcrossCommit true
supportsOpenCursorsAcrossRollback false
supportsOpenStatementsAcrossCommit true
supportsOpenStatementsAcrossRollback true
getMaxBinaryLiteralLength 4000
getMaxCharLiteralLength 32672
getMaxColumnNameLength 30
getMaxColumnsInGroupBy 1012
getMaxColumnsInIndex 16
getMaxColumnsInOrderBy 1012
getMaxColumnsInSelect 1012
getMaxColumnsInTable 1012
getMaxConnections 0
getMaxCursorNameLength 18
getMaxIndexLength 1024
getMaxSchemaNameLength 30
getMaxProcedureNameLength 128
getMaxCatalogNameLength 0
getMaxRowSize 32677
doesMaxRowSizeIncludeBlobs false
getMaxStatementLength 2097152
getMaxStatements 0
getMaxTableNameLength 128
getMaxTablesInSelect 0
getMaxUserNameLength 30
getDefaultTransactionIsolation TRANSACTION_READ_COMMITTED
supportsTransactions true
supportsDataDefinitionAndDataManipulationTransactions true
supportsDataManipulationTransactionsOnly false
dataDefinitionCausesTransactionCommit false
dataDefinitionIgnoredInTransactions false
supportsBatchUpdates true
getDatabaseMinorVersion <Non Supporté>
getJDBCMajorVersion <Non Supporté>
getJDBCMinorVersion <Non Supporté>
getSQLStateType <Non Supporté>
locatorsUpdateCopy <Non Supporté>
supportsGetGeneratedKeys <Non Supporté>
supportsMultipleOpenResults <Non Supporté>
supportsNamedParameters <Non Supporté>
supportsSavepoints <Non Supporté>
supportsStatementPooling <Non Supporté>

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

The two relevant parameters that I see that I expected to be false in you case are:

supportsMultipleOpenResults <Non Supporté>
getResultSetHoldability <Non Supporté>

When you access the alias driver properties table, are there any items in that table that are similar to the two entries I've list above?

Also, can you provide a script with multiple statements that reproduce the problem?

Rob

[Chris]

Logged In: YES
user_id=1941000
Originator: YES

I'm joining a test.sql file for you to see an example of crashing commands.

As for the "alias driver properties table"... this goes beyond my knowledge.
Could you explain me more in details what it means?
File Added: test.sql

[Chris]

Crashing commands

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Oh sure - sorry about that. You can open the Alias properties dialog by right-clicking the alias entry in the aliases table and choose "Alias Properties".
Then click on the "Driver Properties" tab and you should see a table with property names. If you select the checkbox for "Use driver properties" then you
can edit that table to include custom values for whatever driver properties the driver supports. If the driver doesn't support any driver properties then
this table would be empty. Does yours have entries and if so do any of them look like they control MultipleOpenResults or ResultSetHoldability ?

I'll give the script a try. Thanks!

Rob

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Oh sure - sorry about that. You can open the Alias properties dialog by right-clicking the alias entry in the aliases table and choose "Alias Properties".
Then click on the "Driver Properties" tab and you should see a table with property names. If you select the checkbox for "Use driver properties" then you
can edit that table to include custom values for whatever driver properties the driver supports. If the driver doesn't support any driver properties then
this table would be empty. Does yours have entries and if so do any of them look like they control MultipleOpenResults or ResultSetHoldability ?

I'll give the script a try. Thanks!

Rob

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

And, of course, the script executes without error for me on my Linux v9 universal db2 :) The sequence of calls being made to the driver in your case is:

Statement.execute()
Statement.getUpdateCount()
Statement.getResultSet
Statement.getMoreResults()
Statement.getUpdateCount()

I believe it is the second getUpdateCount that yields the exception - based on your earlier stack trace. It's hard to be sure, since there is no
debug output from this section of code (SQLExecuterTask.processQuery). I could look into this further if I pepper this section of code with debug
statements and make a snapshot available for you if you wanted to give that a try and report back with the debug statements. Beyond that, if there
are driver properties to be set, that would be the next thing to try. Without knowing what code exactly is being executed when the problem occurs,
it would be very difficult to provide a fix, other than just catching the exception and logging an error. The current code is tricky because it
attempts to be compatible with all databases, even though not all databases support multiple resultsets and those that do seem to diverge a bit on
exactly how it is done.

Rob

[Chris]

Logged In: YES
user_id=1941000
Originator: YES

Ok great!
Just let me know the version of the snapshot to download and I'll feed you up with the log result.

[Chris]

Logged In: YES
user_id=1941000
Originator: YES

About the driver properties, I have a password and user property. Nothing else.
When I check the boxe to use the properties, the password becomes enabled.

I hope it helps...

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Ok, I'll let you know when/where to get the snapshot installer.

Those are the same driver properties that I have. I've read that other properties are available (especially on platforms other than LUW).
Can you verify that the driver that you are using is the same as the one that was shipped with the DB2 software that was used to install
the server that you are using? (Recently I've noticed a number of bug reports for problems caused by using a driver that was newer (or different) than
the fixpak installed on the database server.)

Rob

[amr roushdi]

Logged In: YES
user_id=564324
Originator: NO

You should use the combination of db2 jcc jar as well it license . in the class path . this works for me ^lease note as well
as far as i saw the net app ( jdbc) will be depricated .
the db2jcc drivers can be downloaded at the ibm site ( fixpack , db2level +- 1 tranperent.
hope this will help you
thank you Rob