Hi, I am trying to use microsoft's jdbc driver with my struts application, but to no avail. Here is my datasource definition:
<data-source key="DB" type="org.apache.commons.dbcp.BasicDataSource"> <set-property property="description" value="My SqlServer pool"/> <set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> <set-property property="url" value="jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=DBNAME"/> <set-property property="username" value="xxx"/> <set-property property="password" value="xxx"/> <set-property property="maxActive" value="20"/> <set-property property="maxCount" value="20"/> <set-property property="minCount" value="2"/> <set-property property="maxWait" value="5000"/> <set-property property="defaultAutoCommit" value="false"/> <set-property property="defaultReadOnly" value="false"/> </data-source> I have the required jars located in the WEB-INF/lib of my application which is running on Tomcat 4.1.29. When i try to connect to the database using this driver from a test class, it connects no problem so i know that the url and driver class name are correct. So the problem must be the type of DataSource which I am to use. Does anybody know which datasource to use with Microsoft's sqlserver driver? I tried using the DataSource that is in the mssqlserver jar but this didnt work either. The error that I get is an Invalid DataSource. Any help would be really appreciated! Thanks Claire
