Hi everone. I need some help. 
I'm developing a J2EE app. with Eclipse and JBoss 3.2.7.
I have one cmp bean with two CMR with other cmp.
I 've a session bean too for business logic and for accessing the cmp.
I'm forced to use MS ACCESS 2003 via jdbc:odbc bridge.

Well...the strange fact is that: I've created a remote console client (java 
application) for testing the CMP directly. In this case every things works 
fine, that is, i can do every getXXX from may Remote CMP EntityBean after the 
find.

The problem come when I try to do the same thing from my Session Bean.
In the Session bean I do really the same ...getContext for remote 
bean....getRemoteHome for my CMP EJB and finally findByPrimaryKey or findAll. 
When I try to use (i.e getSomePersistentField) one bean coming from the find I 
get this error:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Query is too 
complex.

Why from a console testClient it works fine and from a session bean it doesn't? 
I really used the same remote interface!

Please help me if some one has had the same problem before. 

Thanx 

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3895835#3895835

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3895835


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to