RE: Stored procedure question ?

2007-05-15 Thread Marc Gabriel-Willem
Hello, I removed the first parameter and the returningValue flag ... and indeed it is working properly. I'm really surprised because I used the reengineer database schema function to create the mapping file. Is it a problem from the modeler? I've another question for you. In MS sqlserver, we

Re: Stored procedure question ?

2007-05-15 Thread Andrus Adamchik
Is it a problem from the modeler? Per SQLServer docs: http://support.microsoft.com/kb/285295 Every SQL Server stored procedure has a return value parameter (whether it is explicitly used or not) which is called @return_value. I suspect that JDBC blows on implicit mapped @return_value.

Re: OutOfMemoryError: reading a large number of objects one by one

2007-05-15 Thread Andrus Adamchik
On May 15, 2007, at 12:47 AM, Tomi N/A wrote: Reduced the max number of objects to 1000. The result? A NPE at: for (MyClassC mcc : (ListMyClassC)mca.getToMyClassC().getToParentClass ().getMyClassCArray()) { Ok, so the cache size will have to be big enough to hold all

Oracle stored procedure - registering out ref cursor

2007-05-15 Thread Marc Gabriel-Willem
Dear all, We are trying to map the following oracle stored procedure using the cayenne modeler. Please find below all the details of the PL/SQL required to create the stuff. --- create table tTest ( id int NOT NULL, data varchar2(200) NOT