Raible's Wiki

Raible Designs
Wiki Home
News
Recent Changes

AppFuse

Homepage
  - Korean
  - Chinese
  - Italian
  - Japanese

QuickStart Guide
  - Chinese
  - French
  - German
  - Italian
  - Korean
  - Portuguese
  - Spanish
  - Japanese

User Guide
  - Korean
  - Chinese

Tutorials
  - Chinese
  - German
  - Italian
  - Korean
  - Portuguese
  - Spanish

FAQ
  - Korean

Latest Downloads

Other Applications

Struts Resume
Security Example
Struts Menu

Set your name in
UserPreferences


Referenced by
AppFuseOnPostgreSQL
AppFuseSupport
Articles
Articles_cn
Articles_de
Articles_pt
Articles_zh
CreateDAO
CreateDAO_de
CreateDAO_es
...and 4 more




JSPWiki v2.2.33

[RSS]


Hide Menu

AppFuseOnDB2


Difference between version 22 and version 18:

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 1 line.
At line 238 removed 14 lines.
__Turn off Hibernate Batch Processing for PostgreSQL__\\ [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:
{{{
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">@HIBERNATE-DIALECT@</prop>
<!-- turn off batch updated for PostgreSQL to get nicer exception messages -->
<prop key="hibernate.jdbc.batch_size">0</prop>
</props>
</property>
}}}
This will have an effect on the performance of the database, so consider the tradeoff of having better error messages.

Back to AppFuseOnDB2, or to the Page History.