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'

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Sybase Stored Procedure out parameters error
    via Stack Overflow by jFram
    ,
  • sybase jdbc connection issue
    via Stack Overflow by buttowski
    ,
    • 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' at org.jooq.impl.Tools.translate(Tools.java:1941) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:659) at org.jooq.impl.CursorImpl$CursorIterator.fetchOne(CursorImpl.java:1556) at org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1507) at org.jooq.impl.CursorImpl.fetch(CursorImpl.java:329) at org.jooq.impl.CursorImpl.fetchOne(CursorImpl.java:287) at org.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:711) at org.jooq.impl.SelectImpl.fetchAny(SelectImpl.java:3050) at Test1.makeConnection(Test1.java:43) at Test1.main(Test1.java:85) Caused by: 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(Unknown Source) at com.sybase.jdbc3.tds.TdsJdbcInputStream.getDateObject(Unknown Source) at com.sybase.jdbc3.jdbc.SybResultSet.getTimestamp(Unknown Source) at org.jooq.impl.CursorImpl$CursorResultSet.getTimestamp(CursorImpl.java:889) at org.jooq.impl.DefaultBinding.getTimestamp(DefaultBinding.java:1985) at org.jooq.impl.DefaultBinding.get(DefaultBinding.java:1375) at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1640) at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1611) at org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1576) at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:128) at org.jooq.impl.CursorImpl$CursorIterator.fetchOne(CursorImpl.java:1540) ... 7 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    8 more bugmates