aspose file tools*
The moose likes Object Relational Mapping and the fly likes Unknown table 'sequences' in information_schema Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Unknown table Watch "Unknown table New topic
Author

Unknown table 'sequences' in information_schema

Kalpesh Gada
Greenhorn

Joined: Oct 21, 2009
Posts: 2
Hi All,
I am using spring 2.5 framework with mysql as backend. I am trying to validate the database schema with my model classes using the following statement.

<prop key="hibernate.hbm2ddl.auto">validate</prop>

I am getting the following validation error:

[ERROR] [] [org.hibernate.tool.hbm2ddl.SchemaValidator.validate(120)] | could not complete schema validation
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

I am not using information_schema database at all but it comes with mysql by default. There is no such "sequences" table in that database. Has anyone come across this issue before or know solution to this ???

Thanks
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Kalpesh Gada wrote:Hi All,
I am using spring 2.5 framework with mysql as backend. I am trying to validate the database schema with my model classes using the following statement.

<prop key="hibernate.hbm2ddl.auto">validate</prop>

I am getting the following validation error:

[ERROR] [] [org.hibernate.tool.hbm2ddl.SchemaValidator.validate(120)] | could not complete schema validation
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

I am not using information_schema database at all but it comes with mysql by default. There is no such "sequences" table in that database. Has anyone come across this issue before or know solution to this ???

Thanks


Moving this to the ORM forum where you will probably get more responses. This is not a Spring issue, more of the Hibernate tool issue. But it is probably based on your mapping of a Primary key that is sequence or auto-increment based.

So you will need to post more of your mapping.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unknown table 'sequences' in information_schema