Archive for January, 2013

Oracle JCA Database adapter and performance win on big clobs

In a few of our services in bpel and osb we're inserting a lot of data (big payload messages) into the database by use of the jca db adapter. We noticed performance would drop hugely when the db adapter needed to insert big payloads (CLOBS) and when the stream of messages on these services would continue even more performance would dramastically go down on the system. After disabling "wrap data types" on the datasource in Weblogic we had a pretty good performance win on processing big clob...