AW: [opencms-dev] Newsmodule for Oracle

[Schmidt, Kai]

Hi Joerg,

we tried once to install it, but even with the newsmodule sql we had
problems because of the "timestamp"-type in the script and module classes
(as far as I remember). We would have had to look deeper into it, but
there´s a lot of other things to do...

Thanks for your proposition and tell me if you suceed in installing the news
module.
Regards, Kai


> -----Ursprüngliche Nachricht-----
> Von: Oppermann, Joerg [mailto:Joerg.Oppermann at t-systems.com]
> Gesendet: Dienstag, 14. Januar 2003 13:00
> An: opencms-dev at www.opencms.org
> Betreff: AW: [opencms-dev] Installation of opencms for Oracle
> 
> 
> Hi Kai,
> 
> to your question regarding newsmodul and Oracle. Try to set 
> the property 'poolname' for the news module in the module 
> administration from the mysql poolname to 
> jdbc:opencmspool:oracleOci and execue the newsmodule sql 
> script in Oracle.
> I have not tried it but could work.
> 
> Best regards, Joerg
> 
> -----Ursprüngliche Nachricht-----
> Von: Schmidt, Kai [mailto:Kai.Schmidt at bonprix.net]
> Gesendet: Dienstag, 14. Januar 2003 12:31
> An: 'opencms-dev at www.opencms.org'
> Betreff: AW: [opencms-dev] Installation of opencms for Oracle
> 
> 
> Hi Deepak,
> 
> we used the classes12.jar driver to connect to oracle and 
> placed it in the
> /lib -directory of Tomcat (4.0.4).
> Then we selected GENERICSQL in the setup wizard and entered a
> connectionstring like
> jdbc:oracle:thin:@your_oracle_db:1521:your_SID
> 
> That works quite fine here (but of course not with some 
> modules like the
> news module which is written for mysql)
> 
> By the way, is there someone out there with a news module for 
> Oracle???
> 
> Best regards,
> Kai
> 
> > -----Ursprüngliche Nachricht-----
> > Von: deepaksawdekar [mailto:deepaksawdekar at infosys.com]
> > Gesendet: Dienstag, 14. Januar 2003 11:56
> > An: opencms-dev at opencms.com
> > Betreff: [opencms-dev] Installation of opencms for Oracle.
> > 
> > 
> > Hi ,
> > 	I am trying to install OpenCms 4.6.1 using oracle 
> > 8.1.7.0 as a database. Does anybody has the document for the 
> > same since I could not found it on the site www.opencms.org .
> > 
> > 
> > I got this error when I tried to install opencms for oracle.
> > 
> > "Could no connect to database via: jdbc:oracle:oci8:@localhost
> > java.sql.SQLException: ORA-12514: TNS:listener could not 
> > resolve SERVICE_NAME given in connect descriptor"
> > 
> > 
> > 
> > Please help
> > 
> > Thanks and Regards
> > Deepak 
> > 
>