Bugs item #698682, was opened at 2003-03-06 04:47
Message generated for change (Comment added) made by crazyfoam
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=698682&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Mauricio Hiroshi Nagaoka (mhnagaoka)
Assigned to: Nobody/Anonymous (nobody)
Summary: DynamicQL concurrency problem
Initial Comment:
I've been using DynamicQL with CMP Entity Beans in
JBoss 3.0.6 and it's working quite well, except for a little
problem. When I've more than one client running a
DynamicQL query at the same time over the same CMP
Entity Bean, sometimes I got the following exception:
2003-02-20 18:58:29,857 ERROR
[org.jboss.ejb.plugins.LogInterceptor]
TransactionRolledbackLocalException, causedBy:
java.lang.NullPointerException
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCom
mand.execute(JDBCAbstractQueryCommand.java:161)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.e
xecute(JDBCDynamicQLQuery.java:101)
at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridg
e.execute(JDBCSelectorBridge.java:64)
at
org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationH
andler.invoke(EntityBridgeInvocationHandler.java:96)
at org.jboss.proxy.compiler.Runtime.invoke
(Runtime.java:59)
at
br.com.smbsoftware.webflow.tc.entity.TaskInfoBean$Pro
xy.ejbSelectGeneric(<generated>)
at
br.com.smbsoftware.webflow.tc.entity.TaskInfoBean.ejbH
omeSelectGeneric(TaskInfoBean.java:731)
at sun.reflect.GeneratedMethodAccessor436.invoke
(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke
Home(EntityContainer.java:1138)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.inv
okeHome(EntitySynchronizationInterceptor.java:207)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invokeHome
(CachedConnectionInterceptor.java:215)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHo
me(EntityInstanceInterceptor.java:90)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
(EntityLockInterceptor.java:79)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHo
me(EntityCreationInterceptor.java:44)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:111)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:228)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:62)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:105)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:129)
at org.jboss.ejb.EntityContainer.invokeHome
(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv
okeHome(BaseLocalContainerInvoker.java:230)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke
(LocalHomeProxy.java:110)
at $Proxy198.selectGeneric(Unknown Source)
at
br.com.smbsoftware.webflow.tc.session.TaskControlBea
n.getTaskInfoId(TaskControlBean.java:932)
at sun.reflect.GeneratedMethodAccessor483.invoke
(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterc
eptor.invoke(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invoke
(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
or.invoke(StatelessSessionInstanceInterceptor.java:77)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:107)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:228)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:92)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:130)
at org.jboss.ejb.plugins.LogInterceptor.invoke
(LogInterceptor.java:204)
at org.jboss.ejb.StatelessSessionContainer.invoke
(StatelessSessionContainer.java:313)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv
oke(BaseLocalContainerInvoker.java:301)
at
org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke
(StatelessSessionProxy.java:81)
at $Proxy208.getTaskInfoId(Unknown Source)
at
br.com.smbsoftware.webflow.tc.TaskControlDelegate.get
TaskInfoId(TaskControlDelegate.java:348)
at
br.com.smbsoftware.bombril.struts.SearchTaskAction.ex
ecute(SearchTaskAction.java:87)
at
org.apache.struts.action.RequestProcessor.processActi
onPerform(RequestProcessor.java:446)
at org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process
(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost
(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle
(ServletHolder.java:360)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatc
h(WebApplicationHandler.java:280)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:553)
at org.mortbay.http.HttpContext.handle
(HttpContext.java:1717)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle
(WebApplicationContext.java:549)
at org.mortbay.http.HttpContext.handle
(HttpContext.java:1667)
at org.mortbay.http.HttpServer.service
(HttpServer.java:862)
at org.jboss.jetty.Jetty.service(Jetty.java:497)
at org.mortbay.http.HttpConnection.service
(HttpConnection.java:759)
at org.mortbay.http.HttpConnection.handleNext
(HttpConnection.java:923)
at org.mortbay.http.HttpConnection.handle
(HttpConnection.java:776)
at org.mortbay.http.SocketListener.handleConnection
(SocketListener.java:202)
at org.mortbay.util.ThreadedServer.handle
(ThreadedServer.java:289)
at org.mortbay.util.ThreadPool$PoolThread.run
(ThreadPool.java:455)
2003-02-20 18:58:29,917 ERROR
[org.jboss.ejb.plugins.LogInterceptor]
TransactionRolledbackLocalException, causedBy:
java.lang.NullPointerException
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCom
mand.execute(JDBCAbstractQueryCommand.java:161)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.e
xecute(JDBCDynamicQLQuery.java:101)
at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridg
e.execute(JDBCSelectorBridge.java:64)
at
org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationH
andler.invoke(EntityBridgeInvocationHandler.java:96)
at org.jboss.proxy.compiler.Runtime.invoke
(Runtime.java:59)
at
br.com.smbsoftware.webflow.tc.entity.TaskInfoBean$Pro
xy.ejbSelectGeneric(<generated>)
at
br.com.smbsoftware.webflow.tc.entity.TaskInfoBean.ejbH
omeSelectGeneric(TaskInfoBean.java:731)
at sun.reflect.GeneratedMethodAccessor436.invoke
(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke
Home(EntityContainer.java:1138)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.inv
okeHome(EntitySynchronizationInterceptor.java:207)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invokeHome
(CachedConnectionInterceptor.java:215)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHo
me(EntityInstanceInterceptor.java:90)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
(EntityLockInterceptor.java:79)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHo
me(EntityCreationInterceptor.java:44)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:111)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:228)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:62)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:105)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:129)
at org.jboss.ejb.EntityContainer.invokeHome
(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv
okeHome(BaseLocalContainerInvoker.java:230)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke
(LocalHomeProxy.java:110)
at $Proxy198.selectGeneric(Unknown Source)
at
br.com.smbsoftware.webflow.tc.session.TaskControlBea
n.getTaskInfoId(TaskControlBean.java:932)
at sun.reflect.GeneratedMethodAccessor483.invoke
(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterc
eptor.invoke(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invoke
(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
or.invoke(StatelessSessionInstanceInterceptor.java:77)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:107)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:228)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:92)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:130)
at org.jboss.ejb.plugins.LogInterceptor.invoke
(LogInterceptor.java:204)
at org.jboss.ejb.StatelessSessionContainer.invoke
(StatelessSessionContainer.java:313)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv
oke(BaseLocalContainerInvoker.java:301)
at
org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke
(StatelessSessionProxy.java:81)
at $Proxy208.getTaskInfoId(Unknown Source)
at
br.com.smbsoftware.webflow.tc.TaskControlDelegate.get
TaskInfoId(TaskControlDelegate.java:348)
at
br.com.smbsoftware.bombril.struts.SearchTaskAction.ex
ecute(SearchTaskAction.java:87)
at
org.apache.struts.action.RequestProcessor.processActi
onPerform(RequestProcessor.java:446)
at org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process
(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost
(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle
(ServletHolder.java:360)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatc
h(WebApplicationHandler.java:280)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:553)
at org.mortbay.http.HttpContext.handle
(HttpContext.java:1717)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle
(WebApplicationContext.java:549)
at org.mortbay.http.HttpContext.handle
(HttpContext.java:1667)
at org.mortbay.http.HttpServer.service
(HttpServer.java:862)
at org.jboss.jetty.Jetty.service(Jetty.java:497)
at org.mortbay.http.HttpConnection.service
(HttpConnection.java:759)
at org.mortbay.http.HttpConnection.handleNext
(HttpConnection.java:923)
at org.mortbay.http.HttpConnection.handle
(HttpConnection.java:776)
at org.mortbay.http.SocketListener.handleConnection
(SocketListener.java:202)
at org.mortbay.util.ThreadedServer.handle
(ThreadedServer.java:289)
at org.mortbay.util.ThreadPool$PoolThread.run
(ThreadPool.java:455)
----------------------------------------------------------------------
Comment By: Gerald Turner (crazyfoam)
Date: 2003-12-18 19:23
Message:
Logged In: YES
user_id=571620
This problem still exists in JBoss 3.2.2 as well :(
----------------------------------------------------------------------
Comment By: Gerald Turner (crazyfoam)
Date: 2003-03-28 16:16
Message:
Logged In: YES
user_id=571620
I've just run across a similar problem using JBoss 3.0.7 RC1
(CVS 2003-02-24).
An MDB is processing messages and calls a home method on an
entity bean local home which in turn calls a a dynamic
JBossQL select method. When there are several messages on
queue and the MDBs are crunching concurrently I frequently
get SQL errors that originate the JBossQL compiler is
somehow treating the JDBC Type of a parameter incorrectly
(switched a BIGINT into a VARCHAR). When I put a big sleep
in the message producer such that only one instance of the
MDB is running at any given time then the dynamic JBossQL
execute normally. The dynamic JBossQL query does
occacionally use a VARCHAR parameter and I suspect the
compiler is caching statements and accessing the cache
incorrectly.
I copied the following log and reordered it by thread.
First comes a normal execution, then comes the bad JDBC type
execution... both queries are the same (and code paths for
that matter).
2003-03-28 15:00:12,682 1821620 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) DYNAMIC-QL: select Object(i) from
Item i where i.servingCentralOfficeLocal.code = ?1 and
i.catalogLocal.id in (?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10,
?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21)
2003-03-28 15:00:12,722 1821660 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) SQL: SELECT t0_i.Ordered_Item_Id,
t0_i.Order_Number, t0_i.Order_System,
t0_i.Nen_Circuit_Number, t0_i.Aggregate_Circuit_Name,
t0_i.Prequal_Id, t0_i.Prequal_Distance,
t0_i.Lec_Qual_Distance, t0_i.Order_Date, t0_i.Request_Date,
t0_i.Install_Date, t0_i.Completion_Date,
t0_i.Original_Stb_Date, t0_i.Billing_Date,
t0_i.Billing_Change_Eff_Date, t0_i.Future_Cancel_Date,
t0_i.Cancel_Date, t0_i.Service_Area_Category,
t0_i.Transport_Qos, t0_i.Vpn_Option, t0_i.Ip_Addresses,
t0_i.Ip_Justified_Flag, t0_i.Ip_Address_Assigned_Flag,
t0_i.Bridge_Taps_Flag, t0_i.Load_Coils_Flag,
t0_i.Pair_Gain_Flag, t0_i.Line_Condit_Ok_Flag,
t0_i.Line_Conditioning_Post_Ok_Flag,
t0_i.Former_Order_Number, t0_i.Install_Contact_On_Site_Flag,
t0_i.Alt_Product_Ok_Flag, t0_i.Recent_Eu_Address_Chg_Flag,
t0_i.Lec_Servicing_Flag, t0_i.Security_Alarm_Flag,
t0_i.Pref_Higher_Bandwidth_Prod, t0_i.Eu_Contact_Ok_Flag,
t0_i.VPI, t0_i.VCI, t0_i.DLCI, t0_i.Invoice_Type,
t0_i.Payment_Type, t0_i.Bp_Pon, t0_i.Partner_Order_Id,
t0_i.Eu_Account_Number, t0_i.Conversion_Lec_Circuit_Id,
t0_i.Conversion_Lec_Lsr_Id, t0_i.Created_Date,
t0_i.Sent_To_Ilec, t0_i.Catalog_Id, t0_i.Serving_Co_Id,
t0_i.Order_Type, t0_i.Order_Id,
t0_i.Aggregate_Circuit_Co_Id,
t0_i.Replacement_Order_Item_Id, t0_i.Reason_Code,
t0_i.Service_Address_Id, t0_i.Exception_Type,
t0_i.Created_User_Id, t0_i.Order_State FROM ORDERED_ITEMS
t0_i, CATALOGS t2_i_catalogLocal, COS
t1_i_servingCentralOfficeLocal WHERE
(t1_i_servingCentralOfficeLocal.Clli_Code = ? AND
t2_i_catalogLocal.Catalog_Id IN(?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))AND
(t0_i.Catalog_Id=t2_i_catalogLocal.Catalog_Id AND
t0_i.Serving_Co_Id=t1_i_servingCentralOfficeLocal.Co_Id)
2003-03-28 15:00:12,831 1821769 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Executing SQL: SELECT
t0_i.Ordered_Item_Id, t0_i.Order_Number, t0_i.Order_System,
t0_i.Nen_Circuit_Number, t0_i.Aggregate_Circuit_Name,
t0_i.Prequal_Id, t0_i.Prequal_Distance,
t0_i.Lec_Qual_Distance, t0_i.Order_Date, t0_i.Request_Date,
t0_i.Install_Date, t0_i.Completion_Date,
t0_i.Original_Stb_Date, t0_i.Billing_Date,
t0_i.Billing_Change_Eff_Date, t0_i.Future_Cancel_Date,
t0_i.Cancel_Date, t0_i.Service_Area_Category,
t0_i.Transport_Qos, t0_i.Vpn_Option, t0_i.Ip_Addresses,
t0_i.Ip_Justified_Flag, t0_i.Ip_Address_Assigned_Flag,
t0_i.Bridge_Taps_Flag, t0_i.Load_Coils_Flag,
t0_i.Pair_Gain_Flag, t0_i.Line_Condit_Ok_Flag,
t0_i.Line_Conditioning_Post_Ok_Flag,
t0_i.Former_Order_Number, t0_i.Install_Contact_On_Site_Flag,
t0_i.Alt_Product_Ok_Flag, t0_i.Recent_Eu_Address_Chg_Flag,
t0_i.Lec_Servicing_Flag, t0_i.Security_Alarm_Flag,
t0_i.Pref_Higher_Bandwidth_Prod, t0_i.Eu_Contact_Ok_Flag,
t0_i.VPI, t0_i.VCI, t0_i.DLCI, t0_i.Invoice_Type,
t0_i.Payment_Type, t0_i.Bp_Pon, t0_i.Partner_Order_Id,
t0_i.Eu_Account_Number, t0_i.Conversion_Lec_Circuit_Id,
t0_i.Conversion_Lec_Lsr_Id, t0_i.Created_Date,
t0_i.Sent_To_Ilec, t0_i.Catalog_Id, t0_i.Serving_Co_Id,
t0_i.Order_Type, t0_i.Order_Id,
t0_i.Aggregate_Circuit_Co_Id,
t0_i.Replacement_Order_Item_Id, t0_i.Reason_Code,
t0_i.Service_Address_Id, t0_i.Exception_Type,
t0_i.Created_User_Id, t0_i.Order_State FROM ORDERED_ITEMS
t0_i, CATALOGS t2_i_catalogLocal, COS
t1_i_servingCentralOfficeLocal WHERE
(t1_i_servingCentralOfficeLocal.Clli_Code = ? AND
t2_i_catalogLocal.Catalog_Id IN(?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND
(t0_i.Catalog_Id=t2_i_catalogLocal.Catalog_Id AND
t0_i.Serving_Co_Id=t1_i_servingCentralOfficeLocal.Co_Id)
2003-03-28 15:00:12,833 1821771 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=1,
jdbcType=VARCHAR, value=BTLGWA01
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=2,
jdbcType=BIGINT, value=22
***HERE IS A BIGINT***
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=3,
jdbcType=BIGINT, value=23
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=4,
jdbcType=BIGINT, value=24
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=5,
jdbcType=BIGINT, value=25
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=6,
jdbcType=BIGINT, value=186
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=7,
jdbcType=BIGINT, value=188
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=8,
jdbcType=BIGINT, value=190
2003-03-28 15:00:12,834 1821772 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=9,
jdbcType=BIGINT, value=191
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=10,
jdbcType=BIGINT, value=192
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=11,
jdbcType=BIGINT, value=197
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=12,
jdbcType=BIGINT, value=240
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=13,
jdbcType=BIGINT, value=241
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=14,
jdbcType=BIGINT, value=242
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=15,
jdbcType=BIGINT, value=243
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=16,
jdbcType=BIGINT, value=244
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=17,
jdbcType=BIGINT, value=245
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=18,
jdbcType=BIGINT, value=246
2003-03-28 15:00:12,835 1821773 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=19,
jdbcType=BIGINT, value=247
2003-03-28 15:00:12,836 1821774 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=20,
jdbcType=BIGINT, value=249
2003-03-28 15:00:12,836 1821774 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-1:) Set parameter: index=21,
jdbcType=BIGINT, value=250
2003-03-28 15:00:24,964 1833902 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-2:) DYNAMIC-QL: select Object(i) from
Item i where i.servingCentralOfficeLocal.code = ?1 and
i.catalogLocal.id in (?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10,
?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21)
2003-03-28 15:00:25,017 1833955 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-2:) SQL: SELECT t0_i.Ordered_Item_Id,
t0_i.Order_Number, t0_i.Order_System,
t0_i.Nen_Circuit_Number, t0_i.Aggregate_Circuit_Name,
t0_i.Prequal_Id, t0_i.Prequal_Distance,
t0_i.Lec_Qual_Distance, t0_i.Order_Date, t0_i.Request_Date,
t0_i.Install_Date, t0_i.Completion_Date,
t0_i.Original_Stb_Date, t0_i.Billing_Date,
t0_i.Billing_Change_Eff_Date, t0_i.Future_Cancel_Date,
t0_i.Cancel_Date, t0_i.Service_Area_Category,
t0_i.Transport_Qos, t0_i.Vpn_Option, t0_i.Ip_Addresses,
t0_i.Ip_Justified_Flag, t0_i.Ip_Address_Assigned_Flag,
t0_i.Bridge_Taps_Flag, t0_i.Load_Coils_Flag,
t0_i.Pair_Gain_Flag, t0_i.Line_Condit_Ok_Flag,
t0_i.Line_Conditioning_Post_Ok_Flag,
t0_i.Former_Order_Number, t0_i.Install_Contact_On_Site_Flag,
t0_i.Alt_Product_Ok_Flag, t0_i.Recent_Eu_Address_Chg_Flag,
t0_i.Lec_Servicing_Flag, t0_i.Security_Alarm_Flag,
t0_i.Pref_Higher_Bandwidth_Prod, t0_i.Eu_Contact_Ok_Flag,
t0_i.VPI, t0_i.VCI, t0_i.DLCI, t0_i.Invoice_Type,
t0_i.Payment_Type, t0_i.Bp_Pon, t0_i.Partner_Order_Id,
t0_i.Eu_Account_Number, t0_i.Conversion_Lec_Circuit_Id,
t0_i.Conversion_Lec_Lsr_Id, t0_i.Created_Date,
t0_i.Sent_To_Ilec, t0_i.Catalog_Id, t0_i.Serving_Co_Id,
t0_i.Order_Type, t0_i.Order_Id,
t0_i.Aggregate_Circuit_Co_Id,
t0_i.Replacement_Order_Item_Id, t0_i.Reason_Code,
t0_i.Service_Address_Id, t0_i.Exception_Type,
t0_i.Created_User_Id, t0_i.Order_State FROM ORDERED_ITEMS
t0_i, CATALOGS t2_i_catalogLocal, COS
t1_i_servingCentralOfficeLocal WHERE
(t1_i_servingCentralOfficeLocal.Clli_Code = ? AND
t2_i_catalogLocal.Catalog_Id IN(?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND
(t0_i.Catalog_Id=t2_i_catalogLocal.Catalog_Id AND
t0_i.Serving_Co_Id=t1_i_servingCentralOfficeLocal.Co_Id)
2003-03-28 15:00:25,479 1834417 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-2:) Set parameter: index=1,
jdbcType=VARCHAR, value=BUMTTXTE
2003-03-28 15:00:25,479 1834417 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-2:) Set parameter: index=2,
jdbcType=VARCHAR, value=22
*** HERE IS A VARCHAR!***
2003-03-28 15:00:25,486 1834424 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.Item.ejbSelectGeneric]
(Thread Pool Worker-2:) Find failed
java.lang.ClassCastException
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2762)
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2905)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:607)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter(JDBCUtil.java:280)
at
org.jboss.ejb.plugins.cmp.jdbc.QueryParameter.set(QueryParameter.java:276)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:108)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:101)
at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:64)
at
org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:96)
at
org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:59)
at
com.newedgenetworks.phoenix.ejb.entity.ItemCMP$Proxy.ejbSelectGeneric(<generated>)
at
com.newedgenetworks.phoenix.ejb.entity.ItemBean.ejbHomeSelectCentralOfficeBooking(ItemBean.java:3081)
at
sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1138)
at
com.newedgenetworks.phoenix.ejb.jboss.AuditInterceptor.invoke(AuditInterceptor.java:292)
at
com.newedgenetworks.phoenix.ejb.jboss.AuditInterceptor.invokeHome(AuditInterceptor.java:258)
at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:207)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:237)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:68)
at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:133)
at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome(BaseLocalContainerInvoker.java:230)
at
org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
at $Proxy139.selectCentralOfficeBooking(Unknown Source)
at
com.newedgenetworks.phoenix.ejb.message.CentralOfficeInventoryPortsBean.updateCentralOffice(CentralOfficeInventoryPortsBean.java:552)
at
com.newedgenetworks.phoenix.ejb.message.CentralOfficeInventoryPortsBean.processEvent(CentralOfficeInventoryPortsBean.java:329)
at
com.newedgenetworks.phoenix.ejb.message.CentralOfficeInventoryPortsBean.onMessage(CentralOfficeInventoryPortsBean.java:259)
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:324)
at
org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:391)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
at
org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
at
org.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT.invoke(MessageDrivenTxInterceptorBMT.java:33)
at
org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:88)
at
org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:100)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
at
org.jboss.ejb.MessageDrivenContainer.invoke(MessageDrivenContainer.java:302)
at
org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:962)
at
org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1038)
at
org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:243)
at
org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:603)
at
org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:417)
at org.jboss.mq.SpySession.run(SpySession.java:296)
at
org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:178)
at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:642)
at java.lang.Thread.run(Thread.java:536)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=698682&group_id=22866
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
