You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by "Zakharov, Vasily M" <va...@intel.com> on 2006/05/30 18:45:45 UTC
NPE in TranQL when using READ-COMMITTED Transaction Isolation
Hi, all,
I'm getting a NullPointerException in TranQL when changing Transaction
Isolation mode with Derby.
Is it a flaw in TranQL/Derby/connector, or I'm doing something wrong?
I have a simple entity like this:
<entity>
<ejb-name>ItemEnt</ejb-name>
<table-name>O_ITEM</table-name>
<cmp-field-mapping>
<cmp-field-name>discount</cmp-field-name>
<table-column>I_DISCOUNT</table-column>
</cmp-field-mapping>
<cmp-field-mapping>
<cmp-field-name>name</cmp-field-name>
<table-column>I_NAME</table-column>
</cmp-field-mapping>
<cmp-field-mapping>
<cmp-field-name>id</cmp-field-name>
<table-column>I_ID</table-column>
</cmp-field-mapping>
<cmp-field-mapping>
<cmp-field-name>description</cmp-field-name>
<table-column>I_DESC</table-column>
</cmp-field-mapping>
<cmp-field-mapping>
<cmp-field-name>price</cmp-field-name>
<table-column>I_PRICE</table-column>
</cmp-field-mapping>
<cmp-field-mapping>
<cmp-field-name>category</cmp-field-name>
<table-column>I_CATEGORY</table-column>
</cmp-field-mapping>
</entity>
and it works fine. However if I add the following before </entity>:
<cache>
<isolation-level>read-committed</isolation-level>
<size>100</size>
</cache>
It immediately stops working.
Addressing the entity causes NullPointerException in TranQL as shown
below.
The problem occurs if <isolation-level> is "read-committed" or
"repeatable-read"; if it is "read-uncommitted", the entity works fine.
The value of <size> doesn't matter, the effect is the same.
Does Derby support read-committed isolation? DB Info in Geronimo Console
states that it should.
I use repository/tranql/rars/tranql-connector-derby-embed-xa-1.1.rar
connector with the following deployment plan:
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.0"
configId="SPECjAppServerDB"
parentId="geronimo/system-database/1.0/car">
<resourceadapter>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-int
erface>
<connectiondefinition-instance>
<name>SPECDB</name>
<config-property-setting
name="DatabaseName">SPECDB</config-property-setting>
<connectionmanager>
<xa-transaction>
<transaction-caching/>
</xa-transaction>
<single-pool>
<max-size>100</max-size>
<min-size>10</min-size>
<blocking-timeout-milliseconds>60000</blocking-timeout-milliseconds>
<match-one/>
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
</connector>
And here's the stack:
20:19:06,856 WARN [SystemExceptionInterceptor] ItemEnt
javax.ejb.TransactionRolledbackLocalException
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:123)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextInterceptor.java:80)
at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
.java:82)
at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
va:129)
at
org.openejb.proxy.EntityEJBLocalObject$$EnhancerByCGLIB$$5c64922d.getDat
aBean(<generated>)
at
org.spec.jappserver.orders.orderses.ejb.OrderSesEJB.getItemInfo(OrderSes
EJB.java:516)
at
org.spec.jappserver.orders.orderses.ejb.OrderSesEJB.newOrder(OrderSesEJB
.java:171)
at
org.spec.jappserver.orders.orderses.ejb.OrderSesEJB$$FastClassByCGLIB$$f
f62c8dc.invoke(<generated>)
at
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
ion.java:90)
at
org.openejb.slsb.BusinessMethod.execute(BusinessMethod.java:67)
at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
:72)
at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
nentContextInterceptor.java:56)
at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
ceptor.java:81)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:119)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextInterceptor.java:80)
at
org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceIn
terceptor.java:98)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:140)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextInterceptor.java:80)
at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
.java:82)
at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
va:129)
at
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$9394b987.newOrder(<
generated>)
at
org.spec.jappserver.servlet.helper.SpecAction.doPurchase(SpecAction.java
:534)
at
org.spec.jappserver.servlet.helper.SpecAction.atomicityTestTwo(SpecActio
n.java:195)
at
org.spec.jappserver.servlet.helper.SpecServletAction.doAtomicityTests(Sp
ecServletAction.java:1304)
at
org.spec.jappserver.servlet.SpecAppServlet.performTask(SpecAppServlet.ja
va:166)
at
org.spec.jappserver.servlet.SpecAppServlet.doGet(SpecAppServlet.java:96)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at
org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.j
ava:99)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(Web
ApplicationHandler.java:830)
at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:170)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(Web
ApplicationHandler.java:821)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationH
andler.java:471)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationCon
text.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at
org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244
)
at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: java.lang.NullPointerException
at org.tranql.cache.cache.TxCache.get(TxCache.java:111)
at
org.tranql.cache.cache.FrontEndToCacheAdaptor.get(FrontEndToCacheAdaptor
.java:56)
at
org.tranql.cache.cache.FrontEndCacheDelegate.get(FrontEndCacheDelegate.j
ava:65)
at
org.tranql.cache.cache.CacheFieldFaultTransform.get(CacheFieldFaultTrans
form.java:40)
at
org.openejb.entity.cmp.CMPGetter.invokeInstance(CMPGetter.java:74)
at
org.openejb.entity.cmp.CMPMethodInterceptor.intercept(CMPMethodIntercept
or.java:75)
at
org.spec.jappserver.orders.itement.ejb.ItemCmp20EJB$$EnhancerByCGLIB$$ce
eb9f7.getDescription(<generated>)
at
org.spec.jappserver.orders.itement.ejb.ItemCmp20EJB.getDataBean(ItemCmp2
0EJB.java:245)
at
org.spec.jappserver.orders.itement.ejb.ItemCmp20EJB$$FastClassByCGLIB$$c
9f57db1.invoke(<generated>)
at
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
ion.java:90)
at
org.openejb.entity.BusinessMethod.execute(BusinessMethod.java:68)
at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
:72)
at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
nentContextInterceptor.java:56)
at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
ceptor.java:81)
at
org.openejb.entity.EntityInstanceInterceptor.invoke(EntityInstanceInterc
eptor.java:136)
at
org.openejb.entity.cmp.InTxCacheInterceptor.invoke(InTxCacheInterceptor.
java:90)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:119)
... 46 more
Vasily Zakharov
Intel Middleware Products Division
Re: NPE in TranQL when using READ-COMMITTED Transaction Isolation
Posted by Gianny Damour <gi...@optusnet.com.au>.
Hi Vasily,
This <cache> element is used to control the isolation level of the CMP
entity cache.
Basically, when a CMP or CMR field not yet loaded is accessed, this
cache is queried prior to hit the database. The isolation level which is
defined within the <cache> element is the isolation level of the cache.
Thanks for the provided stack-trace; I do know what the problem is and
will fix that tonight.
Thanks,
Gianny
Zakharov, Vasily M wrote:
>Hi, all,
>
>I'm getting a NullPointerException in TranQL when changing Transaction
>Isolation mode with Derby.
>
>Is it a flaw in TranQL/Derby/connector, or I'm doing something wrong?
>
>I have a simple entity like this:
>
><entity>
> <ejb-name>ItemEnt</ejb-name>
> <table-name>O_ITEM</table-name>
> <cmp-field-mapping>
> <cmp-field-name>discount</cmp-field-name>
> <table-column>I_DISCOUNT</table-column>
> </cmp-field-mapping>
> <cmp-field-mapping>
> <cmp-field-name>name</cmp-field-name>
> <table-column>I_NAME</table-column>
> </cmp-field-mapping>
> <cmp-field-mapping>
> <cmp-field-name>id</cmp-field-name>
> <table-column>I_ID</table-column>
> </cmp-field-mapping>
> <cmp-field-mapping>
> <cmp-field-name>description</cmp-field-name>
> <table-column>I_DESC</table-column>
> </cmp-field-mapping>
> <cmp-field-mapping>
> <cmp-field-name>price</cmp-field-name>
> <table-column>I_PRICE</table-column>
> </cmp-field-mapping>
> <cmp-field-mapping>
> <cmp-field-name>category</cmp-field-name>
> <table-column>I_CATEGORY</table-column>
> </cmp-field-mapping>
></entity>
>
>and it works fine. However if I add the following before </entity>:
>
> <cache>
> <isolation-level>read-committed</isolation-level>
> <size>100</size>
> </cache>
>
>It immediately stops working.
>
>Addressing the entity causes NullPointerException in TranQL as shown
>below.
>
>The problem occurs if <isolation-level> is "read-committed" or
>"repeatable-read"; if it is "read-uncommitted", the entity works fine.
>
>The value of <size> doesn't matter, the effect is the same.
>
>Does Derby support read-committed isolation? DB Info in Geronimo Console
>states that it should.
>
>I use repository/tranql/rars/tranql-connector-derby-embed-xa-1.1.rar
>connector with the following deployment plan:
>
><?xml version="1.0" encoding="UTF-8"?>
><connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.0"
> configId="SPECjAppServerDB"
>parentId="geronimo/system-database/1.0/car">
> <resourceadapter>
> <outbound-resourceadapter>
> <connection-definition>
>
><connectionfactory-interface>javax.sql.DataSource</connectionfactory-int
>erface>
> <connectiondefinition-instance>
> <name>SPECDB</name>
> <config-property-setting
>name="DatabaseName">SPECDB</config-property-setting>
> <connectionmanager>
> <xa-transaction>
> <transaction-caching/>
> </xa-transaction>
> <single-pool>
> <max-size>100</max-size>
> <min-size>10</min-size>
>
><blocking-timeout-milliseconds>60000</blocking-timeout-milliseconds>
> <match-one/>
> </single-pool>
> </connectionmanager>
> </connectiondefinition-instance>
> </connection-definition>
> </outbound-resourceadapter>
> </resourceadapter>
></connector>
>
>And here's the stack:
>
>20:19:06,856 WARN [SystemExceptionInterceptor] ItemEnt
>javax.ejb.TransactionRolledbackLocalException
> at
>org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
>y.java:123)
> at
>org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
>ContextInterceptor.java:80)
> at
>org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
>.java:82)
> at
>org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
> at
>org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
>va:129)
> at
>org.openejb.proxy.EntityEJBLocalObject$$EnhancerByCGLIB$$5c64922d.getDat
>aBean(<generated>)
> at
>org.spec.jappserver.orders.orderses.ejb.OrderSesEJB.getItemInfo(OrderSes
>EJB.java:516)
> at
>org.spec.jappserver.orders.orderses.ejb.OrderSesEJB.newOrder(OrderSesEJB
>.java:171)
> at
>org.spec.jappserver.orders.orderses.ejb.OrderSesEJB$$FastClassByCGLIB$$f
>f62c8dc.invoke(<generated>)
> at
>org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
>ion.java:90)
> at
>org.openejb.slsb.BusinessMethod.execute(BusinessMethod.java:67)
> at
>org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
>:72)
> at
>org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
>nentContextInterceptor.java:56)
> at
>org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
>ceptor.java:81)
> at
>org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
>y.java:119)
> at
>org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
>ContextInterceptor.java:80)
> at
>org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceIn
>terceptor.java:98)
> at
>org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
>y.java:140)
> at
>org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
>ContextInterceptor.java:80)
> at
>org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
>.java:82)
> at
>org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
> at
>org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
>va:129)
> at
>org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$9394b987.newOrder(<
>generated>)
> at
>org.spec.jappserver.servlet.helper.SpecAction.doPurchase(SpecAction.java
>:534)
> at
>org.spec.jappserver.servlet.helper.SpecAction.atomicityTestTwo(SpecActio
>n.java:195)
> at
>org.spec.jappserver.servlet.helper.SpecServletAction.doAtomicityTests(Sp
>ecServletAction.java:1304)
> at
>org.spec.jappserver.servlet.SpecAppServlet.performTask(SpecAppServlet.ja
>va:166)
> at
>org.spec.jappserver.servlet.SpecAppServlet.doGet(SpecAppServlet.java:96)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
>org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
> at
>org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.j
>ava:99)
> at
>org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(Web
>ApplicationHandler.java:830)
> at
>org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:170)
> at
>org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(Web
>ApplicationHandler.java:821)
> at
>org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationH
>andler.java:471)
> at
>org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
> at
>org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationCon
>text.java:633)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
> at org.mortbay.http.HttpServer.service(HttpServer.java:909)
> at
>org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
> at
>org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
> at
>org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
> at
>org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244
>)
> at
>org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
> at
>org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
>Caused by: java.lang.NullPointerException
> at org.tranql.cache.cache.TxCache.get(TxCache.java:111)
> at
>org.tranql.cache.cache.FrontEndToCacheAdaptor.get(FrontEndToCacheAdaptor
>.java:56)
> at
>org.tranql.cache.cache.FrontEndCacheDelegate.get(FrontEndCacheDelegate.j
>ava:65)
> at
>org.tranql.cache.cache.CacheFieldFaultTransform.get(CacheFieldFaultTrans
>form.java:40)
> at
>org.openejb.entity.cmp.CMPGetter.invokeInstance(CMPGetter.java:74)
> at
>org.openejb.entity.cmp.CMPMethodInterceptor.intercept(CMPMethodIntercept
>or.java:75)
> at
>org.spec.jappserver.orders.itement.ejb.ItemCmp20EJB$$EnhancerByCGLIB$$ce
>eb9f7.getDescription(<generated>)
> at
>org.spec.jappserver.orders.itement.ejb.ItemCmp20EJB.getDataBean(ItemCmp2
>0EJB.java:245)
> at
>org.spec.jappserver.orders.itement.ejb.ItemCmp20EJB$$FastClassByCGLIB$$c
>9f57db1.invoke(<generated>)
> at
>org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
>ion.java:90)
> at
>org.openejb.entity.BusinessMethod.execute(BusinessMethod.java:68)
> at
>org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
>:72)
> at
>org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
>nentContextInterceptor.java:56)
> at
>org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
>ceptor.java:81)
> at
>org.openejb.entity.EntityInstanceInterceptor.invoke(EntityInstanceInterc
>eptor.java:136)
> at
>org.openejb.entity.cmp.InTxCacheInterceptor.invoke(InTxCacheInterceptor.
>java:90)
> at
>org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
>y.java:119)
> ... 46 more
>
>Vasily Zakharov
>Intel Middleware Products Division
>
>
>
>
>