I am getting "java.sql.SQLException: Cannot disable AUTO_COMMIT" exception
when using mySQL
with Weblogic EJB (through org.gjt.mm.mysql.Driver JDBC driver).
what is the driver version? Could you do this using the same driver?:
public class Foo {
public static void main(String args[]) {
try {
java.sql.Connection conn = DriverManager.getConnection(blah);
System.out.println("got connection...");
System.out.println("connection autocommit value is
"+conn.getAutoCommit());
conn.setAutoCommit(true);
System.out.println("set autocommit to 'false', i.e. if got here
everything is cool with driver...");
} catch (Exception e) {
e.printStackTrace();
}
}
}
if above code sniplet works and you don't have multiple versions of the
mm.mysql driver laying around or sitting in your CLASSPATH then I would
blame WebLogic configuration. Make sure that you configured everything
correctly, seems like you using connection pool, so make sure that the
correct driver is being used and etc, you know the drill...
Hope this helps.
Best regards,
2 messages in com.mysql.lists.javaRe: "java.sql.SQLException: Cannot di...