Hi,
A user had this error:
"I am trying out the electricity application with SQLite as the database. During the
startup of Tomcat, it gives an error that SQLite only supports
type_forward_only cursors. "
This was due to the web4j internals (SqlStatement.java, line 200):
result = aConnection.prepareStatement(aSqlText, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
I would like to change this to:
result = aConnection.prepareStatement(aSqlText, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
As far as I can see, web4j doesn't need the result set to be scrollable. The type-forward-only is the simplest form of result set, so it should be supported by any reasonable db/driver.
If you know of any objection to this change, let me know...the internal result set above doesn't leak out to the application, so it's likely a change that will no zero ripple effects.
- John