Subject | embedded freeze |
---|---|
Author | Marco Parmeggiani |
Post date | 2004-02-17T17:23:15Z |
Hi, i'm experimenting with the embedded server (java driver 1.5 beta 3
and embedded server 1.5 RC9)
Can somebody explain me why this piece of code locks on the
executeQuery?
Thanks
ciao
Code follows:
/*CUT HERE *******************************************/
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection conn = DriverManager.getConnection(
"jdbc:firebirdsql:embedded:c:/db/test.gdb",
"SYSDBA", "masterkey");
String q = "SELECT * FROM NEW_TABLE2 ORDER BY \"ppp\"";
Statement s = conn.createStatement();
************** it locks here *****************
ResultSet rs = s.executeQuery(q);
************** it locks here *****************
while(rs.next()) {
String s1 = rs.getString("NEW_FIELD");
String s2 = rs.getString("ppp");
System.out.println(s1 + " " + s2);
}
rs.close();
s.close();
conn.close();
/*CUT HERE *******************************************/
--
Seti@Home Java Applets
http://maruko.webhop.net/
and embedded server 1.5 RC9)
Can somebody explain me why this piece of code locks on the
executeQuery?
Thanks
ciao
Code follows:
/*CUT HERE *******************************************/
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection conn = DriverManager.getConnection(
"jdbc:firebirdsql:embedded:c:/db/test.gdb",
"SYSDBA", "masterkey");
String q = "SELECT * FROM NEW_TABLE2 ORDER BY \"ppp\"";
Statement s = conn.createStatement();
************** it locks here *****************
ResultSet rs = s.executeQuery(q);
************** it locks here *****************
while(rs.next()) {
String s1 = rs.getString("NEW_FIELD");
String s2 = rs.getString("ppp");
System.out.println(s1 + " " + s2);
}
rs.close();
s.close();
conn.close();
/*CUT HERE *******************************************/
--
Seti@Home Java Applets
http://maruko.webhop.net/