java.sql.SQLException: Type Conversion not supported

JIRA | Daniel Henninger | 9 years ago
  1. 0

    I don't know if this is restricted to just the embedded DB or not, but for some reason there's conversion errors showing up from MSN contacts when stored in the db. 2007.11.03 15:48:50 org.jivesoftware.openfire.gateway.util.Log4JToOpenfireAppender.append(Log4JToOpenfireAppender.java:49) Avatar: SQL exception while inserting avatar: java.sql.SQLException: Type Conversion not supported at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source) at org.jivesoftware.openfire.gateway.avatars.Avatar.insertIntoDb(Avatar.java:226) at org.jivesoftware.openfire.gateway.avatars.Avatar.<init>(Avatar.java:109) at org.jivesoftware.openfire.gateway.protocols.oscar.BasicFlapConnection$1.handleResponse(BasicFlapConnection.java:209) at net.kano.joscar.snac.SnacRequest.gotResponse(SnacRequest.java:344) at net.kano.joscar.snac.ClientSnacProcessor.continueHandling(ClientSnacProcessor.java:727) at net.kano.joscar.snac.AbstractSnacProcessor.processPacket(AbstractSnacProcessor.java:447) at net.kano.joscar.snac.AbstractSnacProcessor.access$100(AbstractSnacProcessor.java:134) at net.kano.joscar.snac.AbstractSnacProcessor$1.handlePacket(AbstractSnacProcessor.java:208) at net.kano.joscar.flap.AbstractFlapProcessor.processPacketSynchronously(AbstractFlapProcessor.java:231) at net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.tryProcessingPackets(AsynchronousFlapProcessor.java:75) at net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.run(AsynchronousFlapProcessor.java:63) at java.lang.Thread.run(Thread.java:595)

    Jive Software Open Source | 9 years ago | Daniel Henninger
    java.sql.SQLException: Type Conversion not supported
  2. 0

    I don't know if this is restricted to just the embedded DB or not, but for some reason there's conversion errors showing up from MSN contacts when stored in the db. 2007.11.03 15:48:50 org.jivesoftware.openfire.gateway.util.Log4JToOpenfireAppender.append(Log4JToOpenfireAppender.java:49) Avatar: SQL exception while inserting avatar: java.sql.SQLException: Type Conversion not supported at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source) at org.jivesoftware.openfire.gateway.avatars.Avatar.insertIntoDb(Avatar.java:226) at org.jivesoftware.openfire.gateway.avatars.Avatar.<init>(Avatar.java:109) at org.jivesoftware.openfire.gateway.protocols.oscar.BasicFlapConnection$1.handleResponse(BasicFlapConnection.java:209) at net.kano.joscar.snac.SnacRequest.gotResponse(SnacRequest.java:344) at net.kano.joscar.snac.ClientSnacProcessor.continueHandling(ClientSnacProcessor.java:727) at net.kano.joscar.snac.AbstractSnacProcessor.processPacket(AbstractSnacProcessor.java:447) at net.kano.joscar.snac.AbstractSnacProcessor.access$100(AbstractSnacProcessor.java:134) at net.kano.joscar.snac.AbstractSnacProcessor$1.handlePacket(AbstractSnacProcessor.java:208) at net.kano.joscar.flap.AbstractFlapProcessor.processPacketSynchronously(AbstractFlapProcessor.java:231) at net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.tryProcessingPackets(AsynchronousFlapProcessor.java:75) at net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.run(AsynchronousFlapProcessor.java:63) at java.lang.Thread.run(Thread.java:595)

    JIRA | 9 years ago | Daniel Henninger
    java.sql.SQLException: Type Conversion not supported
  3. 0

    I don't know if this is restricted to just the embedded DB or not, but for some reason there's conversion errors showing up from MSN contacts when stored in the db. 2007.11.03 15:48:50 org.jivesoftware.openfire.gateway.util.Log4JToOpenfireAppender.append(Log4JToOpenfireAppender.java:49) Avatar: SQL exception while inserting avatar: java.sql.SQLException: Type Conversion not supported at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source) at org.jivesoftware.openfire.gateway.avatars.Avatar.insertIntoDb(Avatar.java:226) at org.jivesoftware.openfire.gateway.avatars.Avatar.<init>(Avatar.java:109) at org.jivesoftware.openfire.gateway.protocols.oscar.BasicFlapConnection$1.handleResponse(BasicFlapConnection.java:209) at net.kano.joscar.snac.SnacRequest.gotResponse(SnacRequest.java:344) at net.kano.joscar.snac.ClientSnacProcessor.continueHandling(ClientSnacProcessor.java:727) at net.kano.joscar.snac.AbstractSnacProcessor.processPacket(AbstractSnacProcessor.java:447) at net.kano.joscar.snac.AbstractSnacProcessor.access$100(AbstractSnacProcessor.java:134) at net.kano.joscar.snac.AbstractSnacProcessor$1.handlePacket(AbstractSnacProcessor.java:208) at net.kano.joscar.flap.AbstractFlapProcessor.processPacketSynchronously(AbstractFlapProcessor.java:231) at net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.tryProcessingPackets(AsynchronousFlapProcessor.java:75) at net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.run(AsynchronousFlapProcessor.java:63) at java.lang.Thread.run(Thread.java:595)

    Jive Software Open Source | 9 years ago | Daniel Henninger
    java.sql.SQLException: Type Conversion not supported
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    saving a Blob in the CRUD admin.

    Google Groups | 6 years ago | dimitri
    org.hibernate.exception.DataException: could not insert: [models.Candidat] org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java: 1235)
  6. 0

    Hello! I have following problem: when using HQL query "select item.id, item.name from Item as item where item.class = ?" and trying to use clause Query.setParameter (0, SubItem.class) I am getting following exception from underlying database since hibernate doese not properly convert parameter into associated discriminator value: 2006-06-14 15:04:30,828 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: -16, SQLState: 37000> 2006-06-14 15:04:30,828 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: -16, SQLState: 37000> 2006-06-14 15:04:30,843 ERROR [org.hibernate.util.JDBCExceptionReporter] - <Wrong data type: For input string: "Item"> 2006-06-14 15:04:30,843 ERROR [org.hibernate.util.JDBCExceptionReporter] - <Wrong data type: For input string: "Item"> org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select abstractco0_.id as col_0_0_, abstractco0_.name as col_1_0_ from TABLE abstractco0_ where abstractco0_.type=?]; SQL state [37000]; error code [-16]; Wrong data type: For input string: "Item"; nested exception is java.sql.SQLException: Wrong data type: For input string: "Item java.sql.SQLException: Wrong data type: For input string: "Item" at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source) at org.hibernate.type.StringType.set(StringType.java:24) at org.hibernate.type.ClassType.set(ClassType.java:35) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:62) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:44) at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1115) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1177) at org.hibernate.loader.Loader.doQuery(Loader.java:390) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) at org.hibernate.loader.Loader.doList(Loader.java:1593) at org.hibernate.loader.Loader.list(Loader.java:1577) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) Please also examine bug http://opensource.atlassian.com/projects/hibernate/browse/HHH-1749 it observes situation from discriminatort to class point of view. PS. There are several forum posts regarding almost same issues: http://forum.hibernate.org/viewtopic.php?t=956408&highlight=discriminator+hql http://forum.hibernate.org/viewtopic.php?t=941125&highlight=discriminator+class+name+hql PPS. If required I could provide sample mappings and code snippets.

    Hibernate JIRA | 1 decade ago | Ignat Zapolsky
    java.sql.SQLException: Wrong data type: For input string: "Item"

    1 unregistered visitors
    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

      Type Conversion not supported

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcPreparedStatement.setString
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source)
      3. org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source)
      3 frames
    3. org.jivesoftware.openfire
      BasicFlapConnection$1.handleResponse
      1. org.jivesoftware.openfire.gateway.avatars.Avatar.insertIntoDb(Avatar.java:226)
      2. org.jivesoftware.openfire.gateway.avatars.Avatar.<init>(Avatar.java:109)
      3. org.jivesoftware.openfire.gateway.protocols.oscar.BasicFlapConnection$1.handleResponse(BasicFlapConnection.java:209)
      3 frames
    4. net.kano.joscar
      AsynchronousFlapProcessor$BackgroundPacketProcessor.run
      1. net.kano.joscar.snac.SnacRequest.gotResponse(SnacRequest.java:344)
      2. net.kano.joscar.snac.ClientSnacProcessor.continueHandling(ClientSnacProcessor.java:727)
      3. net.kano.joscar.snac.AbstractSnacProcessor.processPacket(AbstractSnacProcessor.java:447)
      4. net.kano.joscar.snac.AbstractSnacProcessor.access$100(AbstractSnacProcessor.java:134)
      5. net.kano.joscar.snac.AbstractSnacProcessor$1.handlePacket(AbstractSnacProcessor.java:208)
      6. net.kano.joscar.flap.AbstractFlapProcessor.processPacketSynchronously(AbstractFlapProcessor.java:231)
      7. net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.tryProcessingPackets(AsynchronousFlapProcessor.java:75)
      8. net.kano.joscar.flap.AsynchronousFlapProcessor$BackgroundPacketProcessor.run(AsynchronousFlapProcessor.java:63)
      8 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame