Changeset: 2f72b89e1686 for monetdb-java
URL: https://dev.monetdb.org/hg/monetdb-java?cmd=changeset;node=2f72b89e1686
Modified Files:
tests/Test_PSlargebatchval.java
Branch: default
Log Message:
Improve test. Add a SELECT COUNT(*) query after the execution of the batched
inserts to verify the expected nr of rows have been inserted.
diffs (35 lines):
diff --git a/tests/Test_PSlargebatchval.java b/tests/Test_PSlargebatchval.java
--- a/tests/Test_PSlargebatchval.java
+++ b/tests/Test_PSlargebatchval.java
@@ -38,6 +38,7 @@ public class Test_PSlargebatchval {
pstmt.setDouble(3, 1.0);
pstmt.addBatch();
pstmt.executeBatch();
+ System.out.println("1. inserted 1 large string");
/* test issue reported at
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3470 */
pstmt.setLong(1, -2L);
@@ -45,6 +46,7 @@ public class Test_PSlargebatchval {
pstmt.setDouble(3, -2.0);
pstmt.addBatch();
pstmt.executeBatch();
+ System.out.println("2. inserted 1 large clob via
StringReader() object");
Clob myClob = con.createClob();
myClob.setString(1L, largeStr);
@@ -54,9 +56,15 @@ public class Test_PSlargebatchval {
pstmt.setDouble(3, 12345678901.98765);
pstmt.addBatch();
pstmt.executeBatch();
+ System.out.println("3. inserted 1 large clob via
createClob() object");
pstmt.close();
+ ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM
x");
+ if (rs.next())
+ System.out.println(rs.getInt(1) + " rows
inserted.");
+ rs.close();
+
stmt.execute("DROP TABLE x");
stmt.close();
} catch (SQLException e) {
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
