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

Dariush dariush at eximia.it
Tue Nov 9 11:34:33 CET 2004 

Hi farnaz,

As you probably know, oc4j can be configured behind OHS or as standalone 
(using its internal Http server).

To isolate the problem (and simplify system architecture), I suggest you to 
enable OC4J http server and access opencms directly from this, instead of 
passing from proxy and webcache.
To do that, follow my instructions:
1) in server.xml (oc4j/j2ee/home/config), add the following line:
    <web-site path="./http-web-site.xml"/>
after
    <global-web-app-config path="global-web-application.xml"/>

2) In oc4j/j2ee/home/config dir, create a new file named http-web-site.xml 
(if it does not exists)
as follow:
<?xml version="1.0" standalone="yes"?>
<!DOCTYPE web-site PUBLIC "Oracle9iAS XML Web-
site" "http://xmlns.oracle.com/ias/dtds/web-site-9_04.dtd">
<web-site port="[a_free_port]" display-name="Oracle9iAS Containers for J2EE 
HTTP Web Site">
    <web-app application="default" name="[your_app_name]" root="/
[opencms_path]"/>
    <!-- Access Log, where requests are logged to -->
    <access-log path="../log/http-web-access.log"/>
</web-site>

3) restart oc4j

Now opencms should be accessible directly from OC4J embedded web server.
Now try to navigate opencms and let me know if you see the same problem as 
using the complete architecture.

P.S. If OC4J is not accessible directly, but only from a proxy pass, 
configure your webserver to proxy ALL requests to OC4J directly, and not to 
webcache at all.

If your frontend is apache, your proxy pass config should appear as follow:

ProxyVia On
ProxyPass /[opencms_path] http://[oc4j_address]:[oc4j_port]/[opencms_path]
ProxyPassReverse /[opencms_path] http://[oc4j_address]:[oc4j_port]/
[opencms_path]

Let me know your results,
best regards, Dariush.


____________________________________________
Dariush Behboudi - Chief Technical Officer
Phone: +39 02 36507494  
Fax: +39 02 36507494  
dariush.behboudi at eximia.it
www.eximia.it
EXIMIA s.r.l.
Via Melzi d'Eril, 26
Milano (Italy)

---------- Original Message -----------
From: Farnaz Fotrousi <f_fotrousi at yahoo.com>
To: The OpenCms mailing list <opencms-dev at opencms.org>
Sent: Mon, 8 Nov 2004 07:47:00 -0800 (PST)
Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

> Hi Dariush,
> Thanks a lot for your help.
> I installed a plain  opencms but my problem still exists.
> In the case that it hangs,I can not find any special things in logs.But 
the strange thing that I faced was the different behaviors of opencms when i 
logged in different clients with the same user.Although both clients were in 
same network, but in one, it hangs and other worked well.
> How is it possible to track jsession's behaviors?
> configured System architectre is:
> - frontend webserver as a proxy
> - webcache is enabled but I disabled caching of html,jsp and xml files.
> - The OC4j that I used is associated to OHS.
> - We have installed Oracle Portal too.
> - Infra and portal are in the same machine and DB is in another machine.
> - The OS is Linux SUSE.
> I hope these information can be useful.
> If there is any hints, please help me.
> kind Regards,
> Farnaz
>
> Dariush <dariush at eximia.it> wrote:

