We upgraded from 4.0.2 to 4.6 on Solaris 2.8 and now we’ve noticed that a set of services that insert into the oracle db are not working. After some testing we found out that if we put a commit after the insert and before the close statement, then the row will show up in the database.
Now the problem is that the first time the commit was executed, it commited rows for the previous 3 runs of the services. And each run had it’s own connect -> insert -> close sequence.
So what appears to happen is that the transaction is across the Alias and not the database connection!
Anybody else seen this?