> I think the better answer is to use PostgreSQL instead of MySQL.
> PostgreSQL 7.x has an XA-compliant JDBC driver, and is just generally more
> robust and scalable than MySQL.
Thanks. Unfortunately, changing the database is not an option at the moment.
> Frankly, I don't know what this Transaction Isolation Level is, or how to
> turn it off. If you post a stack trace with an error or something that
> has more information, I may be able to help.
It's the mechanism by which you are supposed to be able to select the
level of locking set on the database during the transaction and is used to
manage dirty reads, non-repeatable reads and phantom reads.
The actual exception thrown is:
Exception: [02:14:42] java.sql.SQLException: Transaction Isolation Levels
are not supported.
java.sql.SQLException: Transaction Isolation Levels are not supported.
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.sql.SQLException.<init>(SQLException.java:64)
at
org.gjt.mm.mysql.Connection.setTransactionIsolation(Connection.java)
at
allaire.ejipt._ejb._DataSource._getConnection(_DataSource.java:268)
at
allaire.ejipt._ejb._DataSource._getConnection(_DataSource.java:121)
at allaire.ejipt._ejb._PersistenceAgent._execute(Compiled Code)
at allaire.ejipt._PersistenceManager._find(Compiled Code)
at
allaire.ejipt._EntityHomeObject._invoke(_EntityHomeObject.java:234)
at allaire.ejipt._EntityHomeObject._find(_EntityHomeObject.java:268)
at allaire.ejipt._CallableObject.call(_CallableObject.java:85)
at allaire.ejipt._CallableStub._call(_CallableStub.java:173)
at
ejbeans.PartnerHomeObject_Stub.findByPrimaryKey(PartnerHomeObject_Stub.java:
188)
at EjbServlet.doGet(EjbServlet.java:63)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at EjbServlet.service(EjbServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(Compiled Code)
at
allaire.jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:34
)
at allaire.jrun.servlet.Invoker.service(Invoker.java:84)
at allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(Compiled Code)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.jav
a:88)
at allaire.jrun.servlet.JRunSE.service(JRunSE.java:1131)
at allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:330)
at allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:354)
at allaire.jrun.ThreadPool.run(Compiled Code)
at allaire.jrun.WorkerThread.run(Compiled Code)
And it is thrown by the JDBC driver.
Terry Cox
Trance Development
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
