InnoDB « MySQL « JPA Q&A





1. MySQL InnoDB Database    forum.hibernate.org

I believe that he's asking what attribute or tag he needs to add to Hibernate mapping files so that the DDL generated from those mapping files will create transaction aware (i.e. InnoDB) tables in MySQL. This is a good question and one I'd be curious to know the answer to as well. -Matt

2. MySQL and InnoDB    forum.hibernate.org

3. MySQL, InnoDB and foreign keys    forum.hibernate.org

Caused by: java.sql.SQLException: General error, message from server: "Cannot delete or update a parent row: a foreign key constraint fails" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945) at com.mysql.jdbc.Connection.execSQL(Connection.java:1844) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:324) at net.sf.hibernate.persister.NormalizedEntityPersister.delete(NormalizedEntityPersister.java:606) ...

4. MySql InnoDB tables not persisting.    forum.hibernate.org

I have created a small app that is going against MySql 3.0.14. I am using iBatis to wrap Hibernate. Everything seems to be working fine from the unit test perspective (I see the keys incrementing in the output), but when I check the database to see if the records exist, they are not there. The weird thing is that as soon ...

5. Hibernate and MySQL InnoDB    forum.hibernate.org

6. Weird issue using Hibernate and MySQL innodb tables    forum.hibernate.org

Hey everyone, would love to know if anyone has any clue on what might be occuring. Im using hibernate with innodb type tables in MySQL. The data is being inserted into the database. I can retrieve the data via hibernate no problem also. However.. using ANY query analyzer i can not see the data in the actual database. this is the ...

7. Create MySQL InnoDB on deploy application    forum.hibernate.org

Hi, I have a web application using hibernate3 and mysql 4.1. I need create my tables when my application is deployed. everything is working fine, I am able to deploy my app and the tables are created. but the tables are created type MyIsam(no transaction) and I need InnoDB type. I am already using MySQLInnoDBDialect dialect but it still does not ...