1 //Open two connections and call setTransactionIsolation(TRANSACTION_UNCOMMITTED ).
2 //From 1st connection insert tuple and then sleep, from 2nd connection try to select the inserted tuple.
3 //Tuple should be seen.
8 public static void main(String
[] args
)
12 Class
.forName("csql.jdbc.JdbcSqlDriver");
13 Connection con1
= DriverManager
.getConnection("jdbc:csql", "root", "manager");
14 Connection con2
= DriverManager
.getConnection("jdbc:csql", "root", "manager");
15 if ( (con1
== null) || (con2
== null) )
16 System
.out
.println("test failed!");
17 con1
.setTransactionIsolation(Connection
.TRANSACTION_READ_UNCOMMITTED
);
18 con2
.setTransactionIsolation(Connection
.TRANSACTION_READ_UNCOMMITTED
);
19 con1
.setAutoCommit(false);
20 con2
.setAutoCommit(false);
21 Statement cStmt
= con1
.createStatement();
22 cStmt
.execute("CREATE TABLE T1(f1 integer,f2 char(20));");
23 PreparedStatement stmt
= null;
24 stmt
= con1
.prepareStatement("INSERT INTO T1 VALUES(?,?);");
26 stmt
.setString(2,"test");
28 ret
= stmt
.executeUpdate();
35 cStmt
= con2
.createStatement();
36 ResultSet rs
= cStmt
.executeQuery("SELECT * FROM T1;");
43 cStmt
.execute("DROP TABLE T1;");
46 if (count
!=1) System
.exit(1); else System
.exit(0);
48 System
.out
.println(e
.getMessage());