Cannot invoke get and set method after findAll()

jonny Jun 3, 2004 5:15 PM

I have a session bean which invoke a findAll() method from an entity bean. When i iterate the collection, only the getPrimaryKey() method return the correct primary key. All the other getXXX and setXXX methods throw exception when they are invoked. However, when I do nothing about the collection and return it to the servlet, there is no exception and works fine. Any suggestion?

Thanks.

1. Re: Cannot invoke get and set method after findAll()

aloubyansky Jun 4, 2004 2:58 AM (in response to jonny)

What are the exceptions? JBoss version?
Actions
2. Re: Cannot invoke get and set method after findAll()

jonny Jun 4, 2004 9:07 PM (in response to jonny)

[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

Thanks
Actions
3. Re: Cannot invoke get and set method after findAll()

aloubyansky Jun 5, 2004 4:04 AM (in response to jonny)

The exception is thrown by the JDBC driver. Most probably the cause is a bad read-ahead configuration. How does the query look like?
Actions
4. Re: Cannot invoke get and set method after findAll()

hbaxmann Jun 5, 2004 4:12 AM (in response to jonny)

"[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.

bax
Actions

Go to original post