Can ResultSet for a PreparedStatement be updateable?
posted 11 years ago
Hi Ranchers Can resultset for a query executed from a Prepared statement be scrollable or updated? If so how or else why not? I know it works for a statement: Statement stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); However I learnt that there's a bug in MYSQL/JDBC connector that throws an exception when used on a query for tables from a different database. Does anybody has an idea where this bug is resolved. Thanks Ravi