Hello,
we want to allow users of Forte for Java IDE to access MYSQL database
server. But driver used to access MYSQL database
(mm.mysql-2.0.2-bin.jar) doesn't support Transaction Isolation Leves and
that's why it is impossible to modify data by application which using
NBCachedRowSet (e.g. application generated by JDBC Form Wizard).
java.sql.SQLException: Transaction Isolation Levels are not supported.
at
org.gjt.mm.mysql.Connection.setTransactionIsolation(Connection.java)
at
sun.jdbc.rowset.RowSetWriterImpl.writeData(RowSetWriterImpl.java:228)
at
sun.jdbc.rowset.CachedRowSet.acceptChanges(CachedRowSet.java:784)
at
org.netbeans.lib.sql.NBCachedRowSet.acceptChangesInternal(NBCachedRowSet.java:535)
at
org.netbeans.lib.sql.NBCachedRowSet.insertDefaultRow(NBCachedRowSet.java:566)
Could you inform us when will be available version of JDBC driver which
will support that?
Thank you.