nils

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.ja va:1647)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:85 3)
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.initializePropsFromServe r(Connection.java:2422)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1578)
at com.mysql.jdbc.Connection.<init>(Connection.java:4 91)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:140)
at
com.onseven.dbvis.wrapper.DriverManagerImpl.getCon nection(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.e xecute(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: nils@knowd.co.jp
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/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw