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 <[EMAIL PROTECTED]> 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=DataSource,path=/TestWeb,host=localhost,class=
javax.sql.DataSource,name="jdbc/PhoenixDB"
When trying to use the DB2DataSourceFactory instead of the dbcp one...
<Context>
<Resource
name="jdbc/PhoenixDB"
auth="Container"
type="javax.sql.DataSource"
factory="com.ibm.db2.jcc.DB2DataSourceFactory"
driverClassName="com.ibm.db2.jcc.DB2Driver"
validationQuery="SELECT 1"
loginTimeout="10"
connectionProperties="currentSchema=T;"
maxWait="5000"
username="uid"
password="pwd"
testOnBorrow="true"
driverType="4"
url="jdbc:db2://test:50000/TDB"
/>
</Context>
Thanks,
-P
----- Original Message ----
From: Tim Lucia <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
____________________________________________________________________________________
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
"Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie
et toi dans les pleurs.
Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs
et toi dans la joie."
