At present, I am using MySQL version 5.0.20. Inside my configuration file (hibernate.cfg.xml) I recently changed from:
<property name="dialect">org.hibernate.dialect.MySQLMyISAMDialect</property>
to
<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>.
I did this because I wanted my transactions to rollback if they were not commited properly. However the problem I am now having is that I cant view the data inside my InnoDB tables (via my phpMyAdmin page). Whenever I click on the 'browse' button I get the following message: "MySQL returned an empty result set". However, I know data is inside the tables because the 'browse' button is not dissabled. If there is no data in the tables the button become dissabled.
Does anyone know how to fix this problem?
Outlaw.
|