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'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Stack Overflow by Barath Ramaligam
, 1 year ago
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'
via GitHub by davidwatkins73
, 11 months ago
SQL [select .[id], .[name], .[description], .[kind], .[parent_id], .[created_at], .[updated_at] from [organisational_unit] where (CONTAINS(*, '3d AND [pr')) order by (select 0) offset 0 rows fetch next ? rows only]; Syntax error near '[' in the full-text search condition '3d AND [pr'.
via GitHub by kovax
, 9 months ago
SQL [create table if not exists EVENT(UUID varchar not null, ID int not null, TIMESTAMP timestamp with time zone not null, constraint "PK_EVENT" primary key (UUID, ID))]; length must be specified in type definition: VARCHAR in statement [create
via GitHub by kovax
, 9 months ago
SQL [create table if not exists EVENT(UUID uuid not null, ID int not null, TIMESTAMP timestamp with time zone not null, constraint "PK_EVENT" primary key (UUID, ID))]; Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS EVENT(UUID UUID NOT
via Google Groups by Unknown author, 8 months ago
SQL [select ... from [database].[dbo].[table] where ([database].[dbo].[table].[id] in (?, ?, ?, ...) or [database].[dbo].[table].[id] in (?, ?, ?, ...) or [database].[dbo].[table].[id] in (?, ?)) -- SQL rendered with a free trial version of jOOQ
via GitHub by srilakshmibodireddy
, 10 months ago
SQL [{ call "SP_UPLD_DATA"(?, ?, ?, ?) }]; Closed Statement
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 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)
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 undefined.Test1.makeConnection(Test1.java:43)
at undefined.Test1.main(Test1.java:85)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.