Re: problems with Oracle stored procedure

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sat Jul 14 2007 - 15:25:18 EDT

  • Next message: Mikaël Cluseau: "Re: Modifying projects in Java"

    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

    This archive was generated by hypermail 2.0.0 : Sat Jul 14 2007 - 15:25:43 EDT