Where is the ResultSet of Queries and Updates on the Server-side?

  • tul

    tul - 2014-08-06


    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 :)

  • Fred Toussi

    Fred Toussi - 2014-08-06

    Instances of org.hsqldb.result.Result are returned by org.hsqldb.Statement objects and managed in org.hsqldb.Session

  • tul

    tul - 2014-08-06

    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?


Log in to post a comment.