nope, that didnt work either :( Anybody else out there use SQL Server and connects to it via Microsoft's SQL Server JDBC driver? there must be somebody....
Thanks Claire ----- Original Message ----- From: "Mark Lowe" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, February 27, 2004 12:14 PM Subject: Re: microsoft sqlserver driver & struts > Ah okay.. If you've had the same stuff running with another database > i'm tree-barking. No I've never used and hope never to use M$ sql > server. Postgres, mysql and oracle so I'm signing off this thread. > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
