[opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

[Dariush]

Good.
Remember to set userThread option in oc4j startup parameters (if using oc4j)
in order to make oracleOcibackup working fine.

Dariush.


---------- Original Message -----------
Wrom: MNNSKVFVWRKJVZCMHVIBGDADRZFSQHYUCDDJBLV
To: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
Sent: Thu, 28 Oct 2004 13:51:26 +0200
Subject: RE: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

> Ok,
> Done.
> It seems to be fully up and running.
> 
> Thank you.
> 
> -----Original Message-----
> Wrom: LMHAALPTCXLYRWTQTIPWIGYOKSTTZRC
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Dariush
> Sent: giovedì 28 ottobre 2004 13.01
> To: The OpenCms mailing list
> Subject: RE: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> 
> Hi Maurizio,
> for connection pooling the used entry is the ejb-location, so the other
> entries are just trivial.
> BTW, if you want you can use different names according to the ejb-location
> names, such us oracleOciXA and oracleOcionlienXA
> 
> Ciao, Dariush.
> 
> ---------- Original Message -----------
> Wrom: CRTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXI
> To: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
> Sent: Thu, 28 Oct 2004 11:44:52 +0200
> Subject: RE: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> 
> > Hi Dariush,
> > I'm trying to use your pool implementation with datasources.
> > 
> > I have noticed that the datasource configuration for oracleOci and
> > oracleOcionline is the same for location and xa-location parameters. 
> > Is this correct?
> > 
> > -----Original Message-----
> > Wrom: MQZUIVOTQNQEMSFDULHPQQWOYIYZUNN
> > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Dariush
> > Sent: giovedì 21 ottobre 2004 12.31
> > To: The OpenCms mailing list
> > Subject: RE: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> > 
> > Hi Alex,
> > my datasource implementation doesn't substitute at all the default 
> > connpool,
> > 
> > but it's an alternative.
> > Simply, you can decide to use it or not (setting 
> > useDataSource=true/false). If you decide to use DataSource, OpenCms  
> > instantiates DataSourceDriver instead of CmsDriver. If you want the 
> > default connPool, you set useDataSource=false.
> > 
> > Moreover, like the default connPool, U need 3 different datasources 
> > and their name is the same of orig connPool (for example oracleOci,
> >  oracleOcionline, oracleOcibackup).
> > 
> > - For the shell, it can be forced to use connPool even if
> useDataSource=true
> > 
> > in opencms.properties
> > 
> > - For setup, simply I think that you should mantain the actual one 
> > and give the opportunity, in production env, to make it possibile to 
> > switch to an external datasource, especially using Oracle, modifying 
> > the opencms.properties directly.
> > 
> > Dariush.
> > 
> > ---------- Original Message -----------
> > Wrom: YCGPKYLEJGDGVCJVTLBXFGGMEPYOQKEDOTWFAOB
> > To: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
> > Sent: Thu, 21 Oct 2004 11:13:36 +0200
> > Subject: RE: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> > 
> > > Especially as all servlet engines nowadays provide Connection Pools,
> > > I find it a bit odd that OpenCMS needs to manage connections on its own.
> > > 	
> > > 	Alex ? Any plans on this ?
> > > 
> > > For 6 we did replace the self-developed pool with the DBCP from 
> > > Apache Jarkarta, which also Tomcat uses for it's own pool (i.e. we 
> > > use the same pool that the Tomcat uses for it's datasources).
> > > 
> > > There are 2 issues to take into consideration before replacing the
> current
> > > implementation:
> > > 
> > > 1) The OpenCms shell runs outside the servlet container. I don't 
> > > want to loose this functionality. How do we run the shell if the DB 
> > > configuration is only available in the servlet container?
> > > 
> > > 2) The setup wizard. Currently the DB configuration is written by 
> > > the setup wizard. AFAIK there's no standard way to write a 
> > > datasource configuration during servlet container runtime. I don't 
> > > want to have the configuration done manually by default, since 
> > > apparently even in the current state the setup is an issue for many 
> > > people. How do we do the setup wizard with datasources?
> > > 
> > > A way to go (for 6.0) could be to have an alternative pool
> implementation
> > > that relys on datasources. This could be configured manually after 
> > > (or before?) the setup wizard runs. The pool itself can already be 
> > > configured in
> > > 6.0, maybe we would require some slight changes.
> > > 
> > > Best Regards,
> > > Alex.
> > > 
> > > Alexander Kandzior
> > > Alkacon Software - The OpenCms Experts
> > > http://www.alkacon.com <http://www.alkacon.com/>
> > > 
> > > _______________________________________________
> > > 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
> > ------- End of Original Message -------
> > 
> > _______________________________________________
> > 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
> ------- End of Original Message -------
> 
> _______________________________________________
> 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
------- End of Original Message -------