Problem with JBoss 3.0.6 and MySQL

[jcomisar1]

I have a webapp talking to an entity EJB bean using JBoss to host both. When I run with the default HSQL database everything works fine, and when I configure for MySQL things SEEM to work fine -- except I always get some annoying error messages (see attachment).

I need to get rid of these warning messages. Can anyone help me?

I have also attached my jbosscmp-jdbc.xml and titan-service.xml files. (The name comes from the JBoss 3.0 workbook which was my starting point.)

Thanks.

[davidjencks]

I know little about mysql except that some versions do not support transactions. Possibly that is causing the exceptions.

[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>
==================

[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.

[cuanglim]

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

[cuanglim]

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