Subject embedded freeze
Author Marco Parmeggiani
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/