Hi Farnaz,
> all problems reported
> - switching between offline and online (this is because you module is 
disabled)
> - username and password
>
> are in my opinion connected to one of the following
> - a data loss or corruption in your JSession during navigation.
> - a misconfiguration in your system architecture.
>
> For the first, I see the same behaviour when I restart OC4J (in this case 
my JSession is killed).
> So, how is your JSession configured in OC4J?
>
> For the second claim,
> may you describe your system architecture?
> - Are you using a frontend webserver as a proxy?
> - Are you using  WebCache?
> - Are you using OC4J standalone or associated to OHS?
>
> Give me as more infos as you can, I'll try to help you.
> Ciao, Dariush.
>
> ---------- Original Message -----------
> Wrom: KBRNVWWCUFPEGAUTFJMVRESKPNKMBIPBARHDMNNSKVFVW
> To: The OpenCms mailing list <opencms-dev at opencms.org>
> Sent: Wed, 3 Nov 2004 10:07:23 -0800 (PST)
> Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
>
> > Dear Dariush,
> >  
> > Thanks a lot for your helps. As your recommendation, I will try to 
install a plain and clean opencms later  because I am a little busy these 
days.I agree with you, It seems it can be a good startup.
> >  
> > I use oracleAs 10g and OC4j 9.0.4 which run on Linux SUSE.The DB is 
Oracle10g too.
> > When I deploy and install new opencms, it works well but after some 
minutes, it starts to hang in a way that I can not see pages in explorer 
view unless reload page. also in administration view, when I try to open  
management tools like 'module management', a dialog window which asks 
username and password for authentication  in server is displayed, then some 
functionality like upload or make a new module gets disabled(although the 
project is offline).
> >
> > I looked at connections in my oc4j instance, when it hangs both used and 
total connections get 15. so I tried to activate datasource, which increased 
total connection but those problems that I mentioned, continued.
> >  
> > Do you think these kinds of problems related to modules which I have 
added to opencms or they are caused by servers?
> >  
> > Best Regards,
> > Farnaz
> >
> > Dariush <dariush at eximia.it> wrote: Hi Farnaz,
> > Sorry if I'm asking every time for the same thing, but I think that a 
good
> > startup should be a plain installation from Wizard executed directly from
> > 10GAS.
> > A 'clean' installation, from a 'clean' environment, not a migration from 
a
> > plain installation from tomcat to 10GAS...
> > I experienced problems switching directly from tomcat to oc4j, so I 
started
> > from a clean installation, then I imported my project and modules from 
the
> > administration tool.
> >
> > - Are you using 10GAS on windows, linux or solaris?
> > Consider that opencms creates filesystem files under the WEB-INF/jsp dir
> > (for flex cache), and also into the export dir.
> >
> > - Are you able to reproduce exactly the error scenario?
> > Please give me an answer about that, I would help you better with this 
info.
> >
> > Dariush.
> >
> > ---------- Original Message -----------
> > From: Farnaz Fotrousi 
> > To: The OpenCms mailing list 
> > Sent: Fri, 29 Oct 2004 22:42:20 -0700 (PDT)
> > Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> >
> > > Dear Dariush,
> > >  
> > > If I understand the meaning of plain installation exactly, I should 
tell
> > you that I installed opencms with Tomcat4.0.6 and Oracle10g DB and it 
worked
> > without any problems. But when I switched to oracleAS 10g which has OC4j
> > 9.0.4.,the problems appeared.
> > > So it seems the problem is related to OracleAs or OC4j but what is the
> > reason, I don't know.
> > > Can you guess any reasons?
> > > Regards,
> > > Farnaz
> > >
> > > Dariush wrote: Hi Farnaz,
> > > if I were you, I would restart from a plain installation, just to find 
out
> > if the problem is connected with your current network /application 
server/db
> > environment or (hope it) with your current opencms installation.
> > > To do that, you should create a new db and opencms instance and
> > investigate on this plain inst.
> > >
> > > Let me know,
> > > Dariush.
> > >
> > > ---------- Original Message -----------
> > > Wrom: VOTQNQEMSFDULHPQQWOYIYZUNNYCGPKYLEJGDGVCJVTLB
> > > To: The OpenCms mailing list 
> > > Sent: Thu, 28 Oct 2004 14:51:30 -0700 (PDT)
> > > Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> > >
> > > > Dear Dariush,
> > > >  
> > > > First of all, sorry comming back to you too late.
> > > > Now I should tell you that Before I wanted to use DataSource, I 
tested
> > ConnPool but I had faced with the same problems which persists after 
using
> > DataSource.So it  seems these behaviors are not just  related to 
DataSource
> > or Connpool.
> > > > Can you help me, which factors can cause these problems?
> > > >  
> > > > Kind Regards,
> > > > Farnaz.
> > > >
> > > > Dariush wrote: Hi Farnaz,
> > > > first of all you should investigate to understand if the access 
denied
> > error
> > > > occurs only using DataSources (but I don't think so) or also using
> > default
> > > > connPool.
> > > >
> > > > If problem persists also using connPool, try to restart from a plain
> > installation.
> > > >
> > > > Consider that from an access privilege point of view to opencms
> > resources,
> > > > datasources and connpool are the same thing.
> > > >
> > > > Let me know if the problem occurs only with DataSources.
> > > >
> > > > Best regards, Dariush.
> > > >
> > > > ---------- Original Message-----------
> > > > Wrom: NNSKVFVWRKJVZCMHVIBGDADRZFSQHYUCDDJBLVLMHAALP
> > > > To: The OpenCms mailing list
> > > > Sent: Tue, 26 Oct 2004 07:33:43 -0700 (PDT)
> > > > Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> > > >
> > > > > DearDariush,
> > > > >
> > > > > Thanks for your help. That was useful for running opencms with
> > > > thosedatasources. But unfortunately my problems haven't solved
> > completely.
> > > > > In some cases opencms works properly but others it hangs : pages
> > > > (inexplorer view ) are not displayed and when I try to reach some 
parts
> > > > inAdministration view, the message which asks me username and 
password
> > > > forconnecting to Application Server, is displayed. In these cases 
logfile
> > > > shows methat access to those resources aredenied.
> > > > > like:
> > > > > [OpenCmsServlet] Access denied.com.opencms.core.CmsException:
> > > >
> > 
[com.opencms.file.oraclesql.CmsResourceBroker]/default/vfs/system/workplace/a
> > dministration/logfileviewer/index.html
> > > > >
> > > > > Do you have any hints which can help me to solve theseproblems?
> > > > >
> > > > > Regards,
> > > > >Farnaz.
> > > > >
> > > > > Dariush wrote:Hi Farnaz,
> > > > > my DatasourceImpl is intended tobe used in prod env, in wizard you
> > should
> > > > set useDataSource=false.
> > > > > Whenthe installation is finished, turn on useDatasource.
> > > > >
> > > > > P.S. Youshould have 3 datasources, not 4: oracleOci, 
oracleOcionline
> > > > andoracleOcibackup.
> > > > > Remember also that you have to start oc4j with-userThreads option 
in
> > order
> > > > to make context sharable on user threads.
> > > > >
> > > > > Regards, Dariush.
> > > > >
> > > > > ---------- Original Message-----------
> > > > > Wrom: RTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXIMQZUIVO
> > > > > To: The OpenCms mailing list
> > > > >Sent: Tue, 26 Oct 2004 02:20:09 -0700 (PDT)
> > > > > Subject: Re: [opencms-dev]Urgent Opencms hangs Oracle 9IAS 9.0.3
> > > > >
> > > > > > Hi,
> > > > > >I would like to install opencms on oracleAs 10g and OC4j. So I 
tried
> > it and
> > > > Ifaced with lots of problems. Then I tried to use datasource
> > > > implementationfoundedin archive mailinglist and did instructions for
> > applying it:
> > > > > > -made opencms.jar again.
> > > > > > - deployed application
> > > > > > -updated opencms.properties: datasource
> > > > > > useDataSource=true
> > > > >> - made four datasources for oracle as your example
> > > > > > but when Itried to install it(with opencms wizard), In importing
> > > > workpalce, some criticalerrors happened.
> > > > > > would you please help me what's wrong with me?
> > > > > > I use:
> > > > > > opencms 5.0.1,
> > > > > > oracle AS 10g,
> > > > > > OC4j 9.0.4,
> > > > > > oracle 10g DB.
> > > > > >
> > > > >> Regards,
> > > > > > Farnaz.
> > > > > >
> > > > > > Importingworkpalce steps:
> > > > > > 137: atcom.opencms.boot.CmsSetupThread.run
(CmsSetupThread.java:83)
> > > > > > 136:at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> > > > > > 135: atcom.opencms.boot.CmsMain.begin(CmsMain.java:164)
> > > > > > 134: atjava.lang.reflect.Method.invoke(Method.java:324)
> > > > > >
> > > > 133:atsun.reflect.DelegatingMethodAccessorImpl.invoke
> > (DelegatingMethodAccessorImpl.java:25)
> > > > > > 132:
> > > > atsun.reflect.NativeMethodAccessorImpl.invoke
> > (NativeMethodAccessorImpl.java:39)
> > > > > > 131: at sun.reflect.NativeMethodAccessorImpl.invoke0
(NativeMethod)
> > > > > > 130: atcom.opencms.core.CmsShell.commands(CmsShell.java:168)
> > > > > > 129: atcom.opencms.core.CmsShellCommands.
(CmsShellCommands.java:78)
> > > > > > 128: java.lang.NullPointerException
> > > > > > 127:
> > > > >> 126: >>> atcom.opencms.boot.CmsSetupThread.run
(CmsSetupThread.java:83)
> > > > > > 125:>>> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> > > > >> 124: >>> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> > > > > > 123: >>> at java.lang.Class.newInstance(Class.java:261)
> > > > > > 122: >>> at java.lang.Class.newInstance0(Class.java:308)
> > > > > > 121: >>> atjava.lang.reflect.Constructor.newInstance
> > (Constructor.java:274)
> > > > > >120:>>>
> > > > atsun.reflect.DelegatingConstructorAccessorImpl.newInstance
> > (DelegatingConstructorAccessorImpl.java:27)
> > > > > > 119: >>>
> > > > atsun.reflect.NativeConstructorAccessorImpl.newInstance
> > (NativeConstructorAccessorImpl.java:39)
> > > > > > 118: >>> atsun.reflect.NativeConstructorAccessorImpl.newInstance0
> > (Native
> > > > Method)
> > > > >> 117: >>> atcom.opencms.core.CmsShell.(CmsShell.java:105)
> > > > > > 116:>>> at com.opencms.core.OpenCms.(OpenCms.java:255)
> > > > >> 115: >>> atcom.opencms.file.CmsRbManager.init
(CmsRbManager.java:88)
> > > > > > 114:>>>
> > > > atcom.opencms.file.oraclesql.CmsResourceBroker.init
> > (CmsResourceBroker.java:67)
> > > > > > 113: >>>
> > > > atcom.opencms.file.genericSql.CmsResourceBroker.init
> > (CmsResourceBroker.java:4182)
> > > > > > 112: >>>
> > > > atcom.opencms.file.oraclesql.CmsResourceBroker.createDbAccess
> > (CmsResourceBroker.java:58)
> > > > > > 111: >>>atcom.opencms.file.oraclesql.CmsDbAccess.
> > (CmsDbAccess.java:77)
> > > > > > 110: >>>
> > > > atcom.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:305)
> > > > > > 109: >>>
> > > > atcom.opencms.file.genericSql.CmsDbAccess.fillDefaults
> > (CmsDbAccess.java:2785)
> > > > > > 108: >>>
> > > > atcom.opencms.file.genericSql.CmsDbAccess.createGroup
> > (CmsDbAccess.java:1551)
> > > > > > 107: >>>
> > > > atcom.evermind.sql.OrclCMTConnection.prepareStatement
> > (OrclCMTConnection.java:1014)
> > > > > > 106: >>>
> > > > atcom.evermind.sql.FilterConnection.prepareStatement
> > (FilterConnection.java:228)
> > > > > > 105: >>>
> > > > atcom.evermind.sql.OrionCMTConnection.intercept
> > (OrionCMTConnection.java:138)
> > > > > > 104: >>>
> > > > atcom.evermind.sql.OrionCMTConnection.setConnection
> > (OrionCMTConnection.java:188)
> > > > > > 103: >>>
> > > > atcom.evermind.sql.OrionPooledDataSource.getConnection
> > (OrionPooledDataSource.java:341)
> > > > > > 102:
> > > > >>>atcom.evermind.sql.PooledConnectionUsage.getPooledConnection
> > (PooledConnectionUsage.java:22)
> > > > > > 101: >>>
> > > > atcom.evermind.sql.OrionPooledDataSource.getPooledConnection
> > (OrionPooledDataSource.java:561)
> > > > > > 100: >>>
> > > >
> > 
atcom.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection
> > (DriverManagerConnectionPoolDataSource.java:36)
> > > > > > 99: >>>
> > > > atcom.evermind.sql.DriverManagerDataSource.getConnection
> > (DriverManagerDataSource.java:181)
> > > > > > 98: >>> atoracle.jdbc.driver.OracleDriver.connect
> > (OracleDriver.java:345)
> > > > > > 97:>>>
> > > > atoracle.jdbc.driver.OracleDriver.getConnectionInstance
> > (OracleDriver.java:515)
> > > > > > 96: >>>
> > > > atoracle.jdbc.driver.OracleConnection.(OracleConnection.java:377)
> > > > > > 95: >>> atoracle.jdbc.ttc7.TTC7Protocol.logon
(TTC7Protocol.java:198)
> > > > > > 94:>>> at oracle.jdbc.dbaccess.DBError.check_error
(DBError.java:985)
> > > > > > 93: >>>atoracle.jdbc.dbaccess.DBError.throwSqlException
> > (DBError.java:231)
> > > > > >92: >>> atoracle.jdbc.dbaccess.DBError.throwSqlException
> > (DBError.java:189)
> > > > > >91: >>>java.sql.SQLException: invalid arguments in call
> > > > > >90: >>>Root cause:
> > > > > > 89: >>>-----------
> > > > >> 88: >> at com.opencms.boot.CmsSetupThread.run
(CmsSetupThread.java:83)
> > > > > > 87: >> atcom.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> > > > > > 86: >>at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> > > > > > 85: >>at java.lang.Class.newInstance(Class.java:261)
> > > > > > 84: >> atjava.lang.Class.newInstance0(Class.java:308)
> > > > > > 83: >> atjava.lang.reflect.Constructor.newInstance
> > (Constructor.java:274)
> > > > > >82: >>
> > > > atsun.reflect.DelegatingConstructorAccessorImpl.newInstance
> > (DelegatingConstructorAccessorImpl.java:27)
> > > > > > 81:
> > > > >>atsun.reflect.NativeConstructorAccessorImpl.newInstance
> > (NativeConstructorAccessorImpl.java:39)
> > > > > > 80: >> atsun.reflect.NativeConstructorAccessorImpl.newInstance0
> > (Native Method)
> > > > >> 79: >> at com.opencms.core.CmsShell.(CmsShell.java:105)
> > > > > > 78: >> atcom.opencms.core.OpenCms.(OpenCms.java:255)
> > > > > > 77:>> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> > > > >> 76: >>
> > > > atcom.opencms.file.oraclesql.CmsResourceBroker.init
> > (CmsResourceBroker.java:67)
> > > > > > 75: >>
> > > > atcom.opencms.file.genericSql.CmsResourceBroker.init
> > (CmsResourceBroker.java:4182)
> > > > > > 74: >>
> > > > atcom.opencms.file.oraclesql.CmsResourceBroker.createDbAccess
> > (CmsResourceBroker.java:58)
> > > > > > 73: >> atcom.opencms.file.oraclesql.CmsDbAccess.
(CmsDbAccess.java:77)
> > > > > > 72: >> atcom.opencms.file.genericSql.CmsDbAccess.
> > (CmsDbAccess.java:305)
> > > > > > 71:
> > > > >>atcom.opencms.file.genericSql.CmsDbAccess.fillDefaults
> > (CmsDbAccess.java:2785)
> > > > > > 70: >>
> > > > atcom.opencms.file.genericSql.CmsDbAccess.createGroup
> > (CmsDbAccess.java:1566)
> > > > > > 69: >>root cause was java.sql.SQLException: invalidarguments in 
call
> > > > > > 68: >>com.opencms.core.CmsException: 4 Sqlexception. Detailed 
error:
> > > > [com.opencms.file.oraclesql.CmsDbAccess] invalidarguments in call.
> > > > > > 67: >>Root cause:
> > > > > > 66:>>-----------
> > > > > > 65: > atcom.opencms.boot.CmsSetupThread.run
(CmsSetupThread.java:83)
> > > > > > 64:> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> > > > > > 63:> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> > > > > > 62: >at java.lang.Class.newInstance(Class.java:261)
> > > > > > 61: > atjava.lang.Class.newInstance0(Class.java:308)
> > > > > > 60: > atjava.lang.reflect.Constructor.newInstance
> > (Constructor.java:274)
> > > > > >59:
> > > > >atsun.reflect.DelegatingConstructorAccessorImpl.newInstance
> > (DelegatingConstructorAccessorImpl.java:27)
> > > > > > 58: >
> > > > atsun.reflect.NativeConstructorAccessorImpl.newInstance
> > (NativeConstructorAccessorImpl.java:39)
> > > > > > 57: > atsun.reflect.NativeConstructorAccessorImpl.newInstance0
> > (Native Method)
> > > > >> 56: > at com.opencms.core.CmsShell.(CmsShell.java:105)
> > > > > > 55: > atcom.opencms.core.OpenCms.(OpenCms.java:255)
> > > > > > 54: >at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
> > > > > > 53:>root cause was java.sql.SQLException: invalid arguments in 
call
> > > > >> 52: >root cause was com.opencms.core.CmsException: 4 Sql
> > exception.Detailed
> > > > error: [com.opencms.file.oraclesql.CmsDbAccess] invalid arguments 
incall.
> > > > > > 51: >com.opencms.core.CmsException: 33Resourcebroker-init error.
> > Detailed
> > > > error: Critical error while loadingresourcebroker.
> > > > > > 50: >Root cause:
> > > > > > 49:>-----------
> > > > > >48:at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> > > > > >47: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> > > > > > 46:at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> > > > > > 45: atjava.lang.Class.newInstance(Class.java:261)
> > > > > > 44: atjava.lang.Class.newInstance0(Class.java:308)
> > > > > > 43: atjava.lang.reflect.Constructor.newInstance
(Constructor.java:274)
> > > > > >42:
> > > > atsun.reflect.DelegatingConstructorAccessorImpl.newInstance
> > (DelegatingConstructorAccessorImpl.java:27)
> > > > > > 41:
> > > > atsun.reflect.NativeConstructorAccessorImpl.newInstance
> > (NativeConstructorAccessorImpl.java:39)
> > > > > > 40: atsun.reflect.NativeConstructorAccessorImpl.newInstance0
(Native
> > Method)
> > > > >> 39: at com.opencms.core.CmsShell.(CmsShell.java:105)
> > > > >> 38: at com.opencms.core.OpenCms.(OpenCms.java:259)
> > > > >> 37: root cause was java.sql.SQLException: invalid arguments in 
call
> > > > > > 36: root cause was com.opencms.core.CmsException:4Sql exception.
> > Detailed
> > > > error: [com.opencms.file.oraclesql.CmsDbAccess] invalidarguments in 
call.
> > > > > > 35: root cause wascom.opencms.core.CmsException: 33 
Resourcebroker-
> > init
> > > > error. Detailed error:Critical error while loading resourcebroker.
> > > > > > 34:com.opencms.core.CmsException: 33 Resourcebroker-init error.
> > Detailed
> > > > error:Database init failed.
> > > > > > 33: . Critical init error/3:com.opencms.core.CmsException: 
Critical
> > error
> > > > while loading resourcebroker
> > > > > > 32: [CmsRbManager] Critical error while loading resourcebroker
> > > > > > 31: . Database access init : ok
> > > > > > 30: [CmsDbAccess]fillDefaults() starting NOW!
> > > > > > 29: . Database fill default: yes
> > > > > > 28: Looking upjdbc/oracleOci
> > > > > > 27: creatingInitialContext
> > > > > > 26: jndiPoolName:jdbc/oracleOci
> > > > > > 25:Creating new pool:oracleOci
> > > > > > 24: . Database access init : ok
> > > > > > 23: . Using digest encoding: MD5 from SUN version 1.42
> > > > >> 22: . Digest file encoding :UTF-8
> > > > > > 21: . Digest configured : MD5
> > > > > > 20: . Database backuppool : jdbc:opencmspool:oracleOcibackup
> > > > > > 19: . Database online pool: jdbc:opencmspool:oracleOcionline
> > > > > > 18: . Database offline pool:jdbc:opencmspool:oracleOci
> > > > > > 17: . Database access init : ok
> > > > > > 16: Enabling pool debug, level:1
> > > > > > 15: . UsingDatasourceDriver...
> > > > > > 14: Using Datasource.
> > > > > > 13:useDataSource:true
> > > > > > 12: Using DriverFactory to choose the correctdriver...
> > > > > > 11: . Resource broker init : phase 3 ok - creating dbaccess 
module
> > > > > > 10: . Resource broker init : phase 2 ok -initializing database
> > > > > > 9: . Resource broker init : phase 1 ok -starting
> > > > > > 8: . Resource broker
> > class:com.opencms.file.oraclesql.CmsResourceBroker
> > > > > > 7: . Resource brokerused : oracleOci
> > > > > > 6: . Operating sytem : Linux 2.4.19-4GB i386
> > > > > > 5: . Java VM in use : Java HotSpot(TM) Server VM 1.4.2_02-
b03mixed
> > mode
> > > > Sun MicrosystemsInc.
> > > > > > 4: . Ethernet address used: f3:94:7c:69:e1:18
> > > > > > 3: .Encoding set to : UTF-8
> > > > > > 2: . System file.encoding : UTF-8
> > > > >> 1: . OpenCms encoding : UTF-8
> > > > > > 0: %%%
> > > >
> > 
props:/home/oracle/OraHomeAS/j2ee/CMS_OC4J/applications/cmsdatasource/cmsdata
> > source/WEB-INF/config/opencms.properties
> > > > > >
> > > > > > Dariush wrote: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 thislist an implementation to use standard 
Datasources
> > instead
> > > > > > ofopencms connpool.
> > > > > >
> > > > > > Now I have no more problems andconnections are closed and managed
> > without
> > > > > > problems.
> > > > > >
> > > > > > Search on list for 'datasource implementation' and take a look
> > atattached
> > > > > > code.
> > > > > >
> > > > > > Let me know if you needhelp.
> > > > > >
> > > > > > Dariush.
> > > > > >
> > > > > >---------- Original Message -----------
> > > > > > From:Felipe.Ramos at steria.es
> > > > > > To: Juan David Ayllón Burguillo , The OpenCms mailing
> > > > > > list
> > > > > > Sent: Wed, 20 Oct200417:15:15 +0200
> > > > > > Subject: Re: [opencms-dev] Urgent Opencms hangsOracle 9IAS 9.0.3
> > > > > >
> > > > > > > Hello Juan David:
> > > > >> >
> > > > > > > It's very difficult to give an answer with onlythat 
information.
> > > > > > >
> > > > > > > It could be a firewallbetween the DB and the Application, or it
> > could be
> > > > > > the pool ofconnections ( 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
> > moreinformation 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 
OpenCMS5.0.1and
> > J2EE
> > > > > > in an environment very similar to yours, andeverything goes very
> > well, and
> > > > > > the client is really very happywith the platform and with our
> > solution. The
> > > > > > web is finished butit'snotyet in internet because of politicians
> > themes,
> > > > > > you know... Soyour 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
> > > > > > > Paseode las Doce Estrellas, 2
> > > > > > > Campo de las Naciones
> > > > > >> 28042 Madrid, Spain
> > > > > > > Tel.: 913 939 832
> > > > > > >-------------------------------------------------
> > > > > > >
> > > > >> >
> > > > > > >
> > > > > >
> > > > > > Juan David AyllónBurguillo
> > > > > > > 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 mailinglist
> > > > > > >
> > > > > > > To: Lista Opencms
> > > > > > > cc:
> > > > > > > Subject: [opencms-dev]Urgent Opencms hangs Oracle 9IAS
> > > > > > 9.0.3
> > > > > >
> > > > > >>
> > > > > > > Hi!
> > > > > > >
> > > > > > > I have atremendous 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 beeninformed of a bug closing connections with oracle 
DB, i
> > > > > > > seethat connections opened in Oracle DB is not the problem ( 
about
> > 5
> > > > > >> - 10 connections ).
> > > > > > >
> > > > > > > Actualconfiguration of the system:
> > > > > > > Linux RedHat Advanced Server 2.1
> > > > > > > Oracle 9IAS 9.0.3.0.0
> > > > > > > Oracle DB Server9.2.0.3
> > > > > > > JDK 1.4.2_03-b02
> > > > > > >
> > > > > >> on 2x Xeon 2.8Ghz 4GBRam
> > > > > > >
> > > > > > > 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 -------
> >
> > === message truncated ===
> >
-----------------------------------------------------------------------
Do you Yahoo!?
> > Check out the new Yahoo! Front Page. www.yahoo.com
> ------- 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
>
-----------------------------------------------------------------------
Do you Yahoo!?
> Check out the new Yahoo! Front Page. www.yahoo.com
------- End of Original Message -------

More information about the opencms-dev mailing list