java.sql.SQLException: Invalid argument in JDBC call: parameter index out of range: 1

hsqldb | katherina | 9 years ago
  1. 0

    Problems with setString

    hsqldb | 9 years ago | katherina
    java.sql.SQLException: Invalid argument in JDBC call: parameter index out of range: 1
  2. 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)
  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

    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"
  6. 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

    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

      Invalid argument in JDBC call: parameter index out of range: 1

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcPreparedStatement.setString
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      3. org.hsqldb.jdbc.jdbcPreparedStatement.checkSetParameterIndex(Unknown Source)
      4. org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source)
      5. org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown Source)
      5 frames