drizzle-jdbc on MySQL 5.0.x

Asked by Tim Plessers on 2013-02-12


I'm using the drizzle-jdbc driver to interface with MySQL. Everything works well on MySQL 5.1.x, but on 5.0.x I receive an error :

2013-02-12 16:36:03,234 INFO [STDOUT] Feb 12, 2013 4:36:03 PM org.drizzle.jdbc.internal.mysql.MySQLProtocol executeQuery
WARNING: Could not execute query org.drizzle.jdbc.internal.common.query.DrizzleQuery@67adf2d7: Unknown table 'referential_constraints' in information_schema
2013-02-12 16:36:03,243 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1109, SQLState: 42S02
2013-02-12 16:36:03,244 ERROR [org.hibernate.util.JDBCExceptionReporter] Unknown table 'referential_constraints' in information_schema

information_schema.referential_constraints is indeed available from MySQL 5.1.x on. I did some Googling on this issue, but I can't seem to find a solution for it. Is upgrading to 5.1.x the only possibility, or can this be fixed somehow?

Kind Regards.
Tim Plessers

Question information

English Edit question
Drizzle Edit question
No assignee Edit question
Last query:
Last reply:
Launchpad Janitor (janitor) said : #1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Stewart Smith (stewart) said : #2

It's best to ask this as part of the drizzle-jdbc project over at https://github.com/krummas/DrizzleJDBC

Stewart Smith (stewart) said : #3

go to the DrizzleJDBC project at https://github.com/krummas/DrizzleJDBC

Can you help with this problem?

Provide an answer of your own, or ask Tim Plessers for more information if necessary.

To post a message you must log in.