As part of an academic project, I’m incorporating a data replication technology into the HSQLDB source code. Been doing this for some time, but I’ve encountred a problem.
I need the ResultSet that comes from doing a query or an update. For some time I thougt that I could simply take that from org.hsqldb.jdbc.JDBCStatement, but that won’t work as that runs on the client side, meaning it runs on another JVM. I need the ResultSet on the server side.
I need to know where HSQLDB gets the ResultSets of its SQL statements and how to know if those results are from a query or an update.
I need this with extreme urgency. Any help will be appreaciated :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello
As part of an academic project, I’m incorporating a data replication technology into the HSQLDB source code. Been doing this for some time, but I’ve encountred a problem.
I need the ResultSet that comes from doing a query or an update. For some time I thougt that I could simply take that from org.hsqldb.jdbc.JDBCStatement, but that won’t work as that runs on the client side, meaning it runs on another JVM. I need the ResultSet on the server side.
I need to know where HSQLDB gets the ResultSets of its SQL statements and how to know if those results are from a query or an update.
I need this with extreme urgency. Any help will be appreaciated :)
Instances of org.hsqldb.result.Result are returned by org.hsqldb.Statement objects and managed in org.hsqldb.Session
But I need a ResultSet.
Is there any way to turn that org.hsqldb.result.Result into a java.sql.ResultSet, or to get that somewhere else?