FAQ: Teamwork 4.7 on Oracle

Tests on Oracle 10+ have shown that due to a change in default casting behavior in the last Hibernate stable release, Teamwork’s Oracle database must be changed as follows.

New Teamwork installation on version 4.7.25010 - 4.7.25011 - 4.7.25012:

This operation is required for all users having a new Teamwork installation created with version 4.7.25010 - 4.7.25011 - 4.7.25012.

You have to manually change type to several columns in your Teamwork database. Backup your database first.

In particular:

table: OLPL_MESSAGE   column: MESSAGEBODX

table: OLPL_ OPERATOR_ OPT column: VALUE_ TW

table:TWK_DOCUMENT column: CONTENTX



The type needs to be changed from LONG to CLOB. Here is the script to change column type to CLOB:

alter table
  tablename  
modify
(columnname CLOB
)

Also the following operations are required.

New Teamwork installation and upgraded ones:

This operation is required for both users: users having a new Teamwork installation created with version 4.7.25010 - 4.7.25011 - 4.7.25012 and users that have upgraded to Teamwork 4.7.

Once you have completed the update to version 4.7.25013 open the config.properties file

TEAMWORK_ROOT/webapps/ROOT/WEB-INF/

and change this line:

dialect=org.hibernate.dialect.Oracle10gDialect

with

dialect=org.hibernate.dialect.Oracle10gDialectDBText

Then save and restart the Teamwork service. Backup your Teamwork folder and your Teamwork database first as described here: http://www.twproject.com/upgradeFaq.page#upg4