commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thomas <ma...@apache.org>
Subject Re: dbcp issue: unable load commons-dbcp.jar and commons-pool.jar in lib/ext
Date Wed, 29 Jul 2009 11:54:52 GMT
bye webster wrote:
> I had follow through the guideline from
> http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html.
> It is not working, it unable locate the <resource> in <context>. The
> datasource.getConnection was return null. My appBase is mainhost and web
> application is webapps directory.

You will probably have more luck asking for help on the Tomcat users list.

Mark

> 
> This is my context in server.xml
> 
>         <Context path="/webapps" docBase="webapps" debug="5"
> reloadable="true" crossContext="true">
>             <Resource name="jdbc/myinformix" auth="Container"
>                   type="javax.sql.DataSource"
> driverClassName="com.informix.jdbc.IfxDriver"
> 
> url="jdbc:informix-sqli://hostname:port/dbname:INFORMIXSERVER=servernum;"
>                   username="uid" password="password" maxActive="20"
> maxIdle="10" maxWait="-1"/>
> 
>         </Context>
> 
> This is my web.xml
> 
>     <resource-ref>
>         <description>DB Connection</description>
>         <res-ref-name>jdbc/myinformix</res-ref-name>
>         <res-type>javax.sql.DataSource</res-type>
>         <res-auth>Container</res-auth>
>     </resource-ref>
> 
> this is how system invoked
> 
>       Context initContext = new InitialContext();
>       Context envContext = (Context) initContext.lookup("java:/comp/env");
>       DataSource ds = (DataSource) envContext.lookup("jdbc/myinformix");
>       Connection conn = ds.getConnection();
> 
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> 
> On Tue, Jul 28, 2009 at 8:45 PM, Mark Shifman <mark.shifman@yale.edu> wrote:
> 
>> You need to follow the tomcat documentation
>> http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
>> and you don't need to download anything.
>>
>>> DBCP uses the Jakarta-Commons Database Connection Pool. It relies on
>>> number of Jakarta-Commons components:
>>>
>>>    * Jakarta-Commons DBCP
>>>    * Jakarta-Commons Collections
>>>    * Jakarta-Commons Pool
>>>
>>> These libraries are located in a single JAR at
>>> |$CATALINA_HOME/common/lib/naming-factory-dbcp.jar|. However, only the
>>> classes needed for connection pooling have been included, and the packages
>>> have been renamed to avoid interfering with applications.
>>>
>>
>> bye webster wrote:
>>
>>> Hello,
>>>
>>> I recently research on how to implement Database Connection Pooling into
>>> Tomcat 5.5 server.
>>> After downloaded dbcp.jar and pool.jar from Jakarta project and I follow
>>> through the guideline provided.
>>> Unfortunately, It is only working when i set jar file path in CLASSPATH
>>> but
>>> it unable load it when it is keep inside jre/lib/ext directory.
>>> I thought all the jar will load in /lib/ext directory for all tomcat user.
>>>
>>> Who's know what's happening? i don't want messy my classpath setting so
>>> who's know how to load it from lib/ext directory?
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
>> For additional commands, e-mail: user-help@commons.apache.org
>>
>>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message