Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ?
I get belows error when tryig to connect from DbVisualizer which was working fine until a while ago. I haven't watched it recently, and haven't changed anything I am aware off right now. After I realized the problem I tried many 3.08 versions with the same symptom. Watch were it says "Unknown system variable 'autocommit'" - which I havent set as far as I know. Best regards Nils Valentin --------------------- java.sql.SQLException: General error, message from server: "Unknown system variable 'autocommit'" General error, message from server: "Unknown system variable 'autocommit'" 17:25:10 [DEBUG Thread-1 SchemaModel.expandNode] expandNode: Root 17:25:15 [DEBUG AWT-EventQueue-0 DbVisualizer.finished] Init Seconds: 11.189 17:25:15 [DEBUG Thread-3 ClassManager.loadDriver] Load class using ClassLoader: com.mysql.jdbc.Driver 17:25:15 [DEBUG Thread-3 ClassManager.loadDriver] Load class using ClassLoader: com.mysql.jdbc.NonRegisteringDriver 17:25:15 [DEBUG Thread-3 ClassManager.loadDriver] Load class using ClassLoader: org.gjt.mm.mysql.Driver 17:25:16 [DEBUG Thread-3 ClassManager.loadDriver] Load class using ClassLoader: com.mysql.jdbc.Driver 17:26:03 [INFO AWT-EventQueue-0 Database.connect] Connecting: MySQL-BBB 17:26:04 [DEBUG Thread-4 ClassManager.loadDriver] Load class using ClassLoader: com.mysql.jdbc.Driver java.sql.SQLException: General error, message from server: "Unknown system variable 'autocommit'" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1647) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:853) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:920) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:892) at com.mysql.jdbc.Connection.execSQL(Connection.java:1878) at com.mysql.jdbc.Connection.execSQL(Connection.java:1824) at com.mysql.jdbc.Connection.execSQL(Connection.java:1805) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:572) at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:2422) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1578) at com.mysql.jdbc.Connection.<init>(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at com.onseven.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:40) at com.onseven.dbvis.sql.Database.doConnect(Unknown Source) at com.onseven.dbvis.sql.Database.access$000(Unknown Source) at com.onseven.dbvis.sql.Database$ConnectionCommand.execute(Unknown Source) at se.pureit.util.ThreadCommand.runExecute(Unknown Source) at se.pureit.util.ThreadCommand.run(Unknown Source) at java.lang.Thread.run(Thread.java:534) -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]