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.SQLExc eption: 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.exp andNode] expandNode: Root
17:25:15 [DEBUG AWT-EventQueue-0 DbVisualizer.fi nished] Init Seconds: 11.189
17:25:15 [DEBUG Thread-3 ClassManager.lo adDriver] Load class using
ClassLoader: com.mysql.jdbc. Driver
17:25:15 [DEBUG Thread-3 ClassManager.lo adDriver] Load class using
ClassLoader: com.mysql.jdbc. NonRegisteringD river
17:25:15 [DEBUG Thread-3 ClassManager.lo adDriver] Load class using
ClassLoader: org.gjt.mm.mysq l.Driver
17:25:16 [DEBUG Thread-3 ClassManager.lo adDriver] Load class using
ClassLoader: com.mysql.jdbc. Driver
17:26:03 [INFO AWT-EventQueue-0 Database.connec t] Connecting: MySQL-BBB
17:26:04 [DEBUG Thread-4 ClassManager.lo adDriver] Load class using
ClassLoader: com.mysql.jdbc. Driver
java.sql.SQLExc eption: General error, message from server: "Unknown system
variable 'autocommit'"
at com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:1647)
at com.mysql.jdbc. MysqlIO.sendCom mand(MysqlIO.ja va:853)
at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:920)
at com.mysql.jdbc. MysqlIO.sqlQuer y(MysqlIO.java: 892)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:1878)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:1824)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:1805)
at com.mysql.jdbc. Connection.setA utoCommit(Conne ction.java:572)
at
com.mysql.jdbc. Connection.init ializePropsFrom Server(Connecti on.java:2422)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:1578)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:491)
at
com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:346)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:140)
at
com.onseven.dbv is.wrapper.Driv erManagerImpl.g etConnection(Dr iverManagerImpl .java:40)
at com.onseven.dbv is.sql.Database .doConnect(Unkn own Source)
at com.onseven.dbv is.sql.Database .access$000(Unk nown Source)
at com.onseven.dbv is.sql.Database $ConnectionComm and.execute(Unk nown
Source)
at se.pureit.util. ThreadCommand.r unExecute(Unkno wn Source)
at se.pureit.util. ThreadCommand.r un(Unknown Source)
at java.lang.Threa d.run(Thread.ja va:534)
--
---
Valentin Nils
Internet Technology
E-Mail: ni**@knowd.co.j p
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/my***********...ie.nctu.edu.tw