hi , i am working on jdbc adapter on WM6.
I am using 2 databases for my integration
1.Select from SQL db
2.Select from second database(Oracle)
3.do mapping and then Insert into second database(Oracle)
my connection properties for Oracle is as follows :
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
for SQL db i am using NO_TRANSACTION (buz of only Select st)in my configuration
AND for oracle i am using LOCAL_TRANSACTION (select and insert) .
When i run it i can successfully insert but when i run whole program
i cant run its giving me error like it cannot Commit the transaction
so i went thought like this to solve my problem
commit transaction Start transaction
Its working but its taking long time to process it like 1200 sec for one transaction that insert around 100 rows.
is there any other way to do make this more efficient.If i try to do some other way its give me errors like “unable to close connection” and something like that
I will appreciate ,