Bugs item #615667, was opened at 2002-09-27 15: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.
----------------------------------------------------------------------
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
