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 141 removed 2 lines.

At line 239 removed 14 lines.

__Turn off Hibernate Batch Processing for PostgreSQL__ (2004-12-06 [NPA|NathanAnderson])\\

When an exception is thrown while performing batch processing in Hibernate on PostgreSQL the cause of the exception is never displayed in the stack trace. By turning off the batch processing exceptions get reported immediately and completely. This can be done by adding an entry into {{applicationContext-hibernate.xml}}. Within the element {{sessionFactory}}, locate the property {{hibernateProperties}} and make it look like this:

{{{

<props>

<prop key="hibernate.dialect">@HIBERNATE-DIALECT@</prop>

</props>

</property>

}}}

This will have an effect on the performance of the database, so consider the tradeoff of having better error messages.

Raible's Wiki

AppFuse

Other Applications

AppFuseOnDB2