Re: DBCP question
Roberts, Eric wrote: Try this way instead - it works for me! Thanks, I'll try it. I just thought that I cat use Oracle dbcp implementation only, without BasicDataSourceFactory Tomcat alternative. Server.xml: Resource description=Oracle database resource for esljsp project name=jdbc/esljsp-oracle auth=Container type=javax.sql.DataSource/ . . ResourceParams name=jdbc/esljsp-oracle . . parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@db.server.ru:1521:sidvalue/value /parameter. . web.xml: . . resource-ref descriptionOracle database resource for esljsp project/description res-ref-namejdbc/esljsp-oracle/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref . . Source: . . import javax.naming.Context; import javax.naming.InitialContext; . . ctx = new InitialContext(); Context envCtx = (Context) ctx.lookup(java:/comp/env/); DataSource ds = (DataSource) envCtx.lookup(/esljsp-oracle); Hope this helps! --= [ original post cut ] =-- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: DBCP question
Hi Veniamin, Try this way instead - it works for me! Server.xml: Resource description=Oracle database resource for esljsp project name=jdbc/esljsp-oracle auth=Container type=javax.sql.DataSource/ . . ResourceParams name=jdbc/esljsp-oracle . . parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@db.server.ru:1521:sidvalue/value /parameter. . web.xml: . . resource-ref descriptionOracle database resource for esljsp project/description res-ref-namejdbc/esljsp-oracle/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref . . Source: . . import javax.naming.Context; import javax.naming.InitialContext; . . ctx = new InitialContext(); Context envCtx = (Context) ctx.lookup(java:/comp/env/); DataSource ds = (DataSource) envCtx.lookup(/esljsp-oracle); Hope this helps! -Original Message- From: Veniamin Fichin [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 04. Dezember 2002 20:28 To: Tomcat Users List Subject: DBCP question Hello cats! I'm trying to implement connection pool with Oracle8 database. After some codewriting I stuck with a problem which I don't know how to solve. Here are my configs and source code. --= [ server.xml ] =-- Server port=8005 shutdown=SHUTDOWN debug=0 Service name=Tomcat-Standalone Connector className=org.apache.coyote.tomcat4.CoyoteConnector port=8080 minProcessors=5 maxProcessors=75 enableLookups=true acceptCount=10 debug=0 connectionTimeout=2 useURIValidationHack=false / Engine name=Standalone defaultHost=localhost debug=0 Logger className=org.apache.catalina.logger.FileLogger prefix=catalina_log. suffix=.txt timestamp=true / Host name=localhost debug=0 appBase=webapps unpackWARs=true autoDeploy=true Logger className=org.apache.catalina.logger.FileLogger directory=logs prefix=localhost_log. suffix=.txt timestamp=true / Context path=/esljsp docBase=esljsp debug=5 reloadable=true !-- I suspect I've chosen wrong class in type value -- Resource name=jdbc/esljsp-oracle type=oracle.jdbc.pool.OracleConnectionPoolDataSource auth=Container description=Oracle database resource for esljsp project / ResourceParams name=jdbc/esljsp-oracle parameter namedataSourceName/name valueoracle.jdbc.pool.OracleDataSource/value /parameter parameter namedescription/name valueOracle database resource for esljsp project/value /parameter parameter nameserverName/name valuedb.server.ru/value /parameter parameter nameportNumber/name value1521/value /parameter parameter namenetworkProtocol/name valuetcp/value /parameter parameter namedatabaseName/name valuesidvalue/value /parameter parameter nameuser/name valueusername/value /parameter parameter namepassword/name valuepassword/value /parameter /ResourceParams Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_esljsp_log. suffix=.txt timestamp=true / /Context /Host /Engine /Service /Server --= [ / server.xml ] =-- --= [ / web.xml ] =-- ?xml version=1.0 encoding=ISO-8859-1? !DOCTYPE web-app PUBLIC -//Sun Microsystems, Inc.//DTD Web Application 2.3//EN http://java.sun.com/dtd/web-app_2_3.dtd; web-app !-- taglib taglib-uri/esl-adm.tld/taglib-uri taglib-location/WEB-INF/esl-adm.tld/taglib-location /taglib -- servlet servlet-nameDBAccessTest/servlet-name servlet-classru.rbcsoft.esljsp.DBAccessTest/servlet-class /servlet servlet-mapping !-- this servler creates OracleConnectionPoolDataSource instance right -- servlet-nameDBAccessTest/servlet-name url-pattern/dbaccess/DBAccessTest/url-pattern /servlet-mapping resource-ref descriptionOracle database resource for esljsp project/description res-ref-namejdbc/esljsp-oracle/res-ref-name res-typeoracle.jdbc.pool.OracleConnectionPoolDataSource/res-type res-authContainer/res-auth res-sharing-scopeUnshareable/res-sharing-scope /resource-ref /web-app --= [ / web.xml ] =-- --= [ index.jsp ] =-- %@ page isThreadSafe=false info=Database access test|Index page contentType=text/html; charset=utf-8 % %@ page import=javax.naming.InitialContext, javax.naming.Context % %@ page import=oracle.jdbc.pool.OracleConnectionPoolDataSource % html head titleDatabase access test: index page/title /head body % Context ctx=new