Hi Greg,
Unfortunately I don't have access to Oracle at present. I think I can
tweak the OracleProcedureAction to use a bit different strategy when
processing result set. But I can only do that if I have the test
environment, which I don't :-/ Let me see if I can resolve the Oracle
situation (maybe put it on a virtual Linux partition on my Mac... ).
In the meantime if you find anything of relevance, please share.
Andrus
On Jul 9, 2007, at 7:45 PM, Greg Boshart wrote:
> After further testing, I wrote a do-nothing stored procedure in
> Oracle:
>
> CREATE OR REPLACE PROCEDURE skeleton
> IS
> BEGIN
> DBMS_OUTPUT.PUT_LINE('Hello World!');
> END;
> /
>
> This procedure runs fine via JDBC but once again gets stuck in an
> endless loop in Cayenne. I have verified this behavior in Solaris
> 9 and
> Windows 2003 environments.
>
> Thanks,
>
> Greg
>
> ________________________________
>
> From: Greg Boshart
> Sent: Monday, July 09, 2007 8:24 AM
> To: use..ayenne.apache.org
> Subject: RE: problems with Oracle stored procedure
>
>
> I appreciate the response. It turns out there was already no adapter
> specified. Any other ideas?
>
> Thanks,
>
> Greg
>
> ________________________________
>
>
> This sounds very similar to a problem I had last year. I got an
> infinite loop of "updated rows" log messages on Oracle. See
> CAY-464 at
> https://issues.apache.org/cayenne/browse/CAY-464
> <https://issues.apache.org/cayenne/browse/CAY-464>
>
> Maybe it won't help -- we thought the problem appeared only on an
> older
> version of Oracle -- but it's worth a try. Clear the Custom Adapter
> fields in the modeler.
>
This archive was generated by hypermail 2.0.0 : Mon Jul 09 2007 - 13:15:18 EDT