java.sql.SQLException: Before start of result set

[simonfisher]

Hi,

I keep getting an SQL Exception when the following query is executed but no rows are returned.

Connection Conn =getConnection "jdbc:mysql://localhost/test?user=abc"
Statement stmt = Conn.createStatement();
rs = stmt.executeQuery(Some query);
rs.next();
ErrMessage = rs.getString("Error_Msg"
rs.close();
stmt.close();
Conn.close();

 

[vbkris]

Connection Conn =getConnection "jdbc:mysql://localhost/test?user=abc"

thats the wrong way to do it, u have to install MySql ODBC and then create a DSN, u have to use the DSN name in the connection string...

Known is handfull, Unknown is worldfull