db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r1079779 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java
Date Wed, 09 Mar 2011 12:53:23 GMT
Author: kahatlen
Date: Wed Mar  9 12:53:22 2011
New Revision: 1079779

URL: http://svn.apache.org/viewvc?rev=1079779&view=rev
Log:
DERBY-5117: ParameterMetaDataJdbc30Test fails with "'DUMMYINT' is not recognized as a function
or procedure"

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java?rev=1079779&r1=1079778&r2=1079779&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java
Wed Mar  9 12:53:22 2011
@@ -185,6 +185,8 @@ public class ParameterMetaDataJdbc30Test
 
                 testParameterMetaData(paramMetaData, parameterMetaDataArray1);
 
+        stmt.execute("drop procedure dummyint");
+
 		stmt.close();
 		cs.close();
 	}
@@ -521,6 +523,15 @@ public class ParameterMetaDataJdbc30Test
 	public void testMetatdataAfterProcRecompile () throws SQLException {
 
 		Statement stmt = createStatement();
+
+        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.ParameterMetaDataJdbc30Test.dummyint' "
+                + "parameter style java");
+
       		CallableStatement cs = prepareCall("CALL dummyint(?,?,?,?)");
           	cs.registerOutParameter(3,Types.INTEGER);
       		cs.registerOutParameter(4,Types.INTEGER);
@@ -569,6 +580,8 @@ public class ParameterMetaDataJdbc30Test
 			assertEquals("Unexpected DUMMYINT alias returned", 22222, cs.getInt(4));
 		}
       		cs.close();
+
+        stmt.execute("drop procedure dummyint");
 	}
 	/**
          * test ParameterMetaData for Java procedures with INTEGER parameters 



Mime
View raw message