What are the exceptions? JBoss version?
[org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract java.lang.String libsys.entities.publisher.PublisherLocal.getPUBLISHER(), causedBy:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Query is too complex.
Jboss version is 3.2.3
The exception is thrown by the JDBC driver. Most probably the cause is a bad read-ahead configuration. How does the query look like?
"[Microsoft][ODBC Microsoft Access Driver] Query is too complex"
Using MS Access thru a JDBC-ODBC bridge is even more bad than using the HSQLDB or kind-of DB MySQL - simply use a transactional, real DB. I would suggest MaxDB (formerly known as SAPDB) at http://www.mysql.com/products/maxdb. It is the easiest one to install and use.