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

[Dariush]

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