I was experimenting how to bind SQL database table into Toolkit components and was told that QueryContainer is the correct class to use. This is my code:
String stmt = "SELECT * FROM test";
QueryContainer qc = null;
try {
qc = new QueryContainer(stmt, SQLConnection);
} catch (SQLException e) {
e.printStackTrace();
}
table.setContainerDataSource(qc);
(table object is Toolkit table).
I get
java.sql.SQLException: ResultSet was set to forward only
After seeing HSQLDB documentation it seems that I need to change ResultSet type which QueryContainer uses, how can I do that?
Where is the documentation for QueryContainer?? Javadocs are quite empty.
Thank you.