If you're switching JDBC drivers, take a look at JSQLConnect from J-netdirect. We found it performed MUCH better than the driver from Microsoft.
Rick DeBay On Fri, 27 Feb 2004 11:56 , Claire Wall <[EMAIL PROTECTED]> sent: >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: >> >>> >> >>> >> >>> type="org.apache.commons.dbcp.BasicDataSource"> >> >>> >> >>> >> >>> value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> >> >>> >> >>> value="jdbc:microsoft:sqlserver://SERVERNAME:1433; >> >>> DatabaseName=DBNAME"/> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> 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]
