Orion 0.9.1n (and propably a few versions before that) has major problems
with Sybase. The problem seems to be in the connection pooling mechanism.
For some reason it tries to use database connections that has been closed.
I get the following error message when deploying a bean whose tables
already exists in the database:
Auto-deploying radreportejb... Error compiling
file:/home/eliasm/bugreport/radreport/radreportejb/: Error finding a
suitable DataSource: SQL Error opening DataSource: JZ006: Caught
IOException: java.net.SocketException: Socket closed
The above message is from a Solaris 8 machine running JDK1.2.1_05
production release and Sybase jConnect 5.2 (the same problem occurs with
5.0). I've tried this With sybase version 11.9 as well as version 12.
If I try is using JDK1.3 I get the following error message:
Auto-deploying radreportejb... Error compiling
file:/home/eliasm/bugreport/radreport/radreportejb/: Error finding a
suitable DataSource: SQL Error opening DataSource: JZ006: Caught
IOException: java.io.IOException: Bad file number
Apart from the change in error message everything is the same.
If I drop one of the tables prior to deployment it works.
When I try to use this EJB from a JSP (after successfully deploying
because I deleted the tables) I get the following error:
500 Internal Server Error
java.rmi.RemoteException: SQL Error opening DataSource: JZ006: Caught
IOException: java.net.SocketException: Socket closed
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.io.IOException.<init>(IOException.java:47)
at java.rmi.RemoteException.<init>(RemoteException.java:56)
at
com.evermind.server.ejb.DataSourceConnectionContainer.getConnection(Compiled
Code)
at EntityHomeWrapper1.findAll(Compiled Code)
at __jspPage2._jspService(Compiled Code)
at com.evermind.server.http.EvermindHttpJspPage.service(JAX)
at com.evermind.server.http.HttpApplication.op(JAX)
at com.evermind.server.http.JSPServlet.service(JAX)
at com.evermind.server.http.cv.k3(JAX)
at com.evermind.server.http.cv.forward(JAX)
at com.evermind.server.http.c4.m3(Compiled Code)
at com.evermind.util.b.run(Compiled Code)
