AW: [opencms-dev] OpenCMS and SQL server 2000 problem

Mark Miller mark.miller at hema.ch
Fri Jul 18 16:57:29 CEST 2003 

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

More information about the opencms-dev mailing list