AW: [opencms-dev] OpenCMS and SQL server 2000 problem
Anil K Patel
anil at aditisoft.com
Fri Jul 18 17:05:01 CEST 2003
Eoin
I am using MSSql Server in production for a application. The
modification made to the file that I send you fixed the problems we had
.
Regards
Anil K Patel
--- Mark Miller <mark.miller at hema.ch> wrote:
>
> I did manage to get it working ... but I found it extremely slow ...
> I
> think that MS didn’t really bother with trying to add any
> optimisations
> to their jdbc driver.
>
> I did have a problem though after I removed the project_id from the
> where clause (as stated somewhere in the archives), I got an icon for
> every project, ie. 3 of each admin icon ... maybe I did something
> wrong,
> but I couldn't be bothered to look further into it due to the
> performance.
>
> Yesterday I moved back to my SQL, and the whole thing seems to run
> much
> faster ... really strange.
>
> And usually I am a complete fan of MS SQL ... oh well,
>
>
> mark
>
> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-admin at opencms.org
> [mailto:opencms-dev-admin at opencms.org] Im Auftrag von Eoin McCarthy
> Gesendet: 18 July 2003 15:22
> An: 'opencms-dev at opencms.org'
> Betreff: RE: [opencms-dev] OpenCMS and SQL server 2000 problem
>
>
> Hello,
>
> Does OpenCMS 5.0 work with SQL server 2000 ? I've tried the
> configuration
> procedures in the archives (see below) and
> the adjustment provided by Anil Patel. I still don't have a working
> configuration.
>
> Does anybody have a working OpenCMS and SQL server 2000 combination ?
>
> Thanks,
> Eoin
>
>
> -----Original Message-----
> From: Eoin McCarthy
> Sent: 14 July 2003 12:20
> To: 'opencms-dev at opencms.org'
> Subject: RE: [opencms-dev] OpenCMS and SQL server 2000 problem
>
>
>
> Hi,
>
> I updated the opencms.jar file with this query file - replacing the
> com/opencms/file/mssql/query.properties file
> with the one you provided (file dated 13/06/2003). I still get the
> same
> error.
>
> An earlier posting reports also reports this error.
> http://mail.opencms.org/pipermail/opencms-dev/2003q1/003469.html. I
> don't
> know if
> that was resolved.
>
> Thanks,
> Eoin
>
>
>
>
>
> -----Original Message-----
> From: Anil K Patel [mailto:anil at aditisoft.com]
> Sent: 11 July 2003 18:19
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] OpenCMS and SQL server 2000 problem
>
>
> HI,
> The Query file seems to have problem. I have attached Query file that
> you can try.
> IF this does not work let me know the error, I will try provide the
> fix.
> Regards
> Anil
>
> --- Eoin McCarthy <emccarthy at sermatech.com> wrote:
> >
> > Hi,
> >
> > I've been trying to get OpenCMS connected to MS SQL server 2000.
> >
> > I've followed the procedures outline in the posts:
> >
> > http://mail.opencms.org/pipermail/opencms-dev/2003q2/004446.html
> > (this
> > specifies mssql driver as
> > 3Dcom.microsoft.jdbc.sqlserver.SQLServerDriver)
> >
> > and
> >
> > http://mail.opencms.org/pipermail/opencms-dev/2003q2/004448.html
> > (specifies
> > driver as com.microsoft.jdbc.sqlserver.SQLServerDriver). This
> > corresponds to
> > the path name displayed when the jar file is opened with WinZip.
> >
> > However, when running the setup wizard, I keep getting the
> > errors................
> >
> >
> > Creating database.. Failed
> > Error while loading driver:
> > [com.microsoft.jdbc.sqlserver.SQLServerDriver,
> > com.microsoft.jdbc.sqlserver.SQLServerDriver]
> > java.lang.ClassNotFoundException:
> > [com/microsoft/jdbc/sqlserver/SQLServerDriver,
> > com/microsoft/jdbc/sqlserver/SQLServerDriver]
> > -------------------------------------------
> > java.lang.NullPointerException
> > -------------------------------------------
> > java.lang.NullPointerException... etc
> >
> >
> > Creating tables... Failed
> > Error while loading driver:
> > [com.microsoft.jdbc.sqlserver.SQLServerDriver,
> > com.microsoft.jdbc.sqlserver.SQLServerDriver]
> > java.lang.ClassNotFoundException:
> > [com/microsoft/jdbc/sqlserver/SQLServerDriver,
> > com/microsoft/jdbc/sqlserver/SQLServerDriver]
> > -------------------------------------------
> > java.lang.NullPointerException
> > -------------------------------------------
> > java.lang.NullPointerException... etc
> >
> >
> > I've tried a couple of different ways to get OpenCMS to find the
> > driver
> > 1. Placed the mssql driver jar files in JAVA_HOME/jre/lib/ext/
> > directory.
> > 2. Altered the environment variable CLASSPATH to include the paths
> to
> > the
> > mssql jar files.
> >
> > Neither worked.
> >
> > I also tried using the JTurbo driver with the settings
> > pool.mssql.driver=com.newatlanta.jturbo.driver.Driver
> > pool.mssql.url=jdbc:JTurbo://sqlserverhost:1433
> >
> > Again, I get the same kind of error.
> >
> > I then set up a connection to a mySQL database - that worked fine.
> > And finally, just to reassure myself I moved the mySQL driver out
> of
> > the
> > openCMS/web-inf/lib directory and tried to set
> > up a connection to mySQL. I got the ClassNotFoundException error
> > reported
> > but the output was slightly different. Only a single instance of
> the
> > driver
> > name instead of 3.
> >
> > Error while loading driver: org.gjt.mm.mysql.Driver
> > java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
> >
> > -------------------------------------------
> > java.lang.NullPointerException
> >
> > -------------------------------------------
> > Error while loading driver: org.gjt.mm.mysql.Driver
> > java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
> >
> > -------------------------------------------
> > etc.
> >
> > Bit of a lengthy post but I'm stuck as to why OpenCMS cannot find
> the
> > sql
> > server 2000 drivers.
> >
> > Thanks,
> > Eoin
> >
> > Eoin McCarthy
> > Software Engineer
> > Sermatech Intelligent Applications
> > 1 Michaelson Square
> > Livingston
> > EH54 7DP
> >
> > Telephone: +44 (0)1506 472287
> > Fax: +44 1506 472282
> > e-mail: emccarthy at sermatech.com
> >
> >
> >
> > This document is intended only for the use of the individual or
> > entity
> > specified by Sermatech Intelligent Applications, and may contain
> > information
> > that is privileged, confidential and exempt from disclosure under
> > applicable
> > law. If the reader of this document is not the intended recipient,
> or
> > the
> > employee or agent responsible for delivering the document to the
> > intended
> > recipient, you are hereby notified that any dissemination,
> > distribution or
> > copying of this document is strictly prohibited. If you have
> received
> > this
> > document in error, please delete it from your system, do not use or
> > disclose
> > the information in any way and notify the sender immediately. The
> > contents
> > of this message may contain personal views, not the views of
> > Sermatech
> > Intelligent Applications, unless specifically stated.
> >
> >
> >
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list,
> please
> > visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
>
> =====
> Regards
> Aditisoft LLC
> www.aditisoft.com
> We provide OpenCMS implementation services
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
=====
Regards
Aditisoft LLC
www.aditisoft.com
We provide OpenCMS implementation services
More information about the opencms-dev
mailing list