JOOQ issues

[Emrul Islam]

Hi,

I'm using the jOOQ module with jOOQ 3.8.0 and I am getting a few errors/warnings:

On startup I see:

[quasar] WARNING: Method not found in class - assuming suspendable: org/jooq/impl/DefaultDataType#getDataType(Lorg/jooq/SQLDialect;Ljava/lang/Class;)Lorg/jooq/DataType; (at org/jooq/impl/DefaultBinding#register)

[quasar] WARNING: Method not found in class - assuming suspendable: org/jooq/impl/DefaultDataType#getDataType(Lorg/jooq/SQLDialect;Ljava/lang/Class;)Lorg/jooq/DataType; (at org/jooq/impl/DefaultBinding#set)

Then, I have a Kotlin class as follows:

class FS(dataSource: DataSource) {
    val dataSource: DataSource = dataSource
    val dslContext: DSLContext
    val myInfoSql: String
    init {
        dslContext = DSL.using(dataSource, SQLDialect.POSTGRES_9_5)
        myInfoSql = dslContext.selectFrom(MyInfo.myInfo).getSQL()

    }

    fun getInfo(): List< MyInfoImpl > {
        return dslContext.fetch(myInfoSql).into(MyInfoImpl::class.java)
    }
}

The code executes and returns a list of MyInfoImpl (containing 2 elements) as expected.  However, I get the following exception:

Cannot parse array       

java.lang.NullPointerException

at co.paralleluniverse.fibers.jdbc.FiberArray$7.call(FiberArray.java:108)

at co.paralleluniverse.fibers.jdbc.FiberArray$7.call(FiberArray.java:105)

at co.paralleluniverse.fibers.FiberAsync$ThreadBlockingFiberAsync.requestSync(FiberAsync.java:473)

at co.paralleluniverse.fibers.FiberAsync.runSync(FiberAsync.java:255)

at co.paralleluniverse.fibers.FiberAsync.run(FiberAsync.java:111)

at co.paralleluniverse.fibers.FiberAsync.runBlocking(FiberAsync.java:409)

at co.paralleluniverse.fibers.jdbc.JDBCFiberAsync.exec(JDBCFiberAsync.java:29)

at co.paralleluniverse.fibers.jdbc.FiberArray.getResultSet(FiberArray.java:105)

at co.paralleluniverse.fibers.jdbc.FiberArray.getResultSet(FiberArray.java:27)

at org.jooq.impl.DefaultBinding.pgGetArray(DefaultBinding.java:2167)

at org.jooq.impl.DefaultBinding.get(DefaultBinding.java:1425)

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.fetch(CursorImpl.java:282)

at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:282)

at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:348)

at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:312)

at org.jooq.impl.DefaultDSLContext.fetch(DefaultDSLContext.java:623)

at org.test.core.db.FS.getInfo(FS.kt:30)

[Fabio Tudone]

Hi, please next time use the Comsat group for discussions about Comsat modules.

"comsat-jooq" wants to support both 7 and 8 so it integrates jOOQ 3.6.4 instead of 3.7+ (which support only Java 8). Can you try with 3.6.4? If you still have problems can you also post your full "java" command line (or your build configuration, if launching from Gradle/Maven)?

-- Fabio