Hi,
I have a problem in connection pooling. Hope you can
give some solution for this.
I am trying to establish connection pooling in the
environment.
Tomcat 5.0.28
SQL server 2000
windows 2000 Professional
I have jar files in
tomcat home\common\lib ===>
commons-dbcp-1.2.1
commons-collection-3.1
commons-pool-1.2
mssqlserver.jar
also I have web-inf\lib ===>
jstl
standard
My server.xml file is ==>
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false"
xmlNamespaceAware="false">
<Context path="/DBTest" docBase="DBTest"
debug="5" reloadable="true"
crossContext="true">
<Logger
className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log."
suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/TestDB"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDataSource</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://Balaji:1433/pubs?autoReconnect=true</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>testuser</value>
</parameter>
<parameter>
<name>password</name>
<value>radha</value>
</parameter>
</ResourceParams>
</Context>
</Host>
My Web.xml ----->
<web-app xmlns="http://java.sun.com/xml/ns/j2ee";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";
version="2.4">
<description>Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
If I test with the following code
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql";
prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core";
prefix="c" %>
<sql:query var="rs" dataSource="jdbc/TestDB">
select id, foo, bar from testdata
</sql:query>
<html>
<head>
<title>DB Test</title>
</head>
<body>
<h2>Results</h2>
<c:forEach var="row" items="${rs.rows}">
Foo ${row.foo}<br/>
Bar ${row.bar}<br/>
</c:forEach>
</body>
</html>
I get error as
javax.servlet.ServletException: Unable to get
connection, DataSource invalid:
"org.apache.commons.dbcp.SQLNestedException: Cannot
load JDBC driver class
'com.microsoft.jdbc.sqlserver.SQLServerDataSource'"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
I test this with the following code
javax.naming.InitialContext ctx = new
javax.naming.InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)
ctx.lookup("java:/comp/env/TestDB");
java.sql.Connection con=ds.getConnection();
I get error as context not found.
Can you give some suggestion to fix this.
Thanks for your time.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
