db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: rev 76068 - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNet tests/jdbcapi tests/lang
Date Wed, 17 Nov 2004 00:35:00 GMT
Author: kmarsden
Date: Tue Nov 16 16:34:59 2004
New Revision: 76068

Modified:
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/parameterMetaDataJdbc30.out
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMetaDataJdbc30.java
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/forbitdata.java
Log:
Minor Test updates


Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/parameterMetaDataJdbc30.out
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/parameterMetaDataJdbc30.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/parameterMetaDataJdbc30.out
Tue Nov 16 16:34:59 2004
@@ -122,6 +122,26 @@
 parameter getParameterTypeName CHAR
 parameter getParameterClassName java.lang.String
 parameter getParameterMode PARAMETER_MODE_IN
+variation 1, testing jira 44
+parameters count for prepared statement is 2
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 128
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 128
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
 parameters count for prepared statement is 0
 Bug 4654 - fill in where clause parameter type info
 parameters count for prepared statement is 1

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMetaDataJdbc30.java
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMetaDataJdbc30.java
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMetaDataJdbc30.java
Tue Nov 16 16:34:59 2004
@@ -127,22 +127,26 @@
       //internally. But we should only show 2 user visible parameters through
       //getParameterMetaData().
       System.out.println("Bug 4533 - hide associated parameters");
-	  // this test has been modified to not create a statement and 
-      // so does not actually test bug 4533 anymore.
-      // however, still an interesting test scenario.
-      // orig: s.execute("create statement systab as select * from sys.systables where "
+
-      //       " tablename like ? and tableID like ?");
-      //       ps = con.prepareStatement("execute statement systab");
-      ps = con.prepareStatement("select * from sys.systables where tablename like ? and tableId
like ?");
+      ps = con.prepareStatement("select * from sys.systables where " +
+             " tablename like ? and tableID like ?");
       ps.setString (1, "SYS%");
       ps.setString (2, "8000001%");
+      paramMetaData = ps.getParameterMetaData();
+      System.out.println("parameters count for prepared statement is " + paramMetaData.getParameterCount());
+      dumpParameterMetaData(paramMetaData);
+      ps.execute();
 
+      // variation, and also test out empty string in the escape (jira 44). 
+      System.out.println("variation 1, testing jira 44");
+      ps = con.prepareStatement("select * from sys.systables where tablename like ? escape
?");
+      ps.setString (1, "SYS%");
+      ps.setString (2, "");
       paramMetaData = ps.getParameterMetaData();
       System.out.println("parameters count for prepared statement is " + paramMetaData.getParameterCount());
       dumpParameterMetaData(paramMetaData);
       ps.execute();
 
-      // here too, the test no longer tests 4552, but kept as an interesting test scenario

+      // the test no longer tests 4552, but kept as an interesting test scenario 
       // bug 4552 - no parameters would be returned for execute statement using
       // System.out.println("Bug 4552 - no parameters would be returned for execute statement
using");
       // orig: ps = con.prepareStatement("execute statement systab using values('SYS%','8000001%')");

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/forbitdata.java
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/forbitdata.java
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/forbitdata.java
Tue Nov 16 16:34:59 2004
@@ -42,10 +42,6 @@
 			if (framework != null && framework.toUpperCase().equals("DB2JNET"))
 				isDB2jNet = true;
 
-//			Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
-
-//			Connection conn = DriverManager.getConnection("jdbc:db2://debrun.ibmus2.ibm.com:50000/tours",
"db2admin", "ejbcache");
-
 			runTests( conn);
 		} catch (Throwable t) {
 			System.out.println("FAIL " + t);

Mime
View raw message