added empty result set testing

Dave Cramer · Dave Cramer · commit 6e2fab0a411d · 2002-06-14T10:56:13.000Z
diff --git a/src/interfaces/jdbc/org/postgresql/test/jdbc2/MiscTest.java b/src/interfaces/jdbc/org/postgresql/test/jdbc2/MiscTest.java
@@ -5,7 +5,7 @@
 import java.sql.*;
 
 /*
- * $Id: MiscTest.java,v 1.5 2002/05/30 16:26:55 davec Exp $
+ * $Id: MiscTest.java,v 1.6 2002/06/14 10:56:13 davec Exp $
  *
  * Some simple tests based on problems reported by users. Hopefully these will
  * help prevent previous problems from re-occuring ;-)
@@ -52,6 +52,29 @@ public void testDatabaseSelectNullBug()
 		}
 	}
 
+  public void testError()
+  {
+    Connection con = JDBC2Tests.openDB();
+		try
+		{
+
+      // transaction mode
+      con.setAutoCommit(false);
+      Statement stmt = con.createStatement();
+      stmt.execute("select 1/0");
+			fail( "Should not execute this, as a SQLException s/b thrown" );
+      con.commit();
+		}
+		catch ( Exception ex )
+		{
+		}
+    try
+    {
+      con.commit();
+      con.close();
+    }catch ( Exception ex) {}
+  }
+
 	public void xtestLocking()
 	{
 
