Schema Export Unsuccesful

[Kevin Florish]

Am still on the first tutorial from Cameron Mckenzie's 'Hibernate Made Easy' book, and lots of things still going wrong so although not getting very far with the example am picking up a lot of new stuff

The problem now is that the examscam schema can't seem to be found using the hibernate.cfg.xml file I am using. I have copies of the schema in the c:\ root directory and also at C:\Program Files\MySQL

hibernate.cfg.xml

  <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory>
		<property name="connection.url">jdbc:mysql://localhost/examscam</property>
		<property name="connection.username">root</property>
		<property name="connection.password">kflorish</property>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
		<property name="current_session_context_class">thread</property>
		<!--this will show us all the sql statements-->
		<property name="hibernate.show_sql">true</property>
	</session-factory>
</hibernate-configuration>

Stacktrace

 0 [main] INFO org.hibernate.cfg.annotations.Version - Hibernate Annotations 3.5.1-Final
15 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.5.1-Final
15 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
31 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
31 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
156 [main] INFO org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.2.0.Final
171 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
171 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
265 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
281 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
390 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: org.hibernate.tutorial.domain.User
437 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity org.hibernate.tutorial.domain.User on table User
484 [main] INFO org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
515 [main] INFO org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export
515 [main] INFO org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database
515 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
515 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
515 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
531 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/examscam
531 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}
781 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - schema export unsuccessful
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'examscam'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.Util.getInstance(Util.java:384)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4000)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1285)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2186)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
	at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:52)
	at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)
	at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
	at org.hibernate.tutorial.domain.User.main(User.java:37)
   

Any pointers to where i am going wrong would be greatly appreciated.

Thaks Kevin.

[Vijitha Kumara]

Do you have a database 'examscam' in the MySQL engine? Does "show databases;" command in MySQL prompt show you that it exists? If not create a one using "create database examscam;".

[Kevin Florish]

Hi Vijitha thanks for the fast reply.

I am also new to MySql so unsure of how to enter the commands you mentioned (went to dos command line and the Mysql directory and tried from there but didnt work). But in MySql workbench the examscam.mwb Schema definitely exists (maybe because it was created in workbench the file extension is different?)

I am wading through a plethora of documentation on MySql, Maven, Ecipse addons and hibernate at the moment trying to bring this all together

Thanks Kevin.

[Vijitha Kumara]

... I am also new to MySql so unsure of how to enter the commands you mentioned (went to dos command line and the Mysql directory and tried from there but didnt work).

Go to the bin directory of the MySQL installation directory in command prompt and type "mysql -u root" (this should work if you haven't set any password for the root & assuming MySQL is running). Then you will be taken in to the MySQL prompt with root privileges. Try the command mentioned in the previous post, see what happens.

[David Newton]

I'd recommend taking a step back: you are trying to do *far* too many things at once.

[Kevin Florish]

Thanks for the example Vijitha, the 'show databases' command confirmed my suspicion that although the schema is present in the MySQL Workbench. Mysql doesn't show the database and therefore Eclipse is unaware of it.

I have now created the database from the MySql prompt and everything is working as intended

Thanks again for the help.

Kevin.