Re: microsoft sqlserver driver & struts

[Mark Lowe]

Does the error get thrown when you attempt to access the data source or  
at startup?

On 27 Feb 2004, at 11:34, Claire Wall wrote:

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


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]