AW: [opencms-dev] OpenCMS and SQL server 2000 problem
Anil K Patel
anil at aditisoft.com
Sun Jul 20 04:02:01 CEST 2003
Eoin
I did not have any such problem. did you copy two jdbc driver jar
files?
I have tried installating, Same OpenCMS/SQL Server on Linux/Win/Netware
6
All work good.
Regards
Anil
--- Eoin McCarthy <emccarthy at sermatech.com> wrote:
>
> Hi Anil,
>
> You had the same problem at the setup stage ?
>
> Eoin
>
>
> -----Original Message-----
> From: Anil K Patel [mailto:anil at aditisoft.com]
> Sent: 18 July 2003 15:48
> To: opencms-dev at opencms.org
> Subject: Re: AW: [opencms-dev] OpenCMS and SQL server 2000 problem
>
>
> 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
> >
> > -----Ursprungliche 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
> _______________________________________________
> 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