I setup the JDBC pooling successfully as mentioned in tomcat website. Put the context.xml in META-INF file. Everything is working fine, i am able to access database. The problem now is everytime i call ds.getConnection(). It's creating a new intance in oracle under linux.
Is it normal??. And the isntances leave hanging eventhough i closed the connection successuly once i finished querying. Shouldn't it get the existing connection opened rather than creating another instance.