hi.
does anyone have any idea on how to use Castor with multithreaded requests?
I am testing with Sybase 11.x and 12.x using JConnect 5.5. With single threaded calls
all works fine but are slow as all hell. I have also tried wrapping jconnect.jar with
poolman, but to no avail.
This is the exception I get when I try to use the Castor with multithreaded calls
ex.getMessage() = JZ00L: Login failed. Examine the SQLWarnings chained to this
exception for the reason(s).
ex.getMessage() = JZ006: Caught IOException:
com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
ex.getMessage() = JZ0C1: An IOException occurred which closed the connection.
ex.getMessage() = JZ006: Caught IOException:
com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
ex.getMessage() = JZ0C1: An IOException occurred which closed the connection.
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this
exception for the reason(s).
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3188)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.createConnection(SybDriver.java:533)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:473)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:505)
at com.sybase.jdbc2.jdbc.SybDataSource.getConnection(SybDataSource.java:238)
at org.exolab.castor.jdo.engine.DatabaseRegistry.createConnection(Unknown
Source)
at org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Unknown
Source)
at org.exolab.castor.persist.ClassMolder.create(Unknown Source)
at org.exolab.castor.persist.LockEngine.create(Unknown Source)
at org.exolab.castor.persist.TransactionContext.create(Unknown Source)
at org.exolab.castor.jdo.engine.DatabaseImpl.create(Unknown Source)
at com.ubs.fx2b.castor.RunInsert.run(RunInsert.java:64)
at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this
exception for the reason(s).
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3188)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.createConnection(SybDriver.java:533)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:473)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:505)
at com.sybase.jdbc2.jdbc.SybDataSource.getConnection(SybDataSource.java:238)
at org.exolab.castor.jdo.engine.DatabaseRegistry.createConnection(Unknown
Source)
at org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Unknown
Source)
at org.exolab.castor.persist.ClassMolder.create(Unknown Source)
at org.exolab.castor.persist.LockEngine.create(Unknown Source)
at org.exolab.castor.persist.TransactionContext.create(Unknown Source)
at org.exolab.castor.jdo.engine.DatabaseImpl.create(Unknown Source)
at com.ubs.fx2b.castor.RunInsert.run(RunInsert.java:64)
at java.lang.Thread.run(Thread.java:536)
thanks,
Florian Hehlen
Visit our website at http://www.ubswarburg.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
