15 Jun 2012 20:58
Re: JCC Version Mismatch Error for DB2 for i?
Anurag Shekhar3 <a.shekhar <at> in.ibm.com>
2012-06-15 18:58:46 GMT
2012-06-15 18:58:46 GMT
I will look into it.
anurag
From: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
To: squirrel-sql-users <at> lists.sourceforge.net
Cc: Manish Sehgal/Menlo Park/IBM <at> IBMUS, Brent Gross/Toronto/IBM <at> IBMCA, Kent Milligan/Rochester/IBM <at> IBMUS, Anurag Shekhar3/India/IBM <at> IBMIN
Date: 06/16/12 12:08 AM
Subject: Re: JCC Version Mismatch Error for DB2 for i?
Hello,
Could somebody please take a look to see whether the following warning is issued by Squirrel? If it is, why does Squirrel issue the message? The JCC driver is JDBC4 compliant.
Hi Anurag,
Could somebody in your team follow up to see whether there is anything else need to be done on JCC side? Thanks!
Best Regards,
Huaxin Gao
Phone: (408) 463-5825
Notes Address: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Internet Address: huaxing <at> us.ibm.com
From: Kent Milligan/Rochester/IBM
To: Huaxin Gao/Silicon Valley/IBM <at> IBMUS,
Cc: Manish Sehgal/Menlo Park/IBM <at> IBMUS, Brent Gross/Toronto/IBM <at> IBMCA
Date: 06/15/2012 11:06 AM
Subject: Re: JCC Version Mismatch Error for DB2 for i?
Huaxin,
I didn't hear back if you were going to contact Squirrel to determine the cause of this Version Mismatch window when using JCC to connect to a DB2 for i server?
Kent Milligan, DB2 for i Senior Certified IT Specialist
STG ISV Enablement-IBM i http://ibm.com/partnerworld/i
kmill <at> us.ibm.com, 507 253 5301 -- ibm.com/systems/i/db2
From: Huaxin Gao/Silicon Valley/IBM
To: Kent Milligan/Rochester/IBM <at> IBMUS
Cc: Manish Sehgal/Menlo Park/IBM <at> IBMUS
Date: 06/08/2012 06:14 PM
Subject: Re: JCC Version Mismatch Error?
JCC driver is JDBC4 compliant. Could you please ask Squirrel why they issue error for us?
Best Regards,
Huaxin Gao
Phone: (408) 463-5825
Notes Address: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Internet Address: huaxing <at> us.ibm.com
Any ideas why the JCC driver would only be doing this behavior for DB2 for i server thru Squirrel?
Kent Milligan, DB2 for i Senior Certified IT Specialist
STG ISV Enablement-IBM i http://ibm.com/partnerworld/i
kmill <at> us.ibm.com, 507 253 5301 -- ibm.com/systems/i/db2
From: Nigel Campbell/Ottawa/IBM <at> IBMCA
To: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Cc: Kent Milligan/Rochester/IBM <at> IBMUS
Date: 06/06/2012 02:13 PM
Subject: Re: JCC Version Mismatch Error?
The warning is reported by SQLSquirrel (can be disabled). I do not get the feedback in SQLSquirrel when connect to LUW 10.1, 9.7 etc nor Z 10 etc with the same driver.
It is interesting that while my license jar looks old that no message surfaces when I connect to Z or LUW only I.
jcc IBM Data Server Driver for JDBC and SQLJ 4.13.80
IBM J9 VM, 1.6.0, pwi3260sr10fp1ifx-20120412_01 (SR10 FP1)
[attachment "db2jcc.jar" deleted by Kent Milligan/Rochester/IBM] [attachment "db2jcc_license_cisuz.jar" deleted by Kent Milligan/Rochester/IBM] [attachment "db2jcc4.jar" deleted by Kent Milligan/Rochester/IBM]
-----------------------------
Nigel Campbell
IBM Business Analytics - Cognos Software
Nigel.Campbell <at> ca.ibm.com
613-356-6549 (Office)
-----------------------------
From: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
To: Kent Milligan/Rochester/IBM <at> IBMUS
Cc: Nigel Campbell/Ottawa/IBM <at> IBMCA
Date: 05/06/2012 05:12 PM
Subject: Re: JCC Version Mismatch Error?
Hi Nigel,
Are you sure that you are using JCC driver? Could it be possible that you are using the iSeries JDBC driver?
Best Regards,
Huaxin Gao
Phone: (408) 463-5825
Notes Address: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Internet Address: huaxing <at> us.ibm.com
Huaxin,
Nigel from Cognos is using the JCC driver to connect to a DB2 for i server. This connection is generating the following JDBC Version Mismatch status window below. Do you know what would cause that behavior?
Kent Milligan, DB2 for i Senior Certified IT Specialist
STG ISV Enablement-IBM i http://ibm.com/partnerworld/i
kmill <at> us.ibm.com, 507 253 5301 -- ibm.com/systems/i/db2
----- Forwarded by Kent Milligan/Rochester/IBM on 06/05/2012 04:03 PM -----
From: Nigel Campbell/Ottawa/IBM <at> IBMCA
To: Kent Milligan/Rochester/IBM <at> IBMUS
Date: 06/01/2012 03:31 PM
Subject: couple of questions
Our remote V7R1 system (QSQ07010)
JDBC driver JCC 4.13.80 which is JDBC 4.0
anurag
From: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
To: squirrel-sql-users <at> lists.sourceforge.net
Cc: Manish Sehgal/Menlo Park/IBM <at> IBMUS, Brent Gross/Toronto/IBM <at> IBMCA, Kent Milligan/Rochester/IBM <at> IBMUS, Anurag Shekhar3/India/IBM <at> IBMIN
Date: 06/16/12 12:08 AM
Subject: Re: JCC Version Mismatch Error for DB2 for i?
Hello,
Could somebody please take a look to see whether the following warning is issued by Squirrel? If it is, why does Squirrel issue the message? The JCC driver is JDBC4 compliant.
Hi Anurag,
Could somebody in your team follow up to see whether there is anything else need to be done on JCC side? Thanks!
Best Regards,
Huaxin Gao
Phone: (408) 463-5825
Notes Address: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Internet Address: huaxing <at> us.ibm.com
From: Kent Milligan/Rochester/IBM
To: Huaxin Gao/Silicon Valley/IBM <at> IBMUS,
Cc: Manish Sehgal/Menlo Park/IBM <at> IBMUS, Brent Gross/Toronto/IBM <at> IBMCA
Date: 06/15/2012 11:06 AM
Subject: Re: JCC Version Mismatch Error for DB2 for i?
Huaxin,
I didn't hear back if you were going to contact Squirrel to determine the cause of this Version Mismatch window when using JCC to connect to a DB2 for i server?
Kent Milligan, DB2 for i Senior Certified IT Specialist
STG ISV Enablement-IBM i http://ibm.com/partnerworld/i
kmill <at> us.ibm.com, 507 253 5301 -- ibm.com/systems/i/db2
From: Huaxin Gao/Silicon Valley/IBM
To: Kent Milligan/Rochester/IBM <at> IBMUS
Cc: Manish Sehgal/Menlo Park/IBM <at> IBMUS
Date: 06/08/2012 06:14 PM
Subject: Re: JCC Version Mismatch Error?
JCC driver is JDBC4 compliant. Could you please ask Squirrel why they issue error for us?
Best Regards,
Huaxin Gao
Phone: (408) 463-5825
Notes Address: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Internet Address: huaxing <at> us.ibm.com
| From: | Kent Milligan/Rochester/IBM |
| To: | Huaxin Gao/Silicon Valley/IBM <at> IBMUS |
| Date: | 06/08/2012 03:51 PM |
| Subject: | Re: JCC Version Mismatch Error? |
Any ideas why the JCC driver would only be doing this behavior for DB2 for i server thru Squirrel?
Kent Milligan, DB2 for i Senior Certified IT Specialist
STG ISV Enablement-IBM i http://ibm.com/partnerworld/i
kmill <at> us.ibm.com, 507 253 5301 -- ibm.com/systems/i/db2
From: Nigel Campbell/Ottawa/IBM <at> IBMCA
To: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Cc: Kent Milligan/Rochester/IBM <at> IBMUS
Date: 06/06/2012 02:13 PM
Subject: Re: JCC Version Mismatch Error?
The warning is reported by SQLSquirrel (can be disabled). I do not get the feedback in SQLSquirrel when connect to LUW 10.1, 9.7 etc nor Z 10 etc with the same driver.
It is interesting that while my license jar looks old that no message surfaces when I connect to Z or LUW only I.
jcc IBM Data Server Driver for JDBC and SQLJ 4.13.80
IBM J9 VM, 1.6.0, pwi3260sr10fp1ifx-20120412_01 (SR10 FP1)
|
Property Name
|
Value
|
| JDBC Driver CLASSNAME | com.ibm.db2.jcc.DB2Driver |
| JDBC Driver CLASSPATH | C:\JDBC\db2jcc_license_cisuz.jar;C:\JDBC\db2jcc_license_cu.jar;C:\JDBC\db2jcc4.jar |
| allProceduresAreCallable | false |
| allTablesAreSelectable | false |
| dataDefinitionCausesTransactionCommit | false |
| dataDefinitionIgnoredInTransactions | false |
| doesMaxRowSizeIncludeBlobs | true |
| getCatalogSeparator | . |
| getCatalogTerm | <null> |
| getDatabaseMajorVersion | 7 |
| getDatabaseMinorVersion | 1 |
| getDatabaseProductName | AS |
| getDatabaseProductVersion | QSQ07010 |
| getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED |
| getDriverMajorVersion | 4 |
| getDriverMinorVersion | 13 |
| getDriverName | IBM Data Server Driver for JDBC and SQLJ |
| getDriverVersion | 4.13.80 |
| getExtraNameCharacters | $ <at> # |
| getIdentifierQuoteString | " |
| getJDBCMajorVersion | 4 |
| getJDBCMinorVersion | 0 |
| getMaxBinaryLiteralLength | 65480 |
| getMaxCatalogNameLength | 18 |
| getMaxCharLiteralLength | 32739 |
| getMaxColumnNameLength | 30 |
| getMaxColumnsInGroupBy | 120 |
| getMaxColumnsInIndex | 120 |
| getMaxColumnsInOrderBy | 10000 |
| getMaxColumnsInSelect | 8000 |
| getMaxColumnsInTable | 8000 |
| getMaxConnections | 0 |
| getMaxCursorNameLength | 128 |
| getMaxIndexLength | 2000 |
| getMaxProcedureNameLength | 128 |
| getMaxRowSize | 32766 |
| getMaxSchemaNameLength | 10 |
| getMaxStatementLength | 65535 |
| getMaxStatements | 999 |
| getMaxTableNameLength | 128 |
| getMaxTablesInSelect | 256 |
| getMaxUserNameLength | 10 |
| getProcedureTerm | procedure |
| getResultSetHoldability | 1 |
| getSchemaTerm | schema |
| getSearchStringEscape | \ |
| getSQLStateType | 2 |
| getURL | jdbc:db2://toras2ee.torolab.ibm.com:446/I7CGN01 |
| getUserName | dbcert |
| isCatalogAtStart | true |
| isReadOnly | false |
| locatorsUpdateCopy | true |
| nullPlusNonNullIsNull | true |
| nullsAreSortedAtEnd | false |
| nullsAreSortedAtStart | false |
| nullsAreSortedHigh | true |
| nullsAreSortedLow | false |
| storesLowerCaseIdentifiers | false |
| storesLowerCaseQuotedIdentifiers | false |
| storesMixedCaseIdentifiers | false |
| storesMixedCaseQuotedIdentifiers | false |
| storesUpperCaseIdentifiers | true |
| storesUpperCaseQuotedIdentifiers | false |
| supportsAlterTableWithAddColumn | true |
| supportsAlterTableWithDropColumn | true |
| supportsANSI92EntryLevelSQL | true |
| supportsANSI92FullSQL | false |
| supportsANSI92IntermediateSQL | true |
| supportsBatchUpdates | true |
| supportsCatalogsInDataManipulation | false |
| supportsCatalogsInIndexDefinitions | false |
| supportsCatalogsInPrivilegeDefinitions | false |
| supportsCatalogsInProcedureCalls | false |
| supportsCatalogsInTableDefinitions | false |
| supportsColumnAliasing | true |
| supportsConvert | false |
| supportsCoreSQLGrammar | true |
| supportsCorrelatedSubqueries | true |
| supportsDataDefinitionAndDataManipulationTransactions | true |
| supportsDataManipulationTransactionsOnly | false |
| supportsDifferentTableCorrelationNames | false |
| supportsExpressionsInOrderBy | false |
| supportsExtendedSQLGrammar | false |
| supportsFullOuterJoins | false |
| supportsGetGeneratedKeys | false |
| supportsGroupBy | true |
| supportsGroupByBeyondSelect | true |
| supportsGroupByUnrelated | true |
| supportsIntegrityEnhancementFacility | true |
| supportsLikeEscapeClause | true |
| supportsLimitedOuterJoins | true |
| supportsMinimumSQLGrammar | true |
| supportsMixedCaseIdentifiers | false |
| supportsMixedCaseQuotedIdentifiers | true |
| supportsMultipleOpenResults | true |
| supportsMultipleResultSets | true |
| supportsMultipleTransactions | true |
| supportsNamedParameters | false |
| supportsNonNullableColumns | true |
| supportsOpenCursorsAcrossCommit | true |
| supportsOpenCursorsAcrossRollback | false |
| supportsOpenStatementsAcrossCommit | true |
| supportsOpenStatementsAcrossRollback | true |
| supportsOrderByUnrelated | true |
| supportsOuterJoins | true |
| supportsPositionedDelete | true |
| supportsPositionedUpdate | true |
| supportsSavepoints | true |
| supportsSchemasInDataManipulation | true |
| supportsSchemasInIndexDefinitions | true |
| supportsSchemasInPrivilegeDefinitions | true |
| supportsSchemasInProcedureCalls | true |
| supportsSchemasInTableDefinitions | true |
| supportsSelectForUpdate | true |
| supportsStatementPooling | false |
| supportsStoredProcedures | true |
| supportsSubqueriesInComparisons | true |
| supportsSubqueriesInExists | true |
| supportsSubqueriesInIns | true |
| supportsSubqueriesInQuantifieds | true |
| supportsTableCorrelationNames | true |
| supportsTransactions | true |
| supportsUnion | true |
| supportsUnionAll | true |
| usesLocalFilePerTable | false |
| usesLocalFiles | false |
| getRowIdLifetime | ROWID_VALID_FOREVER |
| supportsStoredFunctionsUsingCallSyntax | false |
| autoCommitFailureClosesAllResultSets | false |
| getClientInfoProperties | ApplicationName 255 The name of the application currently
utilizing the connection. This is stored in DB2 special register CURRENT
CLIENT_WRKSTNNAME. ClientAccountingInformation 255 The value of the accounting string from the client information that is specified for the connection. This is stored in DB2 special register CURRENT CLIENT_ACCTNG. ClientHostname 255 TP-CAMPBELNIGEL The hostname of the computer the application using the connection is running on. This is stored in DB2 special register CURRENT CLIENT_WRKSTNNAME. ClientUser 255 The name of the user that the application using the connection is performing work for. This is stored in DB2 special register CURRENT CLIENT_USERID. |
[attachment "db2jcc.jar" deleted by Kent Milligan/Rochester/IBM] [attachment "db2jcc_license_cisuz.jar" deleted by Kent Milligan/Rochester/IBM] [attachment "db2jcc4.jar" deleted by Kent Milligan/Rochester/IBM]
-----------------------------
Nigel Campbell
IBM Business Analytics - Cognos Software
Nigel.Campbell <at> ca.ibm.com
613-356-6549 (Office)
-----------------------------
From: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
To: Kent Milligan/Rochester/IBM <at> IBMUS
Cc: Nigel Campbell/Ottawa/IBM <at> IBMCA
Date: 05/06/2012 05:12 PM
Subject: Re: JCC Version Mismatch Error?
Hi Nigel,
Are you sure that you are using JCC driver? Could it be possible that you are using the iSeries JDBC driver?
Best Regards,
Huaxin Gao
Phone: (408) 463-5825
Notes Address: Huaxin Gao/Silicon Valley/IBM <at> IBMUS
Internet Address: huaxing <at> us.ibm.com
| From: | Kent Milligan/Rochester/IBM |
| To: | Huaxin Gao/Silicon Valley/IBM <at> IBMUS |
| Cc: | Nigel Campbell/Ottawa/IBM <at> IBMCA |
| Date: | 06/05/2012 02:08 PM |
| Subject: | JCC Version Mismatch Error? |
Huaxin,
Nigel from Cognos is using the JCC driver to connect to a DB2 for i server. This connection is generating the following JDBC Version Mismatch status window below. Do you know what would cause that behavior?
Kent Milligan, DB2 for i Senior Certified IT Specialist
STG ISV Enablement-IBM i http://ibm.com/partnerworld/i
kmill <at> us.ibm.com, 507 253 5301 -- ibm.com/systems/i/db2
----- Forwarded by Kent Milligan/Rochester/IBM on 06/05/2012 04:03 PM -----
From: Nigel Campbell/Ottawa/IBM <at> IBMCA
To: Kent Milligan/Rochester/IBM <at> IBMUS
Date: 06/01/2012 03:31 PM
Subject: couple of questions
Our remote V7R1 system (QSQ07010)
JDBC driver JCC 4.13.80 which is JDBC 4.0
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
RSS Feed