That was it. I had to specify the username in the URL. It seems strange since I already specify it as a parameter.
thanks! -----Original Message----- From: Vikramjit Singh To: [EMAIL PROTECTED] Sent: 8/18/02 6:37 AM Subject: Re: Oracle/Tomcat Connection Pooling in JSP > -----Original Message----- > From: Campano, Troy [mailto:[EMAIL PROTECTED]] > Sent: Saturday, August 17, 2002 5:02 PM > To: [EMAIL PROTECTED] > Subject: Oracle/Tomcat Connection Pooling in JSP > > > If anyone is doing Oracle Connection Pooling with Tomcat, > please let me know. I'm stuck: Yups vikram to the rescue ;). > > > I've been at this for hours using this as my example: > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasourc > e-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.createConnecti > on(DriverConnectionFactory.java:85) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P > oolableConnectionFactory.java:184) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Un > known Source) > at > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(Aband > onedObjectPool.java:117) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(Poolin > gDataSource.java:110) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > aSource.java:312) > ........ > What i can make out of the error is that your JNDI is not being created properly. I have tried connection pooling with tomcat 4.1.7 and classes12.zip. Which drivers are you using for Oracle ?. Try using the "username" parameter. Also, the solution that has worked flawlessly for me is here: http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 Note that this is with the new 4.1.x versions of Tomcat. If you are using 4.0.x versions, your mileage may vary. Try what is said in the link if the problem still persists lemme know. vikram. > > > > > 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 > ======================================================================== === 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 ==========================================================================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
