From derby-user-return-9876-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Oct 08 22:11:28 2008 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 68091 invoked from network); 8 Oct 2008 22:11:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Oct 2008 22:11:28 -0000 Received: (qmail 34137 invoked by uid 500); 8 Oct 2008 22:11:26 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 34109 invoked by uid 500); 8 Oct 2008 22:11:26 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 34098 invoked by uid 99); 8 Oct 2008 22:11:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Oct 2008 15:11:26 -0700 X-ASF-Spam-Status: No, hits=2.1 required=10.0 tests=DNS_FROM_SECURITYSAGE,HTML_MESSAGE,MISSING_MID,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [217.77.176.18] (HELO smtp.titaninternet.co.uk) (217.77.176.18) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Oct 2008 22:10:22 +0000 Received: from kironabe56e496 ([217.155.110.182]) by smtp.titaninternet.co.uk (Merak 7.5.2) with ASMTP id GNL39351 for ; Wed, 08 Oct 2008 23:10:57 +0100 From: "Paul French" To: "'Derby Discussion'" Subject: Embedded Derby + J2ME + JDBC Connection Pooling Date: Wed, 8 Oct 2008 23:10:59 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01C9299B.20A20AD0" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 Thread-Index: Ackpkr6DXYT/5i/wThmV8b4BdpjIkw== X-Virus-Checked: Checked by ClamAV on apache.org Message-Id: <20081008221030.DE47572495C@athena.apache.org> This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C9299B.20A20AD0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hello All, I create an EmbeddedSimpleDataSource in my code. My application is multi-threaded. I assume EmbeddedSimpleDataSource is thread safe from the point of view of obtaining connections. What is the cost of getting a connection each time I need to do some database work? (Derby is running embedded in my application) If the cost is high then I would like to use a light weight Connection Pool Manager similar to Apache Commons DBCP, any ideas of a good implementation that works on J2ME Personal Profile 1.1.2 Thanks Paul ------=_NextPart_000_000D_01C9299B.20A20AD0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
Hello=20 All,
 
I = create an=20 EmbeddedSimpleDataSource in my code. My application is multi-threaded. I = assume=20 EmbeddedSimpleDataSource is thread safe from the point of view of = obtaining=20 connections.
 
What = is the cost of=20 getting a connection each time I need to do some database work? (Derby = is=20 running embedded in my application)
 
If the = cost is high=20 then I would like to use a light weight Connection Pool Manager similar = to=20 Apache Commons DBCP, any ideas of a good implementation that works on = J2ME=20 Personal Profile 1.1.2
 
Thanks
Paul
------=_NextPart_000_000D_01C9299B.20A20AD0--