0 Replies Latest reply on Aug 6, 2005 8:27 PM by fausto gomes

    how to read/write to clobs under jBoss 4+ with Oracle 9i?

    fausto gomes Newbie

      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