db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Eric Miller" <jemil...@uchicago.edu>
Subject Re: Tomcat / derby connection pool
Date Mon, 21 Feb 2005 15:31:23 GMT
I'm using something similar to the following. I have it in context.xml in 
the META-INF directory of my webapp. I'm using Derby as a separate server 
though and using the IBM UDB JDBC driver. Note, this syntax is for Tomcat 
5.5. It's different for earlier versions.

<Context>
<Resource name="jdbc/mydatabase"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:derby:net://localhost:1527/mydatabase;create=true:retrieveMessagesFromServerOnGetMessage=true;"
username="myuser"
password="mypassword"
maxActive="5"
maxIdle="5"
maxWait="60000"
validationQuery="VALUES(1)"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"/>
</Context>

Jon

----- Original Message ----- 
From: "Ravi BRavi" <ravioakton@hotmail.com>
To: <derby-user@db.apache.org>
Sent: Sunday, February 20, 2005 8:07 PM
Subject: Tomcat / derby connection pool


> Hi:
>
> I am new to both tomcat and derby - I am very familiar with weblogic and 
> oracle.
> I would like to create a database connection pool for a web application 
> (embedded model - tomcat and derby in the same jvm - I am following the 
> fortune tutorial example).
> Is there an example of the steps / syntax (server.xml) for "jdbc 
> connection pool" for tomcat / derby?
>
> Thanks
> -Ravi
>
> 


Mime
View raw message