java.sql.SQLException: [SQL0204] SYSTABLES in SYSIBM type *FILE not found. You can resolve this issue by creating an extension of the DB2Dictionary that looks something like this: public class AS400Dictionary extends com.solarmetric.kodo.impl.jdbc.schema.dict.DB2Dictionary { public AS400Dictionary () { setValidateConnectionSQL ("some SELECT that is fast and valid"); } } The validate SQL is used from time to time when borrowing items from the connection pool to ensure that a connection is really alive, since the Connection.isClosed() method is notoriously bad at truly identifying live connections. -Patrick On Mon, 14 Jul 2003 10:54:05 +0000, Harald wrote: Hello, I was using kodo 2.4.2 with with an as400 db2 database (DB2 for OS/400 JDBC Driver). This worked fine for me. After upgrading to to kodo 2.5.2 i get the following exception: A connection could not be obtained in the specified login time of 30 seconds. [code=0;state=null] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT .... A connection could not be obtained in the specified login time of 30 seconds.

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    connection problem with as400 after upgrade to 2.5.2

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [SQL0204] SYSTABLES in SYSIBM type *FILE not found. You can resolve this issue by creating an extension of the DB2Dictionary that looks something like this: public class AS400Dictionary extends com.solarmetric.kodo.impl.jdbc.schema.dict.DB2Dictionary { public AS400Dictionary () { setValidateConnectionSQL ("some SELECT that is fast and valid"); } } The validate SQL is used from time to time when borrowing items from the connection pool to ensure that a connection is really alive, since the Connection.isClosed() method is notoriously bad at truly identifying live connections. -Patrick On Mon, 14 Jul 2003 10:54:05 +0000, Harald wrote: Hello, I was using kodo 2.4.2 with with an as400 db2 database (DB2 for OS/400 JDBC Driver). This worked fine for me. After upgrading to to kodo 2.5.2 i get the following exception: A connection could not be obtained in the specified login time of 30 seconds. [code=0;state=null] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT .... A connection could not be obtained in the specified login time of 30 seconds.
  2. 0

    error when connect to sqlserver

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Connection timed out: connect

    Root Cause Analysis

    1. java.sql.SQLException

      [SQL0204] SYSTABLES in SYSIBM type *FILE not found. You can resolve this issue by creating an extension of the DB2Dictionary that looks something like this: public class AS400Dictionary extends com.solarmetric.kodo.impl.jdbc.schema.dict.DB2Dictionary { public AS400Dictionary () { setValidateConnectionSQL ("some SELECT that is fast and valid"); } } The validate SQL is used from time to time when borrowing items from the connection pool to ensure that a connection is really alive, since the Connection.isClosed() method is notoriously bad at truly identifying live connections. -Patrick On Mon, 14 Jul 2003 10:54:05 +0000, Harald wrote: Hello, I was using kodo 2.4.2 with with an as400 db2 database (DB2 for OS/400 JDBC Driver). This worked fine for me. After upgrading to to kodo 2.5.2 i get the following exception: A connection could not be obtained in the specified login time of 30 seconds. [code=0;state=null] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT .... A connection could not be obtained in the specified login time of 30 seconds.

      at com.solarmetric.kodo.impl.jdbc.runtime.SQLExceptions.throwDataStore()
    2. com.solarmetric.kodo
      QueryImpl.execute
      1. com.solarmetric.kodo.impl.jdbc.runtime.SQLExceptions.throwDataStore(SQLExceptions.java:64)
      2. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery(JDBCStoreManager.java:1110)
      3. com.solarmetric.kodo.impl.jdbc.query.JDBCQuery.executeQuery(JDBCQuery.java:126)
      4. com.solarmetric.kodo.query.QueryImpl$DatastoreQueryExecutor.executeQuery(QueryImpl.java:1554)
      5. com.solarmetric.kodo.query.QueryImpl.executeQueryWithMap(QueryImpl.java:675)
      6. com.solarmetric.kodo.query.QueryImpl.executeWithMap(QueryImpl.java:540)
      7. com.solarmetric.kodo.query.QueryImpl.execute(QueryImpl.java:490)
      7 frames