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 | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Running SchemaCrawler against SQL Server 2012 returns no tables

    schemacrawler | 11 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.

    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