[opencms-dev] Installation problems with Oracle.

[SebWazzup]

Hi Thomas,

Thanks for you quick answer. Actually I think that the installation
problem was due to a clash between tomcat and java. I've read somewhere
in this mailing list that tomcat 4.0.1 and java 1.4.0x are known to
interact badly. The solution was to upgrade my tomcat server. I just
hope my already deployed webapps will keep on running, thats why I first
wanted to keep my working tomcat installation.

I already use a classes12.jar file in my WEB_INF/lib folder, which comes
from a 9i version of oracle. It seems strange to make it work with an
8.1.5 version , but it does (and provides a jdbc 2.0 driver by the way).
Your file may be the same I guess.

I finally manage to partially install OpenCMS, after having upgraded
both java and Tomcat. I now must face another problem, exclusively due
to Oracle and will post a new topic about that. Thanks anyway for the
classes12.jar file, I think other people would kill for that :)
Regards,

Sébastien.

Le Mon, 23 Jun 2003 20:29:09 +0200, Thomas Gick <thomasgick at web.de> a
ecrit ceci :

> As i know you have to use a special classes12.zip or classes12.jar
> jdbc driver which isn´t downloadable from oracle technet anymore.
> If have tested all current jdbc drivers (for jdk1.2, jdk1.3 and
> jkd1.4) which causes different errors.
> 
> If you want i can send the classes12.zip which works in my envirnoment
> with no errors to your private mail account (needs about 1 MB )
> tomorrow. you just need to put it into your
> /$TOMCAT_HOME/webapps/opencms/WEB-INF/lib folder.
> 
> Thomas
> 
> 
> 
> 
> Hello SebWazzup,
> 
> Monday, June 23, 2003, 12:42:13 PM, you wrote:
> 
> S> Hello,
> 
> S> I too encounter the same troubles with the "unique constraint
> S> violated" thing. I couldnt afford to run opencms as the error
> S> appears at the first attempt but the setup seems to be have
> S> completed. I had to repeat the workplace importation step several
> S> times before it completes, maybe this made several primary keys
> S> overlap.
> 
> S> [23.06.2003 11:43:26] <opencms_init> . Database fill default: yes
> S> [23.06.2003 11:43:26] <opencms_init> [CmsDbAccess] fillDefaults()
> S> starting NOW!
> S> [23.06.2003 11:43:26] <opencms_critical> [CmsRbManager] Critical
> S> error while loading resourcebroker
> S> [23.06.2003 11:43:26] <opencms_critical> . Critical init error/3:
> S> com.opencms.core.CmsException: Critical error while loading
> S> resourcebroker
> S> [23.06.2003 11:43:26] <opencms_critical> OpenCms initialization
> S> error!
> 
> S> Could not connect to the database. Is the database up and running?
> 
> S> The database is up and is running.
> 
> S> My system is :
> 
> S> Solaris 7 sparc
> S> Oracle 8.1.5 / oracleOci
> S> java 1.4.0_01-b03
> S> tomcat 4.0.1 standalone
> S> opencms 5.0.0 Kaitain
> 
> S> I would really appreciate any tip about this error.
> 
> S> Thanks in advance,
> 
> S> Seb.
> 
> 
> 
> S> Le Sat May 31 15:53:01 2003, opencms-dev at opencms.org (srini vas)
> S> a ecrit ceci :
> 
> >> Hi:
> >>  
> >> I am using tomcat and trying to connect to oracle. I could able to
> >> create database & tables using OpenCms Wizard and when I am trying
> >to> create Workplace then unique constraint problem is coming. root
> >cause> was java.sql.SQLException: ORA-00001: unique constraint
> >> (OPENCMS.SYS_C001570) violated
> >> 
> >> I couldnot able to complete the setup for this reason....
> >>  
> >> Any help would be highly appreciated...
> S> _______________________________________________
> S> This mail is send to you from the opencms-dev mailing list
> S> To change your list options, or to unsubscribe from the list,
> S> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> 
> -- 
> Best regards,
>  Thomas                            mailto:thomasgick at web.de
> 
> _______________________________________________
> 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


-- 
       `·._.·'¯`·.
   Sébastien Reboux - BioInformaticien
   URGI Génoplante-Info 01 60 87 37 62
                      `·._.·'¯`·.