It gets thrown when the application starts, but then more errors occur as there are several servlets which load upon start-up - the data source is null at this point (NullPointerException's are being thrown) and so the errors are thrown when these classes try to access the database.
----- Original Message ----- From: "Mark Lowe" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, February 27, 2004 11:29 AM Subject: Re: microsoft sqlserver driver & struts > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
