cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: problems with Oracle stored procedure
Date Sat, 14 Jul 2007 19:25:18 GMT

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

Mime
View raw message