On Jul 13, 2007, at 5:58 PM, Greg Boshart wrote:
Thanks Andrus, I appreciate your help. What version of Cayenne are
you
using?
I tested both 2.0.3 and 3.0M1 (essentially trunk code).
First I ran an unchanged unit test suite against 2.0.3 code. Namely
this test:
https://svn.apache.org/repos/asf/cayenne/main/branches/STABLE-2.0/
cayenne/cayenne-java/src/tests/java/org/apache/cayenne/access/
DataContextProcedureQueryTst.java
against this procedure definition:
https://svn.apache.org/repos/asf/cayenne/main/branches/STABLE-2.0/
cayenne/cayenne-java/src/tests/resources/ddl/oracle/create-update-sp.sql
It passed. But since it does manual transaction management, I did
another test against the trunk, removing transaction code from the
procedure, and from the unit test. I.e. it was running under default
Cayenne transaction management. It passed again.
What about your Oracle JDBC drivers?
From the driver jar MANIFEST.MF:
Specification-Version: Oracle JDBC Driver version - "10.2.0.1.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.1.0"
Implementation-Vendor: Oracle Corporation
Implementation-Time: Wed Jun 22 18:55:48 2005
Does your stored procedure mapping look like:
<procedure name="cayenne_tst_upd_proc">
<procedure-parameter name="painting_price"
type="INTEGER" direction="in"/>
</procedure>
Yes.
Andrus
