Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-7047

derby classCastException during SELECT statement

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.14.2.0
    • None
    • SQL, Store
    • None
    • Normal
    • Seen in production

    Description

      we use embedded derby for tests and get a ClassCastException during performing a select statement when multiple threads are executing the following statement.

      seems similar to the following ticket:
      https://issues.apache.org/jira/browse/HIVE-16362

      "SELECT * FROM node_props WHERE node_id = ?"

      our Derby jdbc version is : 

      org.apache.derby:10.14.2.0

       following is our SELECT Statement:

      Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
      at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184)
      at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152)
      at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85)
      at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163)

      Attachments

        Activity

          People

            Unassigned Unassigned
            yoaz Yoaz
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: