tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "olivier nouguier" <olivier.nougu...@gmail.com>
Subject Re: DB2/Tomcat Connection pooling problem
Date Sun, 04 Feb 2007 09:36:28 GMT
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=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 <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
>
>


-- 
"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."

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message