Raible's Wiki: AppFuseOnDB2

At line 5 removed 2 lines.

__January 16, 2004 UPDATE:__ I greatly simplified this process in AppFuse and altered this HowTo accordingly. This reflects the latest code in CVS and updates that will be in 1.3.

At line 29 changed 1 line.

Edit your build.properties file to reflect your new database of choice. MySQL settings are the defaults specified in properties.xml. Here is a sample for DB2, followed by one for PostgreSQL:

Edit your build.properties file to reflect your new database of choice. MySQL settings are the defaults specified in properties.xml. Here is a sample for DB2:

At line 41 changed 1 line.

hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect

hibernate.dialect=org.hibernate.dialect.DB2Dialect

At line 48 removed 18 lines.

__PostgreSQL:___

{{{

database.jar=${postgresql.jar}

database.type=postgresql

database.name=appfuse

database.host=localhost

#database URL for creating other databases

database.admin.url=jdbc:${database.type}://${database.host}/template1

database.admin.username=postgres

database.admin.password=postgres

hibernate.dialect=net.sf.hibernate.dialect.PostgreSQLDialect

database.driver_class=org.postgresql.Driver

database.url=jdbc:${database.type}://${database.host}/${database.name}

database.username=postgres

database.password=postgres

}}}

At line 68 changed 1 line.

I was unable to create databases ''on-the-fly'' (using JDBC) on PostgresSQL (transaction error) or on DB2. Therefore, I changed the "db-create" target to only attempt to do this for MySQL. If you're not using MySQL, you don't need to specify the database.admin.* properties since they won't be used. See the DB2 Sample Script[#6] for creating a new database in the ''Command Line Processor''.

I was unable to create databases ''on-the-fly'' (using JDBC) on PostgresSQL (transaction error) or on DB2. Therefore, I changed the "db-create" target to only attempt to do this for MySQL. If you're not using MySQL, you don't need to specify the database.admin.* properties since they won't be used. See the DB2 Sample Script[6] for creating a new database in the ''Command Line Processor''.

At line 99 changed 1 line.

After trying AppFuse on PostgreSQL, I discovered that using Hibernate's ''generator-class="native"'' for my id's failed. This is likely due to the fact that I'm inserting data (using DBUnit) and the sequences get out of wack. I changed all id's to "increment" (example below) and it fixed the problem. This worked on all the databases I tested (MySQL, PostgreSQL and DB2).

__NOTE:__ After trying AppFuse on PostgreSQL, I discovered that using Hibernate's ''generator-class="native"'' for my id's failed. This is likely due to the fact that I'm inserting data (using DBUnit) and the sequences get out of wack. I changed all id's to "increment" (example below) and it fixed the problem. This worked on all the databases I tested (MySQL, PostgreSQL and DB2).

At line 135 added 1 line.

At line 160 changed 1 line.

test -> admin (usernames and passwords)

test -> db2admin (usernames and passwords)

At line 172 changed 1 line.

{{{ [java] at org.appfuse.persistence.UserDAOHibernate.getUsers(UserDAOHibernate.java:89)

{{{ [java] at org.appfuse.dao.UserDAOHibernate.getUsers(UserDAOHibernate.java:89)

Raible's Wiki

AppFuse

Other Applications

AppFuseOnDB2