[opencms-dev] Oracle 10g Database & oc4j 10.1.3 information

[Georg Raffer]

Hello,

we are currently using OpenCms 6.04 with oracle 10g.

Initially OpenCms was installed on Oracle 9; than export / import to 
10g. No problems.

RDBMS: Oracle, version: Oracle Database 10g Release 10.2.0.1.0 - Production
JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0

OpenCms works fine; we haven't noticed any problems. The system hosts 7 
different domains; Tablespace is currently 4 GB (2,5 GB used).

For further projects we want to use a Oracle 10g DB cluster to scale. 
But we haven't tested that until now.

Furthermore OpenCms also works with Oracle Containers for J2EE 10g 
(10.1.3) Developer Preview and Java 5. You only have to make a few changes:

* use the Apache xml parser instead of oracle xml (that is default)
    
http://www.oracle.com/technology/tech/java/oc4j/904/collateral/OC4J-FAQ-904.html     

    (see: How can I use a 3rd party XML parser such as xerces with OC4J)

* Cms login does not work correctly. This can be fixed:
    in class: org.opencms.main.OpenCmsCore
    change method:

    private CmsObject initCmsObject(HttpServletRequest req, 
HttpServletResponse res) throws IOException, CmsException{
        HttpSession session = req.getSession(false);

    to

        HttpSession session = req.getSession(true);

But for production mode we are currently using Apache Tomcat 5.5
By the way: OpenCms is really great!

ciao, Georg


Arash Kaffamanesh wrote:
> Dan,
>
>   
>>> However, 10g works just fine.
>>>       
>
> Good news and thanks for your very short feedback :-)
>
> Could you please provide more info about how to install opencms on 10g,
> I'm somehow interested to know more about it.
>
> I guess someone can install opencms on 9i, import the DB to 10g and
> change the jdbc url to the new 10g DB, right?
>
> Or do you have installed directly to 10g with 9i driver?
>
> Thanks in advance for possible hints.
>
> Best Regards,
> Arash
>
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Dan Liliedahl
> Sent: Donnerstag, 19. Januar 2006 22:59
> To: 'The OpenCms mailing list'
> Subject: RE: [opencms-dev] Help..!
>
>
> However, 10g works just fine.
>
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Arash Kaffamanesh
> Sent: Thursday, January 19, 2006 4:53 PM
> To: 'The OpenCms mailing list'
> Subject: RE: [opencms-dev] Help..!
>
> Hi,
>
> 10g is not supported yet, 9i is the recommended one, which you have to
> choose.
>
>   
>>> Might they to order me ...
>>>       
>
> What do you mean?
>
> Kind Regards,
> Arash
>
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of
> cgaviria at gpsystems.com.co
> Sent: Donnerstag, 19. Januar 2006 22:20
> To: opencms-dev at opencms.org
> Subject: [opencms-dev] Help..!
>
>
> HI,
>
> please I need help me with these problems.
>
> is it possible to work OPENCMS with ORACLE 10g?
>
> Might they to order me the code to get connected to a generic database
> and ORACLE 9i?.
>
>
> Thank you very much
> Carlos
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>