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

[Dariush]

Hi Juan David,

I had the same problem with OpenCms 5.0.1, Oc4j10g and Oracle 9i.
After a little analisys I decided to use a standard datasource, managed 
directly by oc4j.

I posted on this list an implementation to use standard Datasources instead 
of opencms connpool.

Now I have no more problems and connections are closed and managed without 
problems.

Search on list for 'datasource implementation' and take a look at attached 
code.

Let me know if you need help.

Dariush.

---------- Original Message -----------
From: Felipe.Ramos at steria.es
To: Juan David Ayllón Burguillo <jdayllon at gmail.com>, The OpenCms mailing 
list <opencms-dev at opencms.org>
Sent: Wed, 20 Oct 2004 17:15:15 +0200
Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

> Hello Juan David:
>
> It's very difficult to give an answer with only that information.
>
> It could be a firewall between the DB and the Application, or it could be 
the pool of connections ( don't use the hibernate pool on your server! ) or 
maybe another one application running on the server, or the driver used ( 
you must use ojdbc14.jar ) .... or what ever.... With more information we 
could give you and answer.
>
> We have developed ( for example ) the new web and intranet of 
the "Parlamento de Andalucía"  in Sevilla, Spain  with OpenCMS 5.0.1and J2EE 
in an environment very similar to yours, and everything goes very well, and 
the client is really very happy with the platform and with our solution. The 
web is finished but it's not yet in internet because of politicians themes, 
you know...  So your platform is not the guilty.
> 
>
> PD:  You must give a solution to the bug with "closing connections", 
because it's very important in a production environment.
>
> Please, feel free to call me.
>
> ------------------------------------------------
> Felipe Ramos
> Steria España
> Paseo de las Doce Estrellas, 2
> Campo de las Naciones
> 28042 Madrid, Spain
> Tel.: 913 939 832
> -------------------------------------------------
> 
>
>

 Juan David Ayllón Burguillo <jdayllon at gmail.com>
> Sent by: opencms-dev-bounces at opencms.org
> 20/10/2004 16:42
> Please respond to Juan David Ayllón Burguillo; Please respond to The 
OpenCms mailing list
>          
>         To:        Lista Opencms <opencms-dev at opencms.org>
>         cc:         
>         Subject:        [opencms-dev] Urgent Opencms hangs Oracle 9IAS 
9.0.3

>
> Hi!
>
> I have a tremendous problem with a portal developed in Opencms 5.0.1,
> it hangs several times a day and log files from Opencms and Oc4j /
> Oracle 9IAS doesn't have information about whats happening, or i don't
> see it.
>
> I have been informed of a bug closing connections with oracle DB, i
> see that connections opened in Oracle DB is not the problem ( about 5
> - 10 connections ).
>
> Actual configuration of the system:
> Linux RedHat Advanced Server 2.1
> Oracle 9IAS 9.0.3.0.0
> Oracle DB Server 9.2.0.3
> JDK 1.4.2_03-b02
>
> on 2x Xeon 2.8Ghz 4GB Ram
>
> Thanks, and sorry for my english
>
> --
> Juan David Ayllón Burguillo
> Consejeria de Cultura Junta de Andalucia
>
> _______________________________________________
> 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 -------