cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
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: 

against this procedure definition: 

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 - ""
Implementation-Version: Oracle JDBC Driver version - ""
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>



View raw message