how to configure autocommit in Webshpere application server

Hi,

I understand that autocommit is set to TRUE by default in DB2.
My application is deployed in WAS 6.1 server
Can I change autocommit setting in my server? If so where?

Thanks,
Gokul

Sounds like a websphere configuration question to me, moving...

Gokul,
Check in the admin console under datasources. I don't remember off the top of my head if that setting can be changed via the console. If it can, that is the place to look.

I already checked in WAS 6.1 console under datasources and was not able to find it. So was not sure where to look

If I remember your two choices are:

1. Define a custom property called autocommit=false under Datasource Custom properties.

2. Set the value of autocommit to false whenever you get the connection from datasource in your code.

Thanks Deepak.
I guessed it should be an additonal property we need to add to custom properties