java.sql.SQLDataException: An attempt was made to get a data value of type 'DATE' from a data value of type 'java.time.LocalDate'.

db-derby-user | Martijn Blankestijn | 3 years ago
  1. 0

    JDK 8 and setObject

    db-derby-user | 3 years ago | Martijn Blankestijn
    java.sql.SQLDataException: An attempt was made to get a data value of type 'DATE' from a data value of type 'java.time.LocalDate'.
  2. 0

    Kohei Nozaki's blog

    nailedtothex.org | 8 months ago
    java.sql.SQLDataException: An attempt was made to get a data value of type 'BIGINT' from a data value of type 'entity.EmployeeName'. Error Code: 20000 Call: SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN (?,?)) bind => [EmployeeName{firstName='Scott', lastName='Vogel'}, EmployeeName{firstName='Nick', lastName='Jett'}] Query: ReadAllQuery(referenceClass=Employee sql="SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN ?)")
  3. 0

    Kohei Nozaki's blog

    nailedtothex.org | 8 months ago
    java.sql.SQLDataException: An attempt was made to get a data value of type 'BIGINT' from a data value of type 'entity.EmployeeName'. Error Code: 20000 Call: SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN (?,?)) bind => [EmployeeName{firstName='Scott', lastName='Vogel'}, EmployeeName{firstName='Nick', lastName='Jett'}] Query: ReadAllQuery(referenceClass=Employee sql="SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN ?)")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Kohei Nozaki's blog: Notes of my experiments

    nailedtothex.org | 6 months ago
    java.sql.SQLDataException: An attempt was made to get a data value of type 'BIGINT' from a data value of type 'entity.EmployeeName'. Error Code: 20000 Call: SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN (?,?)) bind => [EmployeeName{firstName='Scott', lastName='Vogel'}, EmployeeName{firstName='Nick', lastName='Jett'}] Query: ReadAllQuery(referenceClass=Employee sql="SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN ?)")
  6. 0

    Kohei Nozaki's blog: Notes of my experiments

    nailedtothex.org | 6 months ago
    java.sql.SQLDataException: An attempt was made to get a data value of type 'BIGINT' from a data value of type 'entity.EmployeeName'. Error Code: 20000 Call: SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN (?,?)) bind => [EmployeeName{firstName='Scott', lastName='Vogel'}, EmployeeName{firstName='Nick', lastName='Jett'}] Query: ReadAllQuery(referenceClass=Employee sql="SELECT ID, FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE (ID IN ?)")

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

      An attempt was made to get a data value of type 'DATE' from a data value of type 'java.time.LocalDate'.

      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException()
    2. Derby
      EmbedPreparedStatement.setObject
      1. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(UnknownSource)
      2. org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      3. org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      4. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      5. org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(UnknownSource)
      6. org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(UnknownSource)
      7. org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(UnknownSource)
      8. org.apache.derby.impl.jdbc.EmbedPreparedStatement.setObject(UnknownSource)
      8 frames
    3. nl.ordina.jdk8
      TimePersistenceTest.insertParameterSetObject
      1. nl.ordina.jdk8.TimePersistenceTest.insertParameterSetObject(TimePersistenceTest.java:48)
      1 frame