java.sql.SQLException: Conversion class is null

Oracle Community | 828655 | 6 years ago
  1. 0

    Conversion class is null

    Oracle Community | 6 years ago | 828655
    java.sql.SQLException: Conversion class is null
  2. 0

    SQL Exception with Oracle Thin JDBC drivers

    Google Groups | 2 decades ago | gm...@yahoo.com
    java.sql.SQLException: Internal error: NLS Conversion ratio 0 is invalid
  3. 0

    SQL Exception with Oracle Thin JDBC drivers

    Google Groups | 2 decades ago | gm...@yahoo.com
    java.sql.SQLException: Internal error: NLS Conversion ratio 0 is invalid
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Error executing update

    GitHub | 9 months ago | j-larson
    java.sql.SQLException: Panic: interface conversion: value.floatValue is not *value.AnnotatedValue: missing method Attachments - cause: interface conversion: value.floatValue is not value.AnnotatedValue: missing method Attachments
  6. 0

    Spoon can't read DATE columns from Hortonworks. If I convert the source column to TIMESTAMP it works fine. hive> desc entrance_summary; OK visits int createdday date createdhour int productid int campaignid int country string devicetype string network string networktypes string osname string ------ Spoon Table Input step: select visits ,createdday ,createdhour ,productid ,campaignid ,country ,devicetype ,network ,networktypes ,osname from entrance_summary limit 10 Error: 2015/03/12 09:25:11 - Spoon - Asking for repository 2015/03/12 09:25:11 - RepositoriesMeta - Reading repositories XML file: Z:\data-integration\repositories.xml 2015/03/12 09:25:11 - Version checker - OK 2015/03/12 09:25:16 - Spoon - Connected to metastore : repo, added to delegating metastore 2015/03/12 11:10:16 - /hadoop/trans_load_hadoop_campaign_offer_conversion_entrance - Dispatching started for transformation [/hadoop/trans_load_hadoop_campaign_offer_conversion_entrance] 2015/03/12 11:10:17 - entrance hadoop input.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error 2015/03/12 11:10:17 - entrance hadoop input.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2015/03/12 11:10:17 - entrance hadoop input.0 - Couldn't get row from result set 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - Unable to get value 'Date' from database resultset, index 1 2015/03/12 11:10:17 - entrance hadoop input.0 - Illegal conversion 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2357) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2328) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2306) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/03/12 11:10:17 - entrance hadoop input.0 - at java.lang.Thread.run(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2015/03/12 11:10:17 - entrance hadoop input.0 - Unable to get value 'Date' from database resultset, index 1 2015/03/12 11:10:17 - entrance hadoop input.0 - Illegal conversion 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4688) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2349) 2015/03/12 11:10:17 - entrance hadoop input.0 - ... 6 more 2015/03/12 11:10:17 - entrance hadoop input.0 - Caused by: java.sql.SQLException: Illegal conversion 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.apache.hive.jdbc.HiveBaseResultSet.getTimestamp(HiveBaseResultSet.java:560) 2015/03/12 11:10:17 - entrance hadoop input.0 - at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at java.lang.reflect.Method.invoke(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$ResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:746) 2015/03/12 11:10:17 - entrance hadoop input.0 - at com.sun.proxy.$Proxy22.getTimestamp(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4670) 2015/03/12 11:10:17 - entrance hadoop input.0 - ... 9 more 2015/03/12 11:10:17 - entrance hadoop input.0 - Finished reading query, closing connection. 2015/03/12 11:10:17 - entrance hadoop input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2015/03/12 11:10:17 - /hadoop/trans_load_hadoop_campaign_offer_conversion_entrance - Transformation detected one or more steps with errors. 2015/03/12 11:10:17 - /hadoop/trans_load_hadoop_campaign_offer_conversion_entrance - Transformation is killing the other steps!

    Pentaho BI Platform Tracking | 2 years ago | Geoffrey Cleaves
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 1 Illegal conversion

    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.SQLException

      Conversion class is null

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      PhysicalConnection.getDbCsId
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
      4. oracle.jdbc.driver.PhysicalConnection.getDbCsId(PhysicalConnection.java:2692)
      4 frames
    3. oracle.xdb
      XMLType.createXML
      1. oracle.xdb.XMLType.<init>(XMLType.java:1079)
      2. oracle.xdb.XMLType.createXML(XMLType.java:583)
      3. oracle.xdb.XMLType.createXML(XMLType.java:565)
      3 frames