Hi,
I am in the process of moving from 3.2.2 to 3.2.6. I have had my full
application running successfully on 3.2.2 for a long time. I am now getting an
error the first time I try to access the persistent data with a finder method
on the home interface of an entity EJB. The finder method uses at least 3
relationships. I do have row locking on and am using JSDK1.4.2, and PostgreSQL
7.4. The error is:
10:07:53,956 ERROR [Facades#findFacades] Find failed
org.postgresql.util.PSQLException: ERROR: SELECT FOR UPDATE is not allowed with
DISTINCT clause
at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
(with many more lines from the stack trace).
There is also the following warning that appears just before the above error:
10:07:53,881 WARN [TxConnectionManager] Prepare called on a local tx. Use of
local transactions on a jta transaction with more than one branch may result in
inconsistent data in some cases of failure.
and is repeated 7 times.
I have read the sections in the manual that seem relevant but they do not
appear to have the answer, unless I am missing something.
Could someone please tell me the solution to this problem (preferably), or give
me an ideal about the likely cause or give me some pointers to follow up?
Cheers
Roger
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875938#3875938
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3875938
-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net
Plus IDC's 2005 look-ahead and a copy of this survey
Click here to start! http://www.idcswdc.com/cgi-bin/survey?id=105hix
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user