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