For some reason, Hibernate2.1 is putting an underscore ('_') in front of the table name when it generates the SQL for an insert. This results in a "Table commerce._contact doesn't exist" error.

My mapping file looks fine and I only have one set of mapping files in the classpath, so Hibernate must be using this one.

<class
name="com.commerce.model.contact.ContactBO"
table="Contact"
dynamic-update="false"
dynamic-insert="false"
>

Any ideas on how to solve this problem apart from changing my DDL each time to add underscores!?

tia
[/quote]

eh?! Are you sure?

Here's the error. I also get it on another mapping file for my ProductBO class.

2004-01-08 15:45:15,926 ERROR hibernate.util.JDBCExceptionReporter -> could not insert: [com.commerce.model.inventory.ProductBO]
java.sql.SQLException: General error, message from server: "Table 'commerce._contact' doesn't exist"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1750)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1596)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:502)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:433)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:876)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:817)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:737)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:717)
at com.test.commerce.HibernateDemoOneToMany.run(HibernateDemoOneToMany.java:93)
at com.test.commerce.HibernateDemoOneToMany.main(HibernateDemoOneToMany.java:31)
net.sf.hibernate.JDBCException: could not insert: [com.commerce.model.inventory.ProductBO]
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:541)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:433)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:876)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:817)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:737)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:717)
at com.test.commerce.HibernateDemoOneToMany.run(HibernateDemoOneToMany.java:93)
at com.test.commerce.HibernateDemoOneToMany.main(HibernateDemoOneToMany.java:31)
Caused by: java.sql.SQLException: General error, message from server: "Table 'commerce._contact' doesn't exist"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1750)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1596)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:502)
... 7 more

Do you specify a schema somewhere? note that MySQL does not have any support for schemas.

Thanks! I had the property there, but empty... After I removed it, the code worked fine.

###################################
### MySQL Database
###################################
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost/commerce
hibernate.connection.username=cuser
hibernate.connection.password=password
hibernate.default_schema= <-- NOT GOOD!
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
hibernate.show_sql=true

hmmmm that is probably suboptimal behavior on the part of Hibernate....

Just for your information:

I have just finished struggling with a similar problem: an underscore was systematically added in front of my table names.

The mapping files were generated using the Artifact generation tool (from the Hibernate Tools) used as Eclipse plugin.

Apparently by default an empty catalog attribute is added to the class-tag (in the mapping xml files) and this then caused hibernate to add the extra underscore.

I hope this will save some time for other people starting to work with Hibernate and Eclipse.

Greetings,

Gert

I had the same problem

Using the hibernate tool (hibern8) and generating the mapping files there was an extra catalog flag added to the hbm.xml class tag.

AFter removing this it worked fine.

I am using MySQL 4 and it's weird. But hey... its working fine now :)