Transaction Rollback Exception: Table doesn't exist ?!?!

[sammy]

Hi there, I've got another problem...

I am using JBoss 2.4.4 with a MySQL database. I've done the necessary changes in the jboss.jcml, and the Database is bounded and initialized correctly. I am also able to deploy CMP beans without any errors. But at the moment when I try to use this beans by some client programs, I always get an error message telling me that the table doesn't exist. I tried to configure create-table as "true" in the jaws file, but that won't help. I even created the required table by hand in the database, but JBoss doesn't find it. This doesn't only happen with my own beans but with the JBoss example beans too, like the cd cmp example. The error message looks like this:

[ERROR,CDCollectionBean] TRANSACTION ROLLBACK EXCEPTION:
javax.transaction.TransactionRolledbackException: null
Embedded Exception
Could not determine existence:javax.ejb.FinderException: General error: Table 'jboss_db.cdbean' doesn't exist
javax.ejb.EJBException: null

Does anybody know something about this problem?

thanx, sam

[sursha]

Could u post your jaws.xml file?

[rstawarz]

I'm getting this same problem using BMP. Any help is very appreciated.
Thanks,
Ryan

[sammy]

My application doesn't have any jaws.xml. So, the settings are configured in the standardjaws.xml:

<?xml version="1.0" encoding="UTF-8"?>

java:/DefaultDS
<type-mapping>mySQL</type-mapping>
false

<default-entity>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<select-for-update>false</select-for-update>
</default-entity>

<type-mappings>
<type-mapping>

...standard mysql typemapping...

</type-mapping>
</type-mappings>

[cbradley2]

There is a bug and workaround for a problem that sounds like this one...

http://sourceforge.net/tracker/?func=detail&atid=376685&aid=508053&group_id=22866