Mysql Specific in Appfuse

• I get an "access denied" error when trying to create the MySQL Database.

The issue is likely because you're on Unix or you've changed the root password. See this page for assistance.

• I get an "Illegal mix of collations" when I try to run tests against a MySQL database.

MySQL 4.1.7 requires you to add set the default character set to UTF-8 to get unicode support with AppFuse. To do this, add the following to your c:/Windows/my.ini or /etc/my.cnf file:

[mysqld]
default-character-set=utf8

• I'm have methods that throw exceptions in a Transaction and nothing is being rolled back. What gives?

MySQL's default tables (MyISAM) do not support transactions by default. Add or replace the following line in your c:/Windows/my.ini or /etc/my.cnf file. You could also use PostgreSQL.

[mysqld]
default-storage-engine=innodb

NOTE: You may see default-storage-engine's synonym "default-table-type" in the configuration file. If so, set the value of that parameter to "innodb" instead.

BTW, MySQL Administrator is a nice tool for administering/monitoring MySQL.

• I'm having trouble with MySQL on Suse 9.2.

Upgrading to the MySQL 3.1.5 JDBC Driver (or above) should fix this.

• Can AppFuse talk to multiple databases?

• Can I audit any changes to the Database?

• I get an "Could not synchronize database state with session" exception when I try to run test-dao.

If a class with a natural key does not declare a version or timestamp property, it's more dificult to get saveOrUpdate() and cascades to work correctly. You might use a custom Hibernate Interceptor as discussed in this chapter. (On the other hand, if you're happy to use explicit save() and explicit update() instead of saveOrUpdate() and cascades, Hibernate doesn't need to be able to distinguish between transient and detached instances; so you can safely ignore this advice.) Composite natural keys extend the same ideas. {Hibernate in Action: pag.:333}

• What DB admin/clients can I use to administer my database?
• How do I use AppFuse with SQL Server.
• How do I use AppFuse and Mckoi database.
• How to run AppFuse on DB2.
• How to run AppFuse on Oracle.
• How to configure AppFuse for HSQLDB.
• How to run AppFuse on PostgreSQL.