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 <[email protected]> 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: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
