Can i see the bits of code in the servlets (non action servlets) at start up that retrieve the datasource? And an example from any actions. Also see the load on start up order as i imagine that the struts servlet needs to load before your servlets to be able to access the datasource.
On 27 Feb 2004, at 12:39, Claire Wall wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
