Hi Jason, I tried as u said. But same exception is getting. I am using tomcat4.1.27, sqlserver 2000. can u send me ur connection pooling code. Thank you.
vijay --- El Toro <[EMAIL PROTECTED]> wrote: > Where are your jdbc for sql server jars? Put all > three under /%TOMCAT_HOME%/common/lib. > > Also, your factoryClassName should be: > > factoryClassName=org.apache.naming.factory.ResourceFactory > > I'm currently using connection pooling with sql > server > and thats the only things i can see that might cause > you problems. Also, make sure you don't have any > duplicate entries for the jdbc for sql server jars > in > your classpath. > > Hope That Helps, > > Jason > > --- vijaya prasad pala <[EMAIL PROTECTED]> > wrote: > > 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] > > > > > __________________________________ > 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] > __________________________________ 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]