Dikaios Dikaios - 2006-11-24

First of all I want to thank you for this application.

The problem is that I want a scrollabe resultset. Here is my code to connect to the database

DriverManager.registerDriver(new com.mysql.embedded.jdbc.MySqlEmbeddedDriver());
String dbURL = "jdbc:mysql-embedded/Database?user=root&password=";
Properties props = new Properties();
props.put("library.path", "lib");
props.put("--datadir", "data");
props.put("--basedir", "mysql");
props.put("--default-character-set","utf8");
props.put("--default-collation","utf8_general_ci");
conn = DriverManager.getConnection(dbURL,props);

and here is the code that creates the statement.

Statement st = null;
ResultSet rs = null;
PreparedStatement pstm = null;
Statement stm = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
stm.setFetchSize(-1);
stm.execute("...");
rs = stm.getResultSet();

This the code I use to get a scrollable resultset. I don't care if it is sensitive or insensitive.

When I try to get the pointer to a specific row by using,

rs.absolute(2);

I get this error message,

#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0b852714, pid=2748, tid=3296
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_06-b05 mixed mode)
# Problematic frame:
# C  [libmysqld.dll+0x62714]
#
# An error report file with more information is saved as hs_err_pid2748.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#

which I guess... it's bad!!!

Thanks in advance
Dikaios