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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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