I was about to try that, but I had a thought... wouldn't that mean that
batch transactions could not be used? I say that because, as I understand
it, you are supposed to explicitly turn off autocommit when committing a
batch, which only makes sense I think. If I specify at the data source
level autocommit should be turned on, wouldn't that by definition mean I
couldn't do batches? If that is the case, then even if your suggestion
works I couldn't use it because about half of my database writes are in
fact batches (I should point out that right now they fail the same as a
single insert, update or delete does).
Frank W. Zammetti
Web Architect Consultant
PFPC Global Fund Services
760 Moore Road
King Of Prussia, PA 19406
Mailstop: F4-F760-2B-3
eMail: [EMAIL PROTECTED]
Phone: (610)/382-8243
FAX: (610)/382-8866
Cell: (484)/302-1402
|---------+--------------------------->
| | Philipp Taprogge|
| | <Philipp.Taprogg|
| | [EMAIL PROTECTED]> |
| | |
| | 12/23/2003 02:29|
| | PM |
| | Please respond |
| | to "Tomcat Users|
| | List" |
| | |
|---------+--------------------------->
>--------------------------------------------------------------------------------------------------------------------------|
|
|
| To: Tomcat Users List <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: Re: Problem with database updates using DBCP
|
>--------------------------------------------------------------------------------------------------------------------------|
Hi!
David Ramsey wrote:
> I've not used DBCP specifically but are you sure you are committing
> your writes? Most pools will default rollback connections returned to
> the pool, if I am not mistaken.
Isn't there a parameter autocommit in the ConnectionFactory? I am not
sure if it's viable to call setAutoCommit() on a connection obtained
from the pool.
Try specifying autocommit in the DataSource declaration.
Phil
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-----------------------------------------
The contents of this email are the property of PNC. If it was not addressed to you,
you have no legal right to read it. If you think you received it in error, please
notify the sender. Do not forward or copy without permission of the sender.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
