Hi to everybody, I'm Roberto from Spain
I'm able to access to Oracle10g Database from a CMP without problems,
but now,
I'm trying to access from a session bean
This is the session bean configuration:
...
...
<session>
<ejb-name>SBQuery</ejb-name>
<home>miapp.ejbs.session.Query.QueryHomeSB</home>
<remote>miapp.ejbs.session.Query.QuerySB</remote>
<ejb-class>miapp.ejbs.session.Query.QueryBeanSB</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<resource-ref>
<res-ref-name>jdbc/oracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</session>
...
...
but I have found the next Exception:
__________________________________________________________________________
Object:
[EMAIL PROTECTED] [change]
Method:
ResultSet selectRefPeticionesArticulos() throws RemoteException,
SQLException, Exception [change]
Arguments:
none
Exception:
Received a java.io.NotSerializableException
java.io.NotSerializableException: oracle.jdbc.driver.OracleResultSetImpl
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1054)
at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:278)
at java.rmi.MarshalledObject.(MarshalledObject.java:92)
at
org.openejb.core.ivm.BaseEjbProxyHandler.copyObj(BaseEjbProxyHandler.java:413)
at
org.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:312)
at
org.openejb.util.proxy.Jdk13InvocationHandler.invoke(Jdk13InvocationHandler.java:89)
at $Proxy6.selectRefPeticionesArticulos(Unknown Source)
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.apache.jsp.invokeobj_jsp$Invocation.invoke(invokeobj_jsp.java:57)
at org.apache.jsp.invokeobj_jsp.invoke(invokeobj_jsp.java:293)
at org.apache.jsp.invokeobj_jsp.printInvokeSection(invokeobj_jsp.java:280)
at
org.apache.jsp.invokeobj_jsp.printArgumentSection(invokeobj_jsp.java:230)
at org.apache.jsp.invokeobj_jsp.printMethodSection(invokeobj_jsp.java:166)
at org.apache.jsp.invokeobj_jsp.printObjectSection(invokeobj_jsp.java:107)
at org.apache.jsp.invokeobj_jsp.main(invokeobj_jsp.java:69)
at org.apache.jsp.invokeobj_jsp._jspService(invokeobj_jsp.java:709)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:534)
__________________________________________________________________________
Could somebody help me, please.
Thanks for all.
-Roberto
