Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 75204 invoked from network); 8 Dec 2003 17:05:48 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 8 Dec 2003 17:05:48 -0000 Received: (qmail 83201 invoked by uid 500); 8 Dec 2003 17:05:38 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 82961 invoked by uid 500); 8 Dec 2003 17:05:36 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 82947 invoked from network); 8 Dec 2003 17:05:36 -0000 Received: from unknown (HELO lycos.com) (209.202.220.150) by daedalus.apache.org with SMTP; 8 Dec 2003 17:05:36 -0000 Received: from Unknown/Local ([?.?.?.?]) by mailcity.com; Mon, 08 Dec 2003 17:05:30 -0000 To: commons-user@jakarta.apache.org Date: Mon, 08 Dec 2003 12:05:30 -0500 From: "Vernon Smith" Message-ID: Mime-Version: 1.0 X-Sent-Mail: off Reply-To: vwu98034@lycos.com X-Mailer: MailCity Service X-Priority: 3 Subject: [DBCP] Can DBCP be used to solve this XA issue? X-Sender-Ip: 24.87.63.31 Organization: Lycos Mail (http://www.mail.lycos.com:80) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi, Here is a situation: During a user registration, data is inserted into a sequence of tables. Those insertion queries are submitted at different time during the registration. To maintain the data integrity, the data shall be either all written or none of them written. Other than this scenario, the rest of queries in the application work fine with the auto-commit setting. The current version of BD connection pool in place is unable to handle this issue without JTA. I have browsed over the DBCP API. It seems to me the DBCP might be able to the job. I have done a thorough search in the Jakarta site and using Google, unable to find more detailed document/examples on the subject. Can someone give me a help? Thanks, Vernon ____________________________________________________________ Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org