I am having some trouble with a call like "doSelect(new Criteria);".
I get a SQLException with the following stack (this is just a snippet
of the top of the trace):
java.sql.SQLException: FastPath call returned ERROR: lo_tell: invalid
large object descriptor (0)
at com.workingdogs.village.DataSet.fetchRecords(DataSet.java:549)
at com.workingdogs.village.DataSet.fetchRecords(DataSet.java:467)
at com.workingdogs.village.DataSet.fetchRecords(DataSet.java:452)
at org.apache.turbine.om.peer.BasePeer.getSelectResults(BasePeer.java:1376)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1289)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1251)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1202)
at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:1131)
at net.jedi.lw.om.BaseEventPeer.doSelectVillageRecords(BaseEventPeer.java:230)
at net.jedi.lw.om.BaseEventPeer.doSelect(BaseEventPeer.java:201)
I looked for a solution on the web and found some guy mentioning that
the database connection should NOT be on autocommit
(Connection.setAutoCommit(false)). I guess lo_tell isn't safe with
autocommit (seems weird, but that is what this guy said).
Also, when the table that is being selected on doesn't have any large
objects in it (the fields are null), I don't get this problem.
Any ideas?
Thanks,
Jason
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
