Marco,
the <dbname>.script file is your database ;-)
Well I dont know much about Hypersonic, but this script file is a
recording of all user interaction. AFAIK there are no table files where
you can see the current state of a particular table.
So the lines
>
> CREATE TABLE MACHINEGROUPS(GROUPID INTEGER, ...., RECID INTEGER)
> CREATE TABLE LOTS(ID VARCHAR, ....., OUTPLANT INTEGER)
> .....
say that there are 2 tables MASCHINEGROUPS and LOTS (as long as there is
no line like "DROP TABLE MASCHINEGROUPS" in the following lines).
So it seems that it works fine with Hypersonic. With InstandDB is works
fine as well as you said. Now whats on with mySql?
As far as I can remember (dont have the old mails anymore...) you used
CMP?
Can you show me the jaws.xml file you use for your app and the mbean
configuration section of your mysql datasource in the jboss.jcml file
($JBOSSHOME/conf/jboss.jcml)?
\Daniel
