If anyone is doing Oracle Connection Pooling with Tomcat, please let me know. I'm stuck: I've been at this for hours using this as my example: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html I keep getting this error: org.apache.commons.dbcp.DbcpException: java.sql.SQLException: invalid arguments in call at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source) at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312) ........ Here's my code: I import java.sql.*,javax.sql.*,oracle.jdbc.pool.*,javax.naming.* into a JSP page called ConnectionPool.jsp. I also add this code: <% Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/tatepool"); Connection conn = ds.getConnection(); conn.close(); %> I add these lines to my web.xml: <resource-ref> <description>Oracle Datasource</description> <res-ref-name>jdbc/tatepool</res-ref-name> <res-type>javax.sql.DataSource</res-type> </resource-ref> And here's my context for the app TATE in server.xml: <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" docBase="/usr/local/tomcat8081/webapps/tate" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/tate" privileged="false" reloadable="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Resource name="jdbc/tatepool" scope="Shareable" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/tatepool"> <parameter> <name>url</name> <value> <mailto:jdbc:oracle:thin:@oracle.mynode.com:1521:orcl> jdbc:oracle:thin:@oracle.mynode.com:1521:orcl</value> </parameter> <parameter> <name>validationQuery</name> <value></value> </parameter> <parameter> <name>maxIdle</name> <value>2</value> </parameter> <parameter> <name>maxActive</name> <value>4</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>user</name> <value>scott</value> </parameter> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>password</name> <value>tiger</value> </parameter> </ResourceParams> </Context>
Can anyone please help me? thanks! Troy Campano [:==> Troy Campano <==:] - Roadwarrior on the information superhighway Database (Request Manager/web/database) http://intranet:3000/infosys/infra/software/database/dbapp/ http://lm-web-prod.lmig.com/reqman/ Microsoft gave you Windows, UNIX the whole house. ==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
