My application uses Oracle 9i, release 2 and is using the DataSourceTransactionManager. My DAO's are using a TransactionProxyFactoryBean with the following transaction attributes:
PROPAGATION_REQUIRED (for inserts, updates, & deletes)
PROPAGATION_REQUIRED, readOnly (for selects)
The problem is that these database connections are creating stale oracle processes with the following sql (from V$SQL):
"SET TRANSACTION READ WRITE"
"ALTER SESSION SET TIME_ZONE='-4:00'"
Should I be using different transaction attributes or additional configuration that I can change to eliminate the dreaded "ORA-00020 maximum number of processes (string) exceeded" error?