|
From: <eri...@gm...> - 2014-03-03 16:09:33
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html><head> <meta content="text/html; charset=unicode" http-equiv="Content-Type"> <meta name="GENERATOR" content="MSHTML 9.00.8112.16533"></head> <body> <div> <div>All,</div> <div> </div> <div>After our organization upgraded from AS400 DB2 (5.3 i believe) to 7.1, SQuirrel is no longer able to list out the tables for a namespace.</div> <div> <div> </div> <div>What I did to try to get this working:</div> <div> </div> <div>- I upgraded squirrel to 3.5.1, no go</div>- I upgraded the JTOpen (as/400) drivers, no go.</div> <div>- I recreated the connection using the new drivers, no go.</div> <div> <div>- I created a JDBC connection from eclipse (ugh) and it does work with the new updated drivers. </div>- I set debug enabled and I get these failures when I do a 'refresh all' to view the tables under the namespace</div> <div> </div> <div>Any other thoughts? </div> <div> </div> <div>as400: CallableStatement STMT0002 (-953972964) : Descriptor 2 created or changed.<br>as400: Connection B10ED53C (-166244349) : Posting warning, id: 2 error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from procedure SQLGETTYPEINFO in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 result sets are available from procedure SQLGETTYPEINFO in SYSIBM.<br> at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br> at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br> at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br> at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTypeInfo(AS400JDBCDatabaseMetaData.java:5076)<br> at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:709)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:900)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:315)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br> at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br> at java.lang.Thread.run(Thread.java:773)</div> <div>as400: Connection B10ED53C (-166244349) : Posting warning, id: 2 error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from procedure SQLGETTYPEINFO in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 result sets are available from procedure SQLGETTYPEINFO in SYSIBM.<br> at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br> at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br> at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br> at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTypeInfo(AS400JDBCDatabaseMetaData.java:5076)<br> at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypes(SQLDatabaseMetaData.java:709)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:900)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:315)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br> at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br> at java.lang.Thread.run(Thread.java:773)</div> <div> </div> <div> </div> <div>as400: CallableStatement STMT0003 (1556167018) : Descriptor 3 created or changed.<br>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from procedure SQLTABLES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 result sets are available from procedure SQLTABLES in SYSIBM.<br> at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br> at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br> at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br> at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getSchemas(AS400JDBCDatabaseMetaData.java:3951)<br> at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:273)<br> at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:623)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:592)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br> at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br> at java.lang.Thread.run(Thread.java:773)</div> <div>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from procedure SQLTABLES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 result sets are available from procedure SQLTABLES in SYSIBM.<br> at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br> at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br> at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br> at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getSchemas(AS400JDBCDatabaseMetaData.java:3951)<br> at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:273)<br> at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:623)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:592)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br> at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br> at java.lang.Thread.run(Thread.java:773)</div> <div> </div> <div> </div> <div>as400: CallableStatement STMT0003 (788343637) : Descriptor 3 created or changed.<br>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from procedure SQLPROCEDURES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 result sets are available from procedure SQLPROCEDURES in SYSIBM.<br> at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br> at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br> at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br> at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getProcedures(AS400JDBCDatabaseMetaData.java:3718)<br> at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:752)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:598)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br> at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br> at java.lang.Thread.run(Thread.java:773)</div> <div>as400: Connection B10ED53C (-166244349) : Posting warning, id: 3 error class: 1 return code: 466 reason: [SQL0466] 1 result sets are available from procedure SQLPROCEDURES in SYSIBM. state: 0100C.java.sql.SQLWarning: [SQL0466] 1 result sets are available from procedure SQLPROCEDURES in SYSIBM.<br> at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:347)<br> at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1015)<br> at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1237)<br> at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getProcedures(AS400JDBCDatabaseMetaData.java:3718)<br> at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:752)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:598)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)<br> at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)<br> at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:325)<br> at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)<br> at java.lang.Thread.run(Thread.java:773)</div> <div> </div> <div> </div> <div> </div> <div> </div></div></body></html> |
