I've been looking everywhere for a solution for this problem but no luck. I am using Oracle 9i, thin drivers (the jar version 1.4), jBoss 3.1rc. I want to read/write to a clob field. The code worked very well under OC4J 1.3 but now on jBoss it simply does not work. I am using just JDBC no cmps or ejbs.
Can someone help me please? 20:26:35,046 INFO [STDOUT] ......getConnection() Connection Count [1] 20:26:35,187 INFO [STDOUT] ReadForm() lFormID 20:26:35,203 INFO [STDOUT] localCxn [$Proxy74] 20:26:35,203 INFO [STDOUT] statement [$Proxy75] 20:27:08,078 INFO [STDOUT] java.lang.reflect.UndeclaredThrowableException 20:27:08,078 INFO [STDOUT] at $Proxy76.getClob(Unknown Source) 20:27:08,078 INFO [STDOUT] at FG_TalkBack.FG_Form_DAL.getValue_clob(FG_Form_DAL.java:351) 20:27:08,078 INFO [STDOUT] at FG_TalkBack.FG_Form_DAL.get_FormProperties(FG_Form_DAL.java:750) 20:27:08,093 INFO [STDOUT] at FG_TalkBack.FG_DataAccessLayer.ReadForm(FG_DataAccessLayer.java:451) 20:27:08,093 INFO [STDOUT] at FG_TalkBack.GetDataServlet.doPost(GetDataServlet.java:125) 20:27:08,093 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 20:27:08,109 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 20:27:08,109 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) 20:27:08,109 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 20:27:08,109 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 20:27:08,109 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 20:27:08,109 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 20:27:08,109 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) 20:27:08,109 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) 20:27:08,125 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) 20:27:08,125 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153) 20:27:08,125 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 20:27:08,125 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) 20:27:08,125 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) 20:27:08,125 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) 20:27:08,125 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) 20:27:08,125 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) 20:27:08,140 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) 20:27:08,140 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) 20:27:08,140 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) 20:27:08,140 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595) 20:27:08,156 INFO [STDOUT] Caused by: java.lang.IllegalAccessException: Method=public abstract java.sql.Clob java.sql.ResultSet.getClob(java.lang.String) throws java.sql.SQLException does not return Serializable 20:27:08,156 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.doResultSetMethod(WrapperDataSourceService.java:475) 20:27:08,156 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.invoke(WrapperDataSourceService.java:249) 20:27:08,156 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) 20:27:08,156 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 20:27:08,156 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 20:27:08,156 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141) 20:27:08,156 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) 20:27:08,171 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) 20:27:08,171 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245) 20:27:08,171 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644) 20:27:08,171 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155) 20:27:08,171 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104) 20:27:08,171 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179) 20:27:08,171 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165) 20:27:08,171 INFO [STDOUT] at org.jboss.proxy.ClientMethodInterceptor.invoke(ClientMethodInterceptor.java:59) 20:27:08,187 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86) 20:27:08,187 INFO [STDOUT] ... 26 more View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3888772#3888772 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3888772 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user