Return-Path: 
 <users-return-157730-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 65351 invoked from network); 4 Feb 2007 09:37:06 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 4 Feb 2007 09:37:06 -0000
Received: (qmail 2319 invoked by uid 500); 4 Feb 2007 09:36:59 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 2301 invoked by uid 500); 4 Feb 2007 09:36:58 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 2290 invoked by uid 99); 4 Feb 2007 09:36:58 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Feb 2007 01:36:58 -0800
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of olivier.nouguier@gmail.com
 designates 66.249.92.175 as permitted sender)
Received: from [66.249.92.175] (HELO ug-out-1314.google.com) (66.249.92.175)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Feb 2007 01:36:49 -0800
Received: by ug-out-1314.google.com with SMTP id h2so966815ugf
        for <users@tomcat.apache.org>; Sun, 04 Feb 2007 01:36:28 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=FMxNJxVYpOgN51NUxmBCCOB7YOr0w5Q4Kg9lps+06Jy8xftSejrsWBK/KXCBHtiUjgxXELsysIAU7/ihkUd9QM1PhbAkGZ2H91O1JydXc4RJuy5jzkJzI5w94YrqYux1JZXg+1Qs0KehS+Z9RwYQrtU1S9jV+HSj1Jfv/hhH75Q=
Received: by 10.66.243.2 with SMTP id q2mr7082405ugh.1170581788063;
        Sun, 04 Feb 2007 01:36:28 -0800 (PST)
Received: by 10.66.250.16 with HTTP; Sun, 4 Feb 2007 01:36:28 -0800 (PST)
Message-ID: <2e851c270702040136n752af5d3h8bb9aaf0ef8a48ff@mail.gmail.com>
Date: Sun, 4 Feb 2007 10:36:28 +0100
From: "olivier nouguier" <olivier.nouguier@gmail.com>
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: DB2/Tomcat Connection pooling problem
In-Reply-To: <184389.60493.qm@web50405.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_50528_29383107.1170581788023"
References: <184389.60493.qm@web50405.mail.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_50528_29383107.1170581788023
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi
Are you you sure that "select 1" is a valid query under DB2?
It is under mysql but it is not under DB2/AS400  !
HIH

On 2/2/07, Pete <pwkpete@yahoo.com> wrote:
>
> Thanks Tim.
>
> More information to my intial question:
>     -I have also installed Websphere App Server on this machine and
> configured the application to work correctly there.
>     -Shutdown WAS to run Tomcat
>     -I have Tomcat working on my home server with a mysql database, so I
> do have something working!
>
> I also get this error:
> SEVERE: Null component
> Catalina:type=3DDataSource,path=3D/TestWeb,host=3Dlocalhost,class=3D
> javax.sql.DataSource,name=3D"jdbc/PhoenixDB"
>
> When trying to use the DB2DataSourceFactory instead of the dbcp one...
> <Context>
> <Resource
>         name=3D"jdbc/PhoenixDB"
>         auth=3D"Container"
>         type=3D"javax.sql.DataSource"
>         factory=3D"com.ibm.db2.jcc.DB2DataSourceFactory"
>         driverClassName=3D"com.ibm.db2.jcc.DB2Driver"
>         validationQuery=3D"SELECT 1"
>         loginTimeout=3D"10"
>         connectionProperties=3D"currentSchema=3DT;"
>         maxWait=3D"5000"
>         username=3D"uid"
>         password=3D"pwd"
>         testOnBorrow=3D"true"
>         driverType=3D"4"
>         url=3D"jdbc:db2://test:50000/TDB"
>         />
> </Context>
>
> Thanks,
> -P
>
> ----- Original Message ----
> From: Tim Lucia <timlucia@yahoo.com>
> To: Tomcat Users List <users@tomcat.apache.org>
> Sent: Friday, February 2, 2007 1:29:05 PM
> Subject: RE: DB2/Tomcat Connection pooling problem
>
> > Also in V6, it seems to be using a version of dbcp associated with
> tomcat
> > as opposed to commons. (org.apache.tomcat.dbcp.*) Has some underlying
> > behavior changed as well here?
>
> This is the standard behavior with 5.5.x -- DBCP is repackaged under the
> Tomcat package (presumably) to avoid conflicts with commons DBCP.
>
> Tim
>
>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
>
>
>
>
> _________________________________________________________________________=
___________
> Any questions? Get answers on any topic at www.Answers.yahoo.com.  Try it
> now.
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


--=20
"Souviens-toi qu'au moment de ta naissance tout le monde =E9tait dans la jo=
ie
et toi dans les pleurs.
Vis de mani=E8re qu'au moment de ta mort, tout le monde soit dans les pleur=
s
et toi dans la joie."

------=_Part_50528_29383107.1170581788023--