You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Sridhar <sr...@wicore.com> on 2005/07/19 10:51:34 UTC

Fw: Connection Pool problem...........



Hi,

How to configure connection pools for Oracle in Tomcat.
follwing code included in the server.xml file even connection pool in not configured.copied the Oracle driver into lib directory.

<Resource name="XYZDS" auth="Container"
 type="javax.sql.DataSource" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
 username="kalakaarz" password="kalakaarz123"
 driverClassName="oracle.jdbc.driver.OracleDriver"
 url="jdbc:oracle:thin:@192.168.1.13:1521:smsc"
 maxWait="1000" 
 removeAbandoned="true"
 maxActive="30"
 maxIdle="10"
 removeAbandonedTimeout="60"
 logAbandoned="true"/>

try{
InitialContext context=new InitialContext();
DataSource ds=(DataSource)context.lookup("XYZDS");
Connection con=ds.getConnection();
--
}catch(Exception e{}


In server name not bound error is coming...

Can anyone help me...