is the ConnectionState Transaction aware? thanks Martin Gainty ______________________________________________ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
> Date: Fri, 28 Aug 2009 15:01:33 -0600 > From: devli...@hanik.com > To: users@tomcat.apache.org > Subject: Re: DBCP config question > > its better to see if there is a way to do it in the JDBC url itself. > As soon as you set the defaultAutoCommit flag to a value, DBCP will > issue a getAutoCommit and possible setAutoCommit each time you use the > connection. Both calls may go back to the DB depending on how the driver > implements it. > > Alternatively, you can try out a pool that is being developed in the > tomcat community, which as a ConnectionState component that caches the > auto commit state. > It also has a initSQL attribute to setup a DB session first time its > connected to the DB. > http://people.apache.org/~fhanik/jdbc-pool/v1.0.7.1/ > > Filip > > > On 08/28/2009 02:27 PM, Bill Davidson wrote: > > Tomcat 6.0.18 > > Oracle 10g > > Java 1.6.0_14 > > > > I'm a little curious about the defaultAutoCommit parameter. > > > > If I understand the docs and things I've googled correctly, if I don't > > set it, I get the JDBC driver default. More googling, suggests that > > the default for the Oracle JDBC driver is to have auto-commit > > enabled. I'm pretty sure I don't want that since I have some complex > > transactions going on. > > > > So I'm thinking I should set it to false to disable auto-commit. Is > > that correct? > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > _________________________________________________________________ Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_facebook:082009
