Bugs item #698682, was opened at 2003-03-06 14:47 Message generated for change (Comment added) made by loubyansky 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: Accepted Priority: 5 Submitted By: Mauricio Hiroshi Nagaoka (mhnagaoka) >Assigned to: Alexey Loubyansky (loubyansky) 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: Alexey Loubyansky (loubyansky) Date: 2003-12-19 09:28 Message: Logged In: YES user_id=543482 It seems to be the same as [ 856982 ] Dynamic-QL not thread safe http://sourceforge.net/tracker/?func=detail&aid=856982&group_id=22866&atid=376685 ---------------------------------------------------------------------- Comment By: Gerald Turner (crazyfoam) Date: 2003-12-19 05: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-29 02: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
