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 | 9 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Running SchemaCrawler against SQL Server 2012 returns no tables

    schemacrawler | 9 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