-
1. Re: Problem with JBoss 3.0.6 and MySQL
davidjencks Apr 28, 2003 11:53 PM (in response to jcomisar1)I know little about mysql except that some versions do not support transactions. Possibly that is causing the exceptions.
-
2. Re: Problem with JBoss 3.0.6 and MySQL
jcomisar1 Apr 29, 2003 9:32 PM (in response to jcomisar1)Thanks for your suggestion. Sounds reasonable.
I tried a quick fix by changing the deployment descriptor ejb-jar.xml to the following. (It specifies that if the client has a transaction open to suspend it temporarily and resume later on.)
Unfortunately that doesn't help. I'll try to download a more recent version of mysql and see if that works.
================================
<container-transaction>
<ejb-name>StockEJB</ejb-name>
<method-name>*</method-name>
<!-- debug: some versions of mysql do not support transactions
<trans-attribute>Required</trans-attribute>
-->
<trans-attribute>NotSupported</trans-attribute>
</container-transaction>
================== -
3. Re: Problem with JBoss 3.0.6 and MySQL
jcomisar1 Apr 30, 2003 11:29 AM (in response to jcomisar1)Oops! I was a little careless applying the fix. This time it worked fine.
So turning off Tx when using mysql3.23.54 causes the warning messages to go away. I will try to find a version of mysql that does not have this problem.
Thanks for your help. -
4. Re: Problem with JBoss 3.0.6 and MySQL
cuanglim May 5, 2003 7:13 PM (in response to jcomisar1)Hi,
Can I see your mysql-service.xml? I want to know how to turn off the Tx, I also have the same problem here.
Is it need to define the database in jbosscmp-jdbc.xml?
Thanks.
Regards,
Han Lin -
5. Re: Problem with JBoss 3.0.6 and MySQL
cuanglim May 5, 2003 9:21 PM (in response to jcomisar1)Hi,
I managed to connect to database now, but after login, I've got this error :
type Status report
message /logon.jsp
description The requested resource (/logon.jsp) is not available.
And in the server.log I got this :
2003-05-06 10:12:27,562 INFO [org.apache.struts.action.RequestProcessor] Processing a 'POST' for path '/corporateLogon'
2003-05-06 10:12:27,626 INFO [STDOUT] In User Pfc Xref Bean select Pfc by User:select CID,PFC_CODE from USER_PFC_XREF where UID = ?
2003-05-06 10:12:27,633 INFO [STDOUT] Here in User Pfc Xref
2003-05-06 10:12:27,784 INFO [STDOUT] In User Pfc Xref Bean select User by Pfc:select UID from USER_PFC_XREF where CID = ? and PFC_CODE = ?
2003-05-06 10:12:27,788 INFO [STDOUT] Here in User Pfc Xref
2003-05-06 10:12:27,789 INFO [STDOUT] pfc1
2003-05-06 10:12:27,811 INFO [STDOUT] In User Pfc Xref Bean select User by Pfc:select UID from USER_PFC_XREF where CID = ? and PFC_CODE = ?
2003-05-06 10:12:27,815 INFO [STDOUT] Here in User Pfc Xref
2003-05-06 10:12:27,816 INFO [STDOUT] pfc2
2003-05-06 10:12:27,817 WARN [org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConnectionEventListener] prepare called on a local tx. You are not getting the semantics you expect!
2003-05-06 10:12:27,818 WARN [org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConnectionEventListener] prepare called on a local tx. You are not getting the semantics you expect!
2003-05-06 10:12:30,043 INFO [org.apache.struts.action.RequestProcessor] Processing a 'POST' for path '/retrieveLogonDetail'
2003-05-06 10:12:30,055 INFO [STDOUT] In User Pfc Xref Bean select User by Pfc:select UID from USER_PFC_XREF where CID = ? and PFC_CODE = ?
2003-05-06 10:12:30,058 INFO [STDOUT] Here in User Pfc Xref
FYI, the application itself can run on another machine which is used jboss-2.4.4-tomcat-4.0.1.
Here I attached my xml config files.
Please Advise.
Regards,
Han Lin