<DIV><BR>Hi Dariush,</DIV>
<DIV>Thanks a lot for your help.<BR>I installed a plain opencms but my problem still exists.<BR>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.</DIV>
<DIV>How is it possible to track jsession's behaviors?</DIV>
<DIV>configured System architectre is:<BR>- frontend webserver as a proxy<BR>- webcache is enabled but I disabled caching of html,jsp and xml files.<BR>- The OC4j that I used is associated to OHS.<BR>- We have installed Oracle Portal too.<BR>- Infra and portal are in the same machine and DB is in another machine.<BR>- The OS is Linux SUSE.</DIV>
<DIV>I hope these information can be useful.<BR>If there is any hints, please help me.</DIV>
<DIV>kind Regards,<BR>Farnaz<BR><BR><B><I>Dariush <dariush@eximia.it></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="Open WebMail 2.30 20040103" name=GENERATOR><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 class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">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><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, please visit<BR>http://mail.opencms.org/mailman/listinfo/opencms-dev</BLOCKQUOTE><p>
<hr size=1>Do you Yahoo!?<br>
Check out the new Yahoo! Front Page. <a href="http://www.yahoo.com">www.yahoo.com</a>