help setting up connection pool with sql server

[Ro...@surecomp.com]

Hello all... hope all is well


I am trying to configure a connection pool with Tomcat 7 and Sql Server 2005

I am getting the following error message when Tomcat starts

Feb 1, 2011 10:38:16 AM com.sun.xml.ws.server.MonitorBase createRoot
INFO: Metro monitoring rootname successfully set to: null
Feb 1, 2011 10:38:16 AM com.sun.xml.ws.transport.http.servlet.WSServletDelegate
<init>
INFO: WSSERVLET14: JAX-WS servlet initializing
Configuration loaded from the file: [C:\Downloads\tomcat-7\apache-tomcat-7.0.6\
ebapps\allMATCHWeb\allmatch.properties]
java.lang.UnsupportedOperationException: Not supported by BasicDataSource
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataS
urce.java:1062)
        at com.surecomp.allMATCH.Microsoft.getConnection(Microsoft.java:95)
        at com.surecomp.allMATCH.Microsoft.OpenSqlSingle(Microsoft.java:146)
        at com.surecomp.allMATCH.client.InitServlet.verifyDatabaseVersion(InitS
rvlet.java:574)
        at com.surecomp.allMATCH.client.InitServlet.init(InitServlet.java:178)
        at javax.servlet.GenericServlet.init(GenericServlet.java:160)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper
java:1133)

I search of the internet seems to indicate that using getConnection with username/passwords params is not support, I doubt that to be the cause.

My context.xml is the following

<Resource name="jdbc/system"
          auth="Container"
          type="javax.sql.DataSource"
          driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
          url=" jdbc:sqlserver://allmatch-test:1433;databaseName=system;"
          username="sa"
          password="sa12"
          maxActive="20"
          maxIdle="30"
          maxWait="-1"
/>
<Resource name="jdbc/sureus33xxx"
          auth="Container"
          type="javax.sql.DataSource"
          driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
          url=" jdbc:sqlserver://allmatch-test:1433;databaseName=sureus33xxx;"
          username="sa"
          password="sa12"
          maxActive="20"
          maxIdle="30"
          maxWait="-1"
/>

My web.xml resource information is the following

<RESOURCE-REF>
<RES-REF-NAME>jdbc/system</RES-REF-NAME>
<RES-TYPE>javax.sql.DataSource</RES-TYPE>
<RES-AUTH>Container</RES-AUTH>
</RESOURCE-REF>
<RESOURCE-REF>
<RES-REF-NAME>jdbc/sureus33xxx</RES-REF-NAME>
<RES-TYPE>javax.sql.DataSource</RES-TYPE>
<RES-AUTH>Container</RES-AUTH>
</RESOURCE-REF>

My code connects via the following logic

                              Context ctx = new InitialContext();
                              DataSource ds = (DataSource)ctx.lookup("java:/comp/env/jdbc/" + sDatabase.toLowerCase());
                              conn = ds.getConnection(sUsername, sPassword);


One question I do have is if getConnection works what username/password should I provide... I would be providing a tomcat username/password my tomcat-users.xml is the following

<?xml version='1.0' encoding='utf-8'?>
<tomcat-users>
  <role rolename="manager-gui" />
  <role rolename="manager-script" />
  <role rolename="manager-jmx" />
  <role rolename="manager-status" />
  <role rolename="standard" />
  <role rolename="admin-gui" />
  <role rolename="admin-script" />
  <user username="tomcat" password="tomcat" roles="admin-gui,admin-script,standard,manager-script,manager-gui,manager-jmx,manager-status"/>
</tomcat-users>


Thanks in advance for any insight and assistenance you may be able to provide...

Sincerely,

Robert Jenkin
Surecomp Services, Inc.
2 Hudson Place, 4th Floor
Hoboken, NJ 07030
Skype: robert.jenkin
Office: 201 217 1437 | Direct: 201 716 1219 | Mobile: 908 251 0537
http://www.Surecomp.com


This mail was sent via Mail-SeCure System.