Hi,

Sorry for the slow response. I cant see any reason why it should
lock up their. Would you be able too email me
(ryan.baldwin@...) with the database you are using so
that I can try and re-produce the problem. Also if you could let me
know what JDK version you are using that would be helpfull too.

Thanks
Ryan

--- In Firebird-Java@yahoogroups.com, Marco Parmeggiani
<marcopar@i...> wrote:

> 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/