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