java.sql.SQLException: [JDBC Driver]1

Cloudera Open Source | Jacobo Sánchez López | 1 year 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

    Executing selects using JDBC41 driver in a concurrent environment throws exceptions on accessing the result set. Enviroment must match the following: # Concurrency # Use of prepared statements even without parameters (does not happen with statements) # Queries having a very different schema (in column types and number of columns) Debugging i have found that when i receive an error there is a S41ForwardResultSet having a m_resultSetMetadata (S41ResultSetMetadata) with the columns of one query and m_parentStatement(S41PreparedStatement) with a m_preparedSql from other query Exceptions obtained from the driver are like the following: {code:java} java.sql.SQLException: [Simba][JDBC](10340) Invalid column index: 9. at com.cloudera.exceptions.ExceptionConverter.toSQLException(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.checkIfValidColumnNumber(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getData(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source) {code} {code:java} [Simba][JDBC](10140) Error converting value to long. at com.cloudera.exceptions.ExceptionConverter.toSQLException(Unknown Source) at com.cloudera.utilities.conversion.TypeConverter.toLong(Unknown Source) at com.cloudera.utilities.conversion.TypeConverter.toObject(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source) {code} {code:java} java.sql.SQLException: [JDBC Driver]1 at com.cloudera.hivecommon.api.HS2Client.getData(Unknown Source) at com.cloudera.hivecommon.dataengine.HiveJDBCResultSet.getData(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getData(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source) {code} Original use case is a client using connection pool but i managed to reproduce the problem using the Java class attached (Main.java). This class needs to be updated with connection parameters and at least two threads with queries having a very different schema (different data types and column number)

    Cloudera Open Source | 1 year ago | Jacobo Sánchez López
    java.sql.SQLException: [JDBC Driver]1
  2. 0

    Executing selects using JDBC41 driver in a concurrent environment throws exceptions on accessing the result set. Enviroment must match the following: # Concurrency # Use of prepared statements even without parameters (does not happen with statements) # Queries having a very different schema (in column types and number of columns) Debugging i have found that when i receive an error there is a S41ForwardResultSet having a m_resultSetMetadata (S41ResultSetMetadata) with the columns of one query and m_parentStatement(S41PreparedStatement) with a m_preparedSql from other query Exceptions obtained from the driver are like the following: {code:java} java.sql.SQLException: [Simba][JDBC](10340) Invalid column index: 9. at com.cloudera.exceptions.ExceptionConverter.toSQLException(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.checkIfValidColumnNumber(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getData(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source) {code} {code:java} [Simba][JDBC](10140) Error converting value to long. at com.cloudera.exceptions.ExceptionConverter.toSQLException(Unknown Source) at com.cloudera.utilities.conversion.TypeConverter.toLong(Unknown Source) at com.cloudera.utilities.conversion.TypeConverter.toObject(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source) {code} {code:java} java.sql.SQLException: [JDBC Driver]1 at com.cloudera.hivecommon.api.HS2Client.getData(Unknown Source) at com.cloudera.hivecommon.dataengine.HiveJDBCResultSet.getData(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getData(Unknown Source) at com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source) {code} Original use case is a client using connection pool but i managed to reproduce the problem using the Java class attached (Main.java). This class needs to be updated with connection parameters and at least two threads with queries having a very different schema (different data types and column number)

    Cloudera Open Source | 1 year ago | Jacobo Sánchez López
    java.sql.SQLException: [JDBC Driver]1

    Root Cause Analysis

    1. java.sql.SQLException

      [JDBC Driver]1

      at com.cloudera.hivecommon.api.HS2Client.getData()
    2. com.cloudera.hivecommon
      HiveJDBCResultSet.getData
      1. com.cloudera.hivecommon.api.HS2Client.getData(Unknown Source)
      2. com.cloudera.hivecommon.dataengine.HiveJDBCResultSet.getData(Unknown Source)
      2 frames
    3. com.cloudera.jdbc
      SForwardResultSet.getObject
      1. com.cloudera.jdbc.common.SForwardResultSet.getData(Unknown Source)
      2. com.cloudera.jdbc.common.SForwardResultSet.getObject(Unknown Source)
      2 frames