Connecting to mysql 4.0.x using mysql-j-connector 5.1.14

Stevo Slavić <[email protected]> Sun, 12 Dec 2010 14:58:15 +0100
Newsgroups gmane.comp.db.mysql.java
Message-ID <[email protected]>
--001485f80ea49e4b5c049736fa83
Content-Type: text/plain; charset=ISO-8859-1

Hello MySQL Java Connector users and developers,

I know that mysql-j-connector doesn't list mysql 4.0.x as supported, anyway
I was able to connect to mysql 4.0.x with previous versions of
mysql-j-connector (<=5.1.13) but not with latest one, 5.1.14. Here is the
relevant exception stack trace:

WARN  org.hibernate.cfg.SettingsFactory - Could not obtain connection to
query metadata
java.sql.SQLException: ResultSet is from UPDATE. No Data.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
~[mysql-connector-java-5.1.14.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
~[mysql-connector-java-5.1.14.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
~[mysql-connector-java-5.1.14.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
~[mysql-connector-java-5.1.14.jar:na]
        at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7158)
~[mysql-connector-java-5.1.14.jar:na]
        at
com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3890)
~[mysql-connector-java-5.1.14.jar:na]
        at
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3431)
~[mysql-connector-java-5.1.14.jar:na]
        at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2386)
~[mysql-connector-java-5.1.14.jar:na]
        at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
~[mysql-connector-java-5.1.14.jar:na]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
~[mysql-connector-java-5.1.14.jar:na]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
~[mysql-connector-java-5.1.14.jar:na]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[na:1.6.0_17]
        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
~[na:1.6.0_17]
        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
~[na:1.6.0_17]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
~[na:1.6.0_17]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
~[mysql-connector-java-5.1.14.jar:na]
        at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
~[mysql-connector-java-5.1.14.jar:na]
        at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
~[mysql-connector-java-5.1.14.jar:na]
        at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
~[commons-dbcp-1.4.jar:1.4]
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
~[commons-dbcp-1.4.jar:1.4]
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
~[commons-pool-1.5.5.jar:1.5.5]
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
~[commons-dbcp-1.4.jar:1.4]
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
~[commons-dbcp-1.4.jar:1.4]
        at
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71)
~[hibernate-entitymanager-3.6.0.Final.jar:3.6.0.Final]
        at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)
~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
        at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2833)
[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
        at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2829)
[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
        at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1840)
[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
        at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:902)
[hibernate-entitymanager-3.6.0.Final.jar:3.6.0.Final]
        at
org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
[hibernate-entitymanager-3.6.0.Final.jar:3.6.0.Final]

Regards,
Stevo.

--001485f80ea49e4b5c049736fa83--