Can RowSets be used with PreparedStatements?
I just found RowSets for database queries with JDBC. They are stateless and cacheable, and they look better than ResultSets.
Can PreparedStatements be used with these? PreparedStatements is a performance accelerator for queries against very large databases, not something I'd like to give up (before anything else is said, this is not a premature optimization, we have proven speed!). I need a quick query to revert to a set here, caching is secondary.
source to share
The default RowSet implementation uses prepared statements internally.
I would be surprised if this were not the case.
See JDBCRowSetImpl code your self http://www.google.com/codesearch/p?hl=en#TTY8xLpnKOE/src/share/classes/com/sun/rowset/JdbcRowSetImpl.java&q=JDBCRowSetImpl
you need to look at the prepare () method.
Note: Poking around code is why I love Open Source: D
source to share