rss
SOATUBE
Oracle
Custom Search SOABYTE here

Sunday, November 6, 2011

How to preserve whitespace in a Db Adapter read operation

Oracle recommends that you use varchar instead of char for primary key columns, otherwise you will need to set the weblogic-ra.xml property shouldTrimStrings to false. The truncation of trailing spaces could cause the primary key to be read incorrectly, making it impossible to update read rows as processed.

To set shouldTrimStrings  to false

This property is not exposed by default. It need to be enabled by doing jar xvf DbAdapter.rar META-INF/ra.xml, adding it, then jar uvf DbAdapter.rar META-INF/ra.xml and restarting your server.

0 comments:

Post a Comment

 
Blogger Profile