db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramin Moazeni" <rmoaz...@gmail.com>
Subject Regarding DERBY-2658: Converting jdbcapi/parameterMetaDataJdbc30.java to JUnit
Date Thu, 07 Jun 2007 08:21:52 GMT
Hello,

The following piece of code gives two different results when it is run
as embedded
and net client and therefore, I am getting test failures. The results
are as follows:
--------embedded------------
DUMMYINT alias returned 6
DUMMYINT alias returned 22222
-------net client--------------
DUMMYINT alias returned 22222
DUMMYINT alias returned 22222
------expected result-------
DUMMYINT alias returned 6
DUMMYINT alias returned 22222


       /**
         *  test behaviour of meta data and out params after re-compile
         */
        public void testMetatdataAfterProcRecompile () throws SQLException {
                //System.out.println("Behaviour of meta data and out
params after re-compile");
                Statement stmt = createStatement();
                CallableStatement cs = prepareCall("CALL dummyint(?,?,?,?)");
                cs.registerOutParameter(3,Types.INTEGER);
                cs.registerOutParameter(4,Types.INTEGER);
                cs.setInt(1,1);
                cs.setInt(2,1);
                cs.setInt(4,4);
                cs.execute();
                //System.out.println("DUMMYINT alias returned " + cs.getInt(4));
                assertEquals("Unexpected DUMMYINT alias returned",
11111, cs.getInt(4));

                stmt.executeUpdate("drop procedure dummyint");
                stmt.executeUpdate("create procedure dummyint(in a
integer, in b integer, out c integer, inout d integer) language java
external name 'org.apache.derbyTesting.functionTests.tests.jdbcapi.parameterMetaDataJdbc30.dummyint2'
parameter style java");
                cs.execute();
                cs.setInt(4, 6);
                // following is incorrect sequence, should execute
first, then get
                // but leaving it in as an additional negative test.
see beetle 5886
  ---->        System.out.println("DUMMYINT alias returned " + cs.getInt(4));
                //assertEquals("Unexpected DUMMYINT alias returned",
6, cs.getInt(4));
                cs.execute();
 ----->        System.out.println("DUMMYINT alias returned " + cs.getInt(4));
                //assertEquals("Unexpected DUMMYINT alias returned",
22222, cs.getInt(4));
                stmt.executeUpdate("drop procedure dummyint");
                cs.close();
        }

Mime
View raw message