java.sql.SQLWarning: ResultSet type/concurrency downgraded: [S1000] A server cursor cannot be opened on the given statem ent or statements. Use a default result set or client cursor.

schemacrawler | shomer | 6 months ago
  1. 0

    Running SchemaCrawler against SQL Server 2012 returns no tables

    schemacrawler | 6 months ago | shomer
    java.sql.SQLWarning: ResultSet type/concurrency downgraded: [S1000] A server cursor cannot be opened on the given statem ent or statements. Use a default result set or client cursor.
  2. 0

    c3p0 produces java.sql.SQLWarning: 010CP: AutoCommit option has changed to true. All pending statements on this transaction (if any) are committed.

    GitHub | 2 years ago | makhomed
    java.sql.SQLWarning: 010CP: AutoCommit option has changed to true. All pending statements on this transaction (if any) are committed.
  3. 0

    WebLogic throws SQLWarning Error when attempting to execute Procedure.

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLWarning: Unknown type specified: 0 > Server StackTrace: > [ > <not available>]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    WebLogic throws SQLWarning Error when attempting to execute Procedure.

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLWarning: Unknown type specified: 0 Server StackTrace: [ <not available>]
  6. 0

    [IBM][CLI Driver][DB2/SUN] SQL0010N SQLSTATE=42603 Error.

    Google Groups | 2 decades ago | Sanjay
    java.sql.SQLWarning: [IBM][CLI Driver][DB2/SUN] SQL0010N "'TXNKIND=31&DATE=2001%2f09%2f10%2013%3a16%3a14&CENTERID=2000&CENTER_T" &#12391;&#22987;&#12414;&#12427;&#12473;&#12488;&#12522;&#12531;&#12464;&#23450;&#25968;&#12395;&#12289;&#32066;&#12431;&#12426;&#12398;&#21306;&#20999;&#12426;&#25991;&#23383; &#12364;&#12354;&#12426;&#12414;&#12379;&#12435;&#12290; SQLSTATE=42603 Server StackTrace:

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLWarning

      ResultSet type/concurrency downgraded: [S1000] A server cursor cannot be opened on the given statem ent or statements. Use a default result set or client cursor.

      at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery()
    2. jTDS
      JtdsDatabaseMetaData.getTypeInfo
      1. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:499)
      2. net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
      3. net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getTypeInfo(JtdsDatabaseMetaData.java:1945)
      3 frames
    3. SchemaCrawler
      SchemaCrawler.lambda$crawlColumnDataTypes$0
      1. schemacrawler.crawl.DatabaseInfoRetriever.retrieveSystemColumnDataTypes(DatabaseInfoRetriever.java:400)
      2. schemacrawler.crawl.SchemaCrawler.lambda$crawlColumnDataTypes$0(SchemaCrawler.java:115)
      2 frames