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

[Dariush]

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 -------