but before i go try this.
jdbc:microsoft:sqlserver://SERVERNAME:1433;SelectMethod=cursor
On 27 Feb 2004, at 12:56, Claire Wall wrote:
Mark,
My problem is that I'm switching JDBC drivers - before I was using
weblogic's JDBC driver for SQL Server and I've been using that for a long
time now and never had any problems. Now I'm trying to ditch the weblogic
driver and in its place use Microsoft's JDBC driver for SQLServer. Sorry,
should've mentioned that before. I'm not sure that showing the code for
getting the datasource is going to help because I'm assuming that this is
not the problem - the problem is surely to do with the type of datasource.
I had a similiarish problem trying to use an Oracle database - in the end
the type of datasource was the problem and not how I retrieved it in my
actions.
Have you used Microsoft's SQL Server 2000 JDBC driver with struts before,
and if so, what type of datasource do we use? Can't find anywhere that says
anything about it. Cant be too difficult..
Thanks Claire
----- Original Message ----- From: "Mark Lowe" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, February 27, 2004 11:43 AM Subject: Re: microsoft sqlserver driver & struts
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]
--------------------------------------------------------------------- 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]
