using GenerationType.TABLE - ERROR [MultipleHiLoPerTableGene

[fbadt]

using a table generator per the below link:
https://blueprints.dev.java.net/bpcatalog/ee5/persistence/primarykeys.html

The table has a value of type Integer and this matches the get/set in the pojo.

The error coming back is:
ERROR [MultipleHiLoPerTableGenerator] could not read or init a hi value
and the javadocs state that the type is a Long
http://www.hibernate.org/hib_docs/v3/api/org/hibernate/id/MultipleHiLoPerTableGenerator.html

This is being run against an informix 9.4 database with the Informix drivers
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

[epbernard]

hibernate cannot read the db table apparently, check that it is in your DB.

[fbadt]

yup. It is my DB. I can get to it fine with the same ID/pass via a test program to just select from the table, without "for update" and isql also.

* note: using - strategy=GenerationType.TABLE and informix drivers from
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

Here is the kicker... This is being run in JBoss 4.04 so I grabbed the hibernate 3.2rc2 source and traced into the code. It dies here as below from the below sql:

"select value from test_tab2 where key_name = 'PK_TABLE' for update"

** the same sql, without "for update", queries fine.

MultipleHiLoPerTableGenerator(line 145)
==> result = rs.getInt(1);
ERROR [MultipleHiLoPerTableGenerator] could not read or init a hi value
java.sql.SQLException: null java.lang.NullPointerException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:448)
at com.informix.jdbc.IfxValue.a(IfxValue.java:424)
at com.informix.jdbc.IfxValue.a(IfxValue.java:350)
at com.informix.jdbc.IfxRowColumn.a(IfxRowColumn.java:279)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:4340)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:654)
at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:626)
at com.informix.jdbc.IfxResultSet.getInt(IfxResultSet.java:1075)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.getInt(WrappedResultSet.java:677)
at org.hibernate.id.MultipleHiLoPerTableGenerator.doWorkInCurrentTransaction(MultipleHiLoPerTableGenerator.java:145)

[epbernard]

what is the way in Informix to acquire a row lock? AFAIK this is FOR UPDATE.

[fbadt]

Right. Use "FOR UPDATE" to get a row lock. The hibernate code appears to do this so it can udpate the counter in an atomic transaction. That seems fine. Not sure what you are trying trying to convey. Can you restate or email me in private?

[fbadt]

Switched to datadirect drivers from Informix ones and things seem to work fine now.

[fbadt]

Switched to datadirect drivers from Informix ones and things seem to work fine now.