Sharing some things we learned while working with SOA Suite 10g database adapters.
- Restrict the number of rows that will be returned by the query that is used in the database adapter. If you do not restrict the number of rows that is returned that could lead to high CPU and memory usage and time outs due to extreme processing time. These conditions can appear when a query results in severla thousand of rows returned.
- Changes the
this_toplink_mappings.xmlfile. If a
toplink:read-all-queryis used, change it to
- In case you forgot… if the audit level of the BPEL domain is still on
Developmentlevel change it to the
For links to File and FTP adapter stuff.