• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Unknown table 'sequences' in information_schema

 
Kalpesh Gada
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic