I could fix the last problem: message TRANSACTION ROLLBACK EXCEPTION.
I added:
<resource-ref>
<res-ref-name>infoKioskStore</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
to ejb-jar
But maybe something's to be added to jboss.xml too...
But the saga continues: now I have to face the following message:
java.sql.SQLException: Table not found: SHOWS in statement [select shows.id
from shows, showDescriptions, labels WHERE
shows.showdescriptionid=showdescriptions.id and
showdescriptions.labelid=labels.labelid and label like 'Le préssentiment']
I tried the above query "by hand" and it worked. I tried even with SHOWS in
uppercase (sql is case-insensitive anyway). I'm pretty sure the datasource
connects to the appropriate database...
This time, I won't be able to figure out myself I guess...
Thank you in advance,
candide kemmler
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
