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

[Juan David Ayllón Burguillo]

Hi!

  I don't explain very well my problem, my poor english maybe te
problem :-(, i have been talking with my DBA but he says that Oracle
app's didn't give any java error or similar in the moment of hang.

We only see in "ps" that there are about 300% more of "HTTPD" process
and it doesn't respond to any request, we need to stop entire Oracle
9IAS, anything in it responds.

Thanks in advance.


On Thu, 21 Oct 2004 11:30:45 +0100, Dariush <dariush at eximia.it> wrote:
> 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 -----------
> From: "Alexander Kandzior" <alex at opencms.org>
> 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
> 


-- 
Juan David Ayllón Burguillo