Hi,

I'm getting a NullPointerException when trying to select a record.

Table is:

CREATE TABLE EMAIL_QUEUE (" +
                "EMAIL_QUEUE_ID LONG IDENTITY," +
                "EMAIL_DATA TEXT," +
                "ERROR_COUNT INTEGER," +
                "ERROR_TIME DATETIME" +
                ");

Connection String

jdbc:h2:DATABASE_NAME;MVCC=TRUE;CACHE_SIZE=256000

If I change the TEXT field to VARCHAR it works fine.

Looks like an issue with the TEXT field? And probably MVCC ?. I didn't try it without MVCC. I like MVCC :)


Thanks, Ryan


Stack Trace

org.jooq.exception.DataAccessException: SQL [select "PUBLIC"."EMAIL_QUEUE"."EMAIL_QUEUE_ID", "PUBLIC"."EMAIL_QUEUE"."EMAIL_DATA", "PUBLIC"."EMAIL_QUEUE"."ERROR_COUNT", "PUBLIC"."EMAIL_QUEUE"."ERROR_TIME" from "PUBLIC"."EMAIL_QUEUE" where "PUBLIC"."EMAIL_QUEUE"."EMAIL_QUEUE_ID" = cast(? as bigint) for update]; General error: "java.lang.NullPointerException" [50000-170]
    at org.jooq.impl.Util.translate(Util.java:649)
at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:360)
    at org.jooq.impl.CursorImpl$CursorIterator.fetch(CursorImpl.java:1280)
    at org.jooq.impl.CursorImpl$CursorIterator.next(CursorImpl.java:1241)
    at org.jooq.impl.CursorImpl$CursorIterator.next(CursorImpl.java:1211)
    at org.jooq.impl.CursorImpl.fetch(CursorImpl.java:169)
    at org.jooq.impl.CursorImpl.fetch(CursorImpl.java:143)
at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:209)
    at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:258)
at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:274) at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:413) at org.jooq.impl.TableRecordImpl.checkIfChanged(TableRecordImpl.java:325)
    at org.jooq.impl.TableRecordImpl.deleteUsing(TableRecordImpl.java:276)
at org.jooq.impl.UpdatableRecordImpl.delete(UpdatableRecordImpl.java:83) at au.com.greatlivinghomes.buildflow.Email.sendQueuedEmails(Email.java:105)
    at au.com.greatlivinghomes.buildflow.Email$1.run(Email.java:42)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-170]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:158)
    at org.h2.message.DbException.convert(DbException.java:281)
    at org.h2.message.DbException.toSQLException(DbException.java:254)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:368)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:277)
at org.jooq.impl.FieldTypeHelper.getFromResultSet(FieldTypeHelper.java:455) at org.jooq.impl.FieldTypeHelper.getFromResultSet(FieldTypeHelper.java:392) at org.jooq.impl.CursorImpl$CursorIterator.setValue(CursorImpl.java:1298)
    at org.jooq.impl.CursorImpl$CursorIterator.fetch(CursorImpl.java:1272)
    ... 14 more
Caused by: java.lang.NullPointerException
    at org.h2.value.ValueLobDb.getInputStream(ValueLobDb.java:293)
    at org.h2.value.ValueLobDb.getReader(ValueLobDb.java:279)
    at org.h2.value.ValueLobDb.getString(ValueLobDb.java:200)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:275)
    ... 18 more

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to