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

[Dariush]

HiFarnaz,
my DatasourceImpl is intended to be used in prod env, in wizard you shouldsetuseDataSource=false.
When the installation is finished, turn onuseDatasource.

P.S. You should have 3 datasources, not 4: oracleOci, oracleOcionline and oracleOcibackup.
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 <opencms-dev at opencms.org>
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 trieditand I faced with lots of problems. Then I tried to use datasource implementationfounded in archive mailinglist and did instructions for applyingit:
> -made opencms.jaragain.
> - deployedapplication
> - updatedopencms.properties:datasource
>useDataSource=true
> - made fourdatasources for oracle as yourexample
> but when I tried to install it(with opencms wizard), In importingworkpalce, some critical errorshappened.
> would you please help me what's wrong withme?
> Iuse:
> opencms5.0.1,
> oracle AS10g,
> OC4j9.0.4,
> oracle 10gDB.
>
>Regards,
>Farnaz.
>
> Importing workpalcesteps:
> 137: atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
>136:atcom.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.<init>(CmsShellCommands.java:78)
>128: java.lang.NullPointerException
>127:
>126:>>> atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
>125:>>>atcom.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
>124:>>> atcom.opencms.boot.CmsMain.begin(CmsMain.java:155)
>123: >>> atjava.lang.Class.newInstance(Class.java:261)
>122: >>>atjava.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(NativeMethod)
>117: >>> atcom.opencms.core.CmsShell.<init>(CmsShell.java:105)
>116:>>> atcom.opencms.core.OpenCms.<init>(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.<init>(CmsDbAccess.java:77)
>110: >>> atcom.opencms.file.genericSql.CmsDbAccess.<init>(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.<init>(OracleConnection.java:377)
>95: >>> atoracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:198)
>94:>>> atoracle.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 incall
>90:>>>Rootcause:
>89: >>>-----------
>88:>> atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
>87:>>atcom.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
>86: >>atcom.opencms.boot.CmsMain.begin(CmsMain.java:155)
>85: >>atjava.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(NativeMethod)
>79: >> atcom.opencms.core.CmsShell.<init>(CmsShell.java:105)
>78:>> atcom.opencms.core.OpenCms.<init>(OpenCms.java:255)
>77: >>atcom.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.<init>(CmsDbAccess.java:77)
>72: >> atcom.opencms.file.genericSql.CmsDbAccess.<init>(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: invalid arguments incall
> 68: >>com.opencms.core.CmsException: 4 Sql exception.Detailederror:[com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
>67: >>Rootcause:
>66: >>-----------
>65:> atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
>64: > atcom.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
>63: >atcom.opencms.boot.CmsMain.begin(CmsMain.java:155)
>62: >atjava.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(NativeMethod)
>56: >atcom.opencms.core.CmsShell.<init>(CmsShell.java:105)
>55: >atcom.opencms.core.OpenCms.<init>(OpenCms.java:255)
>54: >atcom.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
>53:>root cause was java.sql.SQLException: invalid arguments incall
>52:>root cause was com.opencms.core.CmsException: 4 Sql exception. Detailederror: [com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
> 51: >com.opencms.core.CmsException: 33 Resourcebroker-initerror. Detailed error: Critical error while loading resourcebroker.
>50:>Rootcause:
>49: >-----------
> 48: atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
>47:atcom.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
>46:atcom.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: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)
> 39: atcom.opencms.core.CmsShell.<init>(CmsShell.java:105)
>38:atcom.opencms.core.OpenCms.<init>(OpenCms.java:259)
> 37: rootcause was java.sql.SQLException: invalid arguments incall
> 36: rootcause was com.opencms.core.CmsException: 4 Sql exception. Detailed error:[com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
>35:root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error.Detailed error: Critical error while loadingresourcebroker.
> 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 loadingresourcebroker
> 32: [CmsRbManager] Critical error while loadingresourcebroker
> 31: . Database access init :ok
>30:[CmsDbAccess] fillDefaults() startingNOW!
> 29: . Database filldefault:yes
> 28: Lookingupjdbc/oracleOci
> 27: creatingInitialContext
>26: jndiPoolName:jdbc/oracleOci
>25:Creating newpool:oracleOci
> 24: . Database access init :ok
>23: . Using digest encoding: MD5 from SUN version1.42
> 22: .Digest file encoding :UTF-8
> 21: . Digestconfigured:MD5
> 20: . Database backup pool :jdbc:opencmspool:oracleOcibackup
> 19: . Database online pool :jdbc:opencmspool:oracleOcionline
> 18: . Database offlinepool:jdbc:opencmspool:oracleOci
> 17: . Database access init :ok
>16: Enabling pool debug,level:1
> 15: . UsingDatasourceDriver...
> 14: UsingDatasource.
>13:useDataSource:true
> 12: Using DriverFactory to choose the correctdriver...
> 11: . Resource broker init : phase 3 ok - creating dbaccessmodule
> 10: . Resource broker init : phase 2 ok -initializingdatabase
> 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 inuse: Java HotSpot(TM) Server VM 1.4.2_02-b03 mixed mode SunMicrosystems Inc.
> 4: . Ethernet address used:f3:94:7c:69:e1:18
> 3: . Encoding setto:UTF-8
> 2: . System file.encoding:UTF-8
> 1: . OpenCms encoding :UTF-8
> 0: %%% props:/home/oracle/OraHomeAS/j2ee/CMS_OC4J/applications/cmsdatasource/cmsdatasource/WEB-INF/config/opencms.properties
>
> Dariush <dariush at eximia.it>wrote:Hi JuanDavid,
>
> I had the sameproblem with OpenCms 5.0.1, Oc4j10g and Oracle9i.
> After a littleanalisys I decided to use a standard datasource, managed
> directly byoc4j.
>
> I posted on this list an implementation to use standardDatasources instead
> of opencmsconnpool.
>
> Now I have nomore problems and connections are closed and managed without
>problems.
>
> Search on list for 'datasource implementation' andtake a look at attached
>code.
>
> Let me know if you needhelp.
>
>Dariush.
>
> ---------- Original Message-----------
> From:Felipe.Ramos at steria.es
> To: Juan David AyllónBurguillo , The OpenCms mailing
> list
> Sent: Wed, 20 Oct 2004 17:15:15+0200
>Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS9.0.3
>
> > Hello JuanDavid:
>>
> > It'sverydifficult to give an answer with only thatinformation.
>>
>> 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 yourserver!) or
> maybe another one application running on the server, or the driverused (
> you must use ojdbc14.jar ) .... or what ever.... With moreinformation we
> could give you andanswer.
>>
> > Wehave developed ( for example ) the new web and intranet of
> the"Parlamento de Andalucía" in Sevilla, Spain with OpenCMS 5.0.1andJ2EE
> in an environment very similar to yours, and everything goes verywell, and
> the client is really very happy with the platform and withour solution. The
> web is finished but it's not yet in internet becauseof politicians themes,
> you know... So your platform is not theguilty.
> >
>>
> > PD: You must give asolution to the bug with "closing connections",
> becauseit'svery important in a productionenvironment.
>>
> > Please,feel free to callme.
>>
> >------------------------------------------------
> > FelipeRamos
> > SteriaEspaña
> > Paseo de las Doce Estrellas,2
> > Campo de lasNaciones
> > 28042 Madrid,Spain
>> Tel.: 913 939832
> >-------------------------------------------------
> >
>>
>>
>
> Juan David Ayllón Burguillo
> > Sent by:opencms-dev-bounces at opencms.org
> > 20/10/200416: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 a tremendous problem with a portaldeveloped in Opencms5.0.1,
> > it hangs several times a day and logfiles from Opencms and Oc4j/
> > Oracle 9IAS doesn't have informationabout whats happening, or idon't
> > seeit.
>>
> >I have been informed of a bug closing connections with oracle DB,i
> >see that connections opened in Oracle DB is not the problem ( about5
>> - 10 connections).
>>
> > Actual configuration of thesystem:
> > Linux RedHat Advanced Server2.1
> > Oracle 9IAS9.0.3.0.0
> > Oracle DB Server9.2.0.3
> > JDK1.4.2_03-b02
>>
> > on 2x Xeon 2.8Ghz 4GBRam
>>
> > Thanks, and sorry for myenglish
>>
> >--
> > Juan David AyllónBurguillo
> > Consejeria de CulturaJunta deAndalucia
>>
> >_______________________________________________
> > This mail is sendto you from the opencms-dev mailinglist
> > To change your listoptions,orto unsubscribe from the list, pleasevisit
> >http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
>------- End of Original Message-------
>
>_______________________________________________
> This mail is send to youfrom the opencms-dev mailinglist
> To change your list options, or tounsubscribe from the list, pleasevisit
>http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
-----------------------------------------------------------------------
Do youYahoo!?
>Yahoo!Mail Address AutoComplete - You start. Wefinish.
------- End of Original Message-------

------- End of Forwarded Message-------


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041026/c8dd6449/attachment.htm>