Hi,
>From one week i am trying to solve this problem.
Please any one help me.
if i am connection directly its ok. but if i am using
connection pooling this exception is comming.
my connection pooling syntax in server.xml is
--------------------------------------------------------------------------------------------------------------------------
<Resource name="jdbc/edmsCP" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/edmsCP">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://vijay2k:1433;databasename=eDMS</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
---------------------------------------------------------------------------------------------
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>
<resource-ref>
<res-ref-name>jdbc/edmsCP</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
-----------------------------------------------------------------------------------------------
Here is my code..
-----------
public Connection getConnection()
{
Connection conn = null;
try
{
Context initCtx = new InitialContext();
Context envCtx = (Context)
initCtx.lookup("java:comp/env");
if(envCtx == null )
throw new Exception("No Context");
else
System.out.println("Context Ok -> " + envCtx);
DataSource ds = (DataSource)
envCtx.lookup("jdbc/edmsCP");
System.out.println("DataSource ->" + ds);
if (ds != null)
conn = ds.getConnection();
}
catch(Exception ex)
{
System.out.println(ex.getMessage());
//ex.printStackTrace();
}finally
{
return conn;
}
}
-----------------------
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
