~ Shreyas
Index:
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/prepStmtNull.java
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/prepStmtNull.java
(revision 0)
+++
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/prepStmtNull.java
(revision 0)
@@ -0,0 +1,119 @@
+package org.apache.derbyTesting.functionTests.tests.jdbcapi;
+
+
+import java.sql.*;
+
+import org.apache.derby.tools.ij;
+import org.apache.derby.tools.JDBCDisplayUtil;
+
+public class prepStmtNull {
+
+ public static void main(String[] args) {
+ test1(args);
+ test2(args);
+ }
+
+ public static void test1(String []args) {
+ Connection con;
+ ResultSet rs;
+ PreparedStatement stmt = null;
+ PreparedStatement pStmt = null;
+ Statement stmt1 = null;
+
+ System.out.println("Test prepStmtNull starting");
+
+ try
+ {
+ // use the ij utility to read the property file and
+ // make the initial connection.
+ ij.getPropertyArg(args);
+ con = ij.startJBMS();
+
+ con.setAutoCommit(false);
+
+ stmt = con.prepareStatement("create table nullTS(name
varchar(10), ts timestamp)");
+ stmt.executeUpdate();
+ con.commit();
+
+ pStmt = con.prepareStatement("insert into nullTS values
(?,?)");
+
+ pStmt.setString(1,"work");
+ pStmt.setNull(2,java.sql.Types.TIMESTAMP);
+ pStmt.addBatch();
+
+
+ pStmt.executeBatch();
+ con.commit();
+
+ stmt1 = con.createStatement();
+ rs = stmt1.executeQuery("select * from nullTS");
+ while(rs.next()) {
+ System.out.println("ResultSet is: "+rs.getObject(1));
+ System.out.println("ResultSet is: "+rs.getObject(2));
+ }
+ } catch(SQLException sqle) {
+ dumpSQLExceptions(sqle);
+ sqle.printStackTrace();
+ } catch(Throwable e) {
+ System.out.println("FAIL -- unexpected exception: "+e);
+ e.printStackTrace();
+
+ }
+ }
+
+ public static void test2(String []args) {
+ Connection con;
+ ResultSet rs;
+ PreparedStatement stmt = null;
+ PreparedStatement pStmt = null;
+ Statement stmt1 = null;
+
+ System.out.println("Test prepStmtNull starting");
+
+ try
+ {
+ // use the ij utility to read the property file and
+ // make the initial connection.
+ ij.getPropertyArg(args);
+ con = ij.startJBMS();
+
+ con.setAutoCommit(false);
+
+ stmt = con.prepareStatement("create table
nullBlob(name varchar(10), bval blob(16K))");
+ stmt.executeUpdate();
+ con.commit();
+
+ pStmt = con.prepareStatement("insert into nullBlob
values (?,?)");
+
+ pStmt.setString(1,"blob");
+ pStmt.setNull(2,java.sql.Types.BLOB);
+ pStmt.addBatch();
+
+
+ pStmt.executeBatch();
+ con.commit();
+
+ stmt1 = con.createStatement();
+ rs = stmt1.executeQuery("select * from nullBlob");
+ while(rs.next()) {
+ System.out.println("ResultSet is: "+rs.getObject(1));
+ System.out.println("ResultSet is: "+rs.getObject(2));
+ }
+ } catch(SQLException sqle) {
+ dumpSQLExceptions(sqle);
+ sqle.printStackTrace();
+ } catch(Throwable e) {
+ System.out.println("FAIL -- unexpected exception: "+e);
+ e.printStackTrace();
+
+ }
+ }
+
+ static private void dumpSQLExceptions (SQLException se) {
+ System.out.println("FAIL -- unexpected exception");
+ while (se != null) {
+ System.out.println("SQLSTATE("+se.getSQLState()+"):
"+se);
+ se = se.getNextException();
+ }
+ }
+}
Index:
java/testing/org/apache/derbyTesting/functionTests/master/prepStmtNull.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/prepStmtNull.out
(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/prepStmtNull.out
(revision 0)
@@ -0,0 +1,6 @@
+Test prepStmtNull starting
+ResultSet is: work
+ResultSet is: null
+Test prepStmtNull starting
+ResultSet is: blob
+ResultSet is: null
