Lock-when-Loaded failing - Mailing list pgsql-jdbc

Ok. This is a really weird thing I'm running into. Funny thing is, the
thing ran OK until two of the tables were set with the lock-when-loaded
consistency level.

This is with Sun Java AS 8.1, using the postgresql-8.1-405.jdbc2ee.jar
driver.

What does it mean, what am I doing wrong, or is this a bug?

It says that the DataStore doesn't support locking for update at row
level.

Here goes my (ugly) stack trace:

-----------

javax.ejb.TransactionRolledbackLocalException: Exception thrown from
bean; nested exception is:
com.sun.jdo.api.persistence.support.JDOFatalDataStoreException:
JDO76320: One of the object types involved in this query is at
consistency level "lock-when-loaded". Enforcing this consistency level
requires data store to support locking for update at row level. The
data store does not support locking for update at row level.
com.sun.jdo.api.persistence.support.JDOFatalDataStoreException:
JDO76320: One of the object types involved in this query is at
consistency level "lock-when-loaded". Enforcing this consistency level
requires data store to support locking for update at row level. The
data store does not support locking for update at row level.
    at

com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.SelectStatement.generateForUpdateClause(SelectStatement.java:337)
    at

com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.SelectStatement.generateRegularStatementText(SelectStatement.java:180)
    at

com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.SelectStatement.generateStatementText(SelectStatement.java:152)
    at
com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.Statement.getText(Statement.java:181)
    at
com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.QueryPlan.getStatements(QueryPlan.java:172)
    at
com.sun.jdo.spi.persistence.support.sqlstore.sql.RetrieveDescImpl.buildQueryPlan(RetrieveDescImpl.java:620)
    at
com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.retrieve(SQLStoreManager.java:340)
    at
com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.retrieve(PersistenceManagerImpl.java:1096)
    at
com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.doExecute(QueryImpl.java:658)
    at
com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.executeWithArray(QueryImpl.java:576)
    at

dgrmsg.serviciosbasicos.ejb.entity.FotocopiadoraBean255772716_ConcreteImpl.ejbFindByNumSerie(FotocopiadoraBean255772716_ConcreteImpl.java:424)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:147)
    at
com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:185)
    at $Proxy1192.findByNumSerie(Unknown Source)
    at
dgrmsg.serviciosbasicos.ejb.ManejoServiciosBasicosBean.crearServicioFotocopiado(ManejoServiciosBasicosBean.java:282)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:147)
    at
com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:128)
    at $Proxy1183.crearServicioFotocopiado(Unknown Source)
    at

dgrmsg.serviciosbasicos.upload.DevoradorInterfaceFotocopiadoServlet.processRequest(DevoradorInterfaceFotocopiadoServlet.java:99)
    at

dgrmsg.serviciosbasicos.upload.DevoradorInterfaceFotocopiadoServlet.doPost(DevoradorInterfaceFotocopiadoServlet.java:183)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:767)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    at
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
    at
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:257)
    at
org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
    at
org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161)
    at java.security.AccessController.doPrivileged(Native Method)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:225)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:173)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:132)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)
    at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:185)
    at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:653)
    at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:534)
    at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask(ProcessorTask.java:403)
    at
com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:55)
javax.ejb.TransactionRolledbackLocalException: Exception thrown from
bean; nested exception is:
com.sun.jdo.api.persistence.support.JDOFatalDataStoreException:
JDO76320: One of the object types involved in this query is at
consistency level "lock-when-loaded". Enforcing this consistency level
requires data store to support locking for update at row level. The
data store does not support locking for update at row level.
    at
com.sun.ejb.containers.BaseContainer.checkExceptionClientTx(BaseContainer.java:2674)
    at
com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:2526)
    at
com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:819)
    at
com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:199)
    at $Proxy1192.findByNumSerie(Unknown Source)
    at
dgrmsg.serviciosbasicos.ejb.ManejoServiciosBasicosBean.crearServicioFotocopiado(ManejoServiciosBasicosBean.java:282)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:147)
    at
com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:128)
    at $Proxy1183.crearServicioFotocopiado(Unknown Source)
    at

dgrmsg.serviciosbasicos.upload.DevoradorInterfaceFotocopiadoServlet.processRequest(DevoradorInterfaceFotocopiadoServlet.java:99)
    at

dgrmsg.serviciosbasicos.upload.DevoradorInterfaceFotocopiadoServlet.doPost(DevoradorInterfaceFotocopiadoServlet.java:183)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:767)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    at
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
    at
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:257)
    at
org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
    at
org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161)
    at java.security.AccessController.doPrivileged(Native Method)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:225)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:173)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:132)
    at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
    at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)
    at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:185)
    at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:653)
    at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:534)
    at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask(ProcessorTask.java:403)
    at
com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:55)