Your configuration seems to be correct. Can you post your Hibernate config file and server log?
There is nothing else in log other than the following. Where do I find hibernate configuration file. There is none in my project folder and the only place hibernate is being configured is in the .fml file that also I pasted..
Sorry for the delay in replying, I was out of office for the last week or so.
Can you check your Data Source configuration, specifically if it has the factory property specified or not?
<Transaction factory="org.objectweb.jotm.UserTransactionFactory" jotm.timeout="60"/> <Resource name="jdbc/ordersDB" type="javax.sql.DataSource" driverClassName="org.hsqldb.jdbcDriver" maxIdle="2" maxWait="5000" factory="org.objectweb.jndi.DataSourceFactory" url="jdbc:hsqldb:hsql://localhost:9002/ordersdb" username="sa" password="" maxActive="4" />
If that does not help, can you enable trace level logging on org.hibernate.jdbc.* and org.hibernate.transaction.* That should help identify the cause of the issue.