struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claire Wall" <claire.w...@kurtosys.com>
Subject Re: microsoft sqlserver driver & struts
Date Fri, 27 Feb 2004 11:56:37 GMT
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" <mark.lowe@talk21.com>
To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
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" <mark.lowe@talk21.com>
> > To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> > 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: struts-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: struts-user-help@jakarta.apache.org
> >>
> >>
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: struts-user-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>



---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


Mime
View raw message