org.jooq.exception.DataAccessException: SQL [] -- SQL rendered with a free trial version of jOOQ 3.8.3]; JZ0TE: Attempted conversion between an illegal pair of types. Valid database datatypes are: 'char, unichar, varchar, univarchar, text, unitext, datetime, short datetime, date, time'

tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    When i am trying to fetch data from particular table xxx i got this error

    Stack Overflow | 8 months ago | Barath Ramaligam
    org.jooq.exception.DataAccessException: SQL [] -- SQL rendered with a free trial version of jOOQ 3.8.3]; JZ0TE: Attempted conversion between an illegal pair of types. Valid database datatypes are: 'char, unichar, varchar, univarchar, text, unitext, datetime, short datetime, date, time'
  2. 0

    using date with sybase (Page 1) / Data Integration - Installation / Talend Community Forum

    talendforge.org | 11 months ago
    java.sql.SQLException: JZ009: L'erreur suivante a été détectée pendant la conversion : java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff

    Root Cause Analysis

    1. java.sql.SQLException

      JZ0TE: Attempted conversion between an illegal pair of types. Valid database datatypes are: 'char, unichar, varchar, univarchar, text, unitext, datetime, short datetime, date, time'

      at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError()
    2. com.sybase.jdbc3
      SybResultSet.getTimestamp
      1. com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
      2. com.sybase.jdbc3.tds.TdsJdbcInputStream.getDateObject(Unknown Source)
      3. com.sybase.jdbc3.jdbc.SybResultSet.getTimestamp(Unknown Source)
      3 frames
    3. jOOQ
      SelectImpl.fetchAny
      1. org.jooq.impl.CursorImpl$CursorResultSet.getTimestamp(CursorImpl.java:889)
      2. org.jooq.impl.DefaultBinding.getTimestamp(DefaultBinding.java:1985)
      3. org.jooq.impl.DefaultBinding.get(DefaultBinding.java:1375)
      4. org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1640)
      5. org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1611)
      6. org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1576)
      7. org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:128)
      8. org.jooq.impl.CursorImpl$CursorIterator.fetchOne(CursorImpl.java:1540)
      9. org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1507)
      10. org.jooq.impl.CursorImpl.fetch(CursorImpl.java:329)
      11. org.jooq.impl.CursorImpl.fetchOne(CursorImpl.java:287)
      12. org.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:711)
      13. org.jooq.impl.SelectImpl.fetchAny(SelectImpl.java:3050)
      13 frames
    4. Unknown
      Test1.main
      1. Test1.makeConnection(Test1.java:43)
      2. Test1.main(Test1.java:85)
      2 frames