Bugs item #615667, was opened at 2002-09-28 06:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=615667&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Chris Bonham (bonhamcm) Assigned to: Nobody/Anonymous (nobody) Summary: SQLException storing Oracle LONG Initial Comment: I'm using JBoss 3.0.2 W2K with JDK 1.3.1_04, Oracle 9i and the Thin drivers. I have a EJB 2.0 bean that uses an Oracle LONG field in its table. Reading from it is fine, but when I try to insert a record greater than 4000 characters, I get this error: [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma nd.SnippetCache] Executing SQL: UPDATE CACHE SET CONTENT=?, lastmodifytime=?, timetodie=? WHERE id=? 2002-09-27 14:49:47,838 ERROR [org.jboss.ejb.GlobalTxEntityMap] Store failed on entity: 4633 javax.ejb.EJBException: Internal error setting parameters for field htmlAndHeaderContent; CausedByException is: Data size bigger than max size for this type: 34130 at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMP FieldBridge.setArgumentParameters (JDBCAbstractCMPFieldBridge.java:289) at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMP FieldBridge.setInstanceParameters (JDBCAbstractCMPFieldBridge.java:262) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComman d.execute(JDBCStoreEntityCommand.java:85) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.store Entity(JDBCStoreManager.java:589) at org.jboss.ejb.plugins.CMPPersistenceManager.storeEnti ty(CMPPersistenceManager.java:458) at org.jboss.resource.connectionmanager.CachedConnectio nInterceptor.storeEntity (CachedConnectionInterceptor.java:388) at org.jboss.ejb.EntityContainer.storeEntity (EntityContainer.java:705) at org.jboss.ejb.GlobalTxEntityMap.syncEntities (GlobalTxEntityMap.java:99) at org.jboss.ejb.EntityContainer.synchronizeEntitiesWithinT ransaction(EntityContainer.java:172) at org.jboss.ejb.EntityContainer.findLocal (EntityContainer.java:604) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke Home(EntityContainer.java:1116) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome (AbstractInterceptor.java:73) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.inv okeHome(EntitySynchronizationInterceptor.java:209) at org.jboss.resource.connectionmanager.CachedConnectio nInterceptor.invokeHome (CachedConnectionInterceptor.java:215) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHo me(EntityInstanceInterceptor.java:88) 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:178) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome (TxInterceptorCMT.java:52) 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 $Proxy46.findByKey(Unknown Source) at **private** at java.lang.reflect.Method.invoke(Native Method) 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:178) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke (TxInterceptorCMT.java:60) at org.jboss.ejb.plugins.SecurityInterceptor.invoke (SecurityInterceptor.java:130) at org.jboss.ejb.plugins.LogInterceptor.invoke (LogInterceptor.java:203) 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 $Proxy67.getConfigurationValue(Unknown Source) at **private** at **private** at **private** at **private** at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke (EntityContainer.java:1191) at org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.i nvoke(JDBCRelationInterceptor.java:95) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.inv oke(EntitySynchronizationInterceptor.java:308) at org.jboss.resource.connectionmanager.CachedConnectio nInterceptor.invoke (CachedConnectionInterceptor.java:186) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke (EntityInstanceInterceptor.java:152) at org.jboss.ejb.plugins.EntityLockInterceptor.invoke (EntityLockInterceptor.java:107) at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke (EntityCreationInterceptor.java:69) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext (AbstractTxInterceptor.java:107) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti ons(TxInterceptorCMT.java:178) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke (TxInterceptorCMT.java:60) at org.jboss.ejb.plugins.SecurityInterceptor.invoke (SecurityInterceptor.java:130) at org.jboss.ejb.plugins.LogInterceptor.invoke (LogInterceptor.java:203) at org.jboss.ejb.EntityContainer.invoke (EntityContainer.java:493) at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv oke(BaseLocalContainerInvoker.java:301) at org.jboss.ejb.plugins.local.EntityProxy.invoke (EntityProxy.java:38) at $Proxy77.getHtmlContent(Unknown Source) at **private** at **private** at java.lang.reflect.Method.invoke(Native Method) 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:178) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke (TxInterceptorCMT.java:60) at org.jboss.ejb.plugins.SecurityInterceptor.invoke (SecurityInterceptor.java:130) at org.jboss.ejb.plugins.LogInterceptor.invoke (LogInterceptor.java:203) at org.jboss.ejb.StatelessSessionContainer.invoke (StatelessSessionContainer.java:313) at org.jboss.ejb.Container.invoke (Container.java:720) at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:517) at org.jboss.invocation.local.LocalInvoker.invoke (LocalInvoker.java:98) at org.jboss.invocation.InvokerInterceptor.invoke (InvokerInterceptor.java:102) at org.jboss.proxy.TransactionInterceptor.invoke (TransactionInterceptor.java:73) at org.jboss.proxy.SecurityInterceptor.invoke (SecurityInterceptor.java:76) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke (StatelessSessionInterceptor.java:111) at org.jboss.proxy.ClientContainer.invoke (ClientContainer.java:76) at $Proxy58.getComponentViewHtml (Unknown Source) at org.apache.jsp.**private**$jsp._jspService (**private**$jsp.java:546) at org.apache.jasper.runtime.HttpJspBase.service (HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper. service(JspServlet.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile (JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service (JspServlet.java:473) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.mortbay.jetty.servlet.ServletHolder.handle (ServletHolder.java:344) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatc h(WebApplicationHandler.java:313) at org.mortbay.jetty.servlet.Dispatcher.forward (Dispatcher.java:204) at **private** at javax.servlet.http.HttpServlet.service (HttpServlet.java:740) at javax.servlet.http.HttpServlet.service (HttpServlet.java:853) at org.mortbay.jetty.servlet.ServletHolder.handle (ServletHolder.java:344) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatc h(WebApplicationHandler.java:313) at org.mortbay.jetty.servlet.ServletHandler.handle (ServletHandler.java:554) at org.mortbay.jetty.servlet.WebApplicationHandler.handle (WebApplicationHandler.java:199) at org.mortbay.http.HttpContext.handle (HttpContext.java:1572) at org.mortbay.http.HttpContext.handle (HttpContext.java:1522) at org.mortbay.http.HttpServer.service (HttpServer.java:795) at org.jboss.jetty.Jetty.service(Jetty.java:531) at org.mortbay.http.HttpConnection.service (HttpConnection.java:784) at org.mortbay.http.HttpConnection.handleNext (HttpConnection.java:941) at org.mortbay.http.HttpConnection.handle (HttpConnection.java:799) at org.mortbay.http.SocketListener.handleConnection (SocketListener.java:186) at org.mortbay.util.ThreadedServer.handle (ThreadedServer.java:322) at org.mortbay.util.ThreadPool$JobRunner.run (ThreadPool.java:716) at java.lang.Thread.run(Thread.java:479) I have a workaround to call PreparedStatement.setAsciiStream() in org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter() which I'll post in the patch forum. Thanks. ---------------------------------------------------------------------- Comment By: Stephen Coy (scoy) Date: 2002-09-28 12:37 Message: Logged In: YES user_id=463096 This is not really a JBoss bug. It's a short coming of the Oracle thin drivers. JBoss works OK if you use the "oci" drivers. Nevertheless, I'll have a look at your patch anyway because I'm doing some work in this area at the moment. SF won't let me assign this to me, but I'm happy to take it. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=615667&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development