<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"><font size="2">Hi
Farnaz,
<br />my DatasourceImpl is intended to be used in prod env, in wizard you should
set
useDataSource=false.
<br />When the installation is finished, turn on
useDatasource.
<br />
<br />P.S. You should have 3 datasources, not 4: oracleOci, oracleOcionline and oracleOcibackup.
<br />Remember also that you have to start oc4j with -userThreads option in order to make context sharable on user threads.
<br />
<br />Regards,
Dariush.
<br />
<br />
<br />
<br /><b>---------- Original Message
-----------</b>
<br />
Wrom:
RTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXIMQZUIVO
<br />
To: The OpenCms mailing list <opencms-dev@opencms.org>
<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
it
and I faced with lots of problems. Then I tried to use datasource implementation
founded in archive mailinglist and did instructions for 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 I tried to install it(with opencms wizard), In importing
workpalce, some critical errors
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 />> Importing workpalce
steps:
<br />> 137: at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
<br />>
136:
at
com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
<br />>
135:
at
com.opencms.boot.CmsMain.begin(CmsMain.java:164)
<br />> 134: at
java.lang.reflect.Method.invoke(Method.java:324)
<br />> 133: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
<br />>
132: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
<br />>
131: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
<br />> 130: at
com.opencms.core.CmsShell.commands(CmsShell.java:168)
<br />> 129: at
com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
<br />>
128: java.lang.NullPointerException
<br />>
127:
<br />>
126:
>>> at
com.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: >>>
at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
<br />>
120:
>>> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
<br />>
119: >>> at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
<br />>
118: >>> at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
<br />>
117: >>> at
com.opencms.core.CmsShell.<init>(CmsShell.java:105)
<br />>
116:
>>> at
com.opencms.core.OpenCms.<init>(OpenCms.java:255)
<br />>
115:
>>>
at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
<br />>
114:
>>> at
com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
<br />>
113: >>> at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
<br />>
112: >>> at
com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
<br />>
111: >>> at
com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:77)
<br />>
110: >>> at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:305)
<br />>
109: >>> at
com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2785)
<br />>
108: >>> at
com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1551)
<br />>
107: >>> at
com.evermind.sql.OrclCMTConnection.prepareStatement(OrclCMTConnection.java:1014)
<br />>
106: >>>
at
com.evermind.sql.FilterConnection.prepareStatement(FilterConnection.java:228)
<br />>
105: >>> at
com.evermind.sql.OrionCMTConnection.intercept(OrionCMTConnection.java:138)
<br />>
104: >>> at
com.evermind.sql.OrionCMTConnection.setConnection(OrionCMTConnection.java:188)
<br />>
103: >>> at
com.evermind.sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:341)
<br />>
102: >>> at
com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
<br />>
101: >>> at
com.evermind.sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:561)
<br />>
100: >>> at
com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
<br />>
99: >>> at
com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:181)
<br />>
98: >>>
at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
<br />>
97:
>>> at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
<br />>
96: >>> at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:377)
<br />>
95: >>> at
oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:198)
<br />>
94:
>>> at
oracle.jdbc.dbaccess.DBError.check_error(DBError.java:985)
<br />>
93:
>>> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:231)
<br />>
92:
>>> at
oracle.jdbc.dbaccess.DBError.throwSqlException(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:
>>
at
com.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: >> at
java.lang.Class.newInstance0(Class.java:308)
<br />> 83: >> at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
<br />>
82:
>> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
<br />>
81: >> at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
<br />>
80: >> at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
<br />>
79: >> at
com.opencms.core.CmsShell.<init>(CmsShell.java:105)
<br />>
78:
>> at
com.opencms.core.OpenCms.<init>(OpenCms.java:255)
<br />>
77: >>
at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
<br />>
76:
>> at
com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
<br />>
75: >> at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
<br />>
74: >> at
com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
<br />>
73: >> at
com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:77)
<br />>
72: >> at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:305)
<br />>
71: >> at
com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2785)
<br />>
70: >> at
com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1566)
<br />>
69: >>root cause was java.sql.SQLException: invalid arguments in
call
<br />> 68: >>com.opencms.core.CmsException: 4 Sql exception.
Detailed
error:
[com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
<br />>
67: >>Root
cause:
<br />>
66: >>-----------
<br />>
65:
> at
com.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: > at
java.lang.Class.newInstance0(Class.java:308)
<br />> 60: > at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
<br />>
59:
> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
<br />>
58: > at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
<br />>
57: > at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
<br />>
56: >
at
com.opencms.core.CmsShell.<init>(CmsShell.java:105)
<br />>
55: >
at
com.opencms.core.OpenCms.<init>(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 exception. Detailed
error: [com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
<br />> 51: >com.opencms.core.CmsException: 33 Resourcebroker-init
error. Detailed error: Critical error while loading resourcebroker.
<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: at
java.lang.Class.newInstance(Class.java:261)
<br />>
44:
at
java.lang.Class.newInstance0(Class.java:308)
<br />> 43: at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
<br />>
42:
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
<br />>
41: at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
<br />>
40: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
<br />> 39: at
com.opencms.core.CmsShell.<init>(CmsShell.java:105)
<br />>
38:
at
com.opencms.core.OpenCms.<init>(OpenCms.java:259)
<br />> 37: root
cause was java.sql.SQLException: invalid arguments in
call
<br />> 36: root
cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
<br />>
35:
root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Critical error while loading
resourcebroker.
<br />> 34: com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Database init failed.
<br />> 33: . Critical init error/3:
com.opencms.core.CmsException: Critical error 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: creating
InitialContext
<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 backup pool :
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: . Using
DatasourceDriver...
<br />> 14: Using
Datasource.
<br />>
13:
useDataSource:true
<br />> 12: Using DriverFactory to choose the correct
driver...
<br />> 11: . Resource broker init : phase 3 ok - creating db
access
module
<br />> 10: . Resource broker init : phase 2 ok -
initializing
database
<br />> 9: . Resource broker init : phase 1 ok -
starting
<br />> 8: . Resource broker class:
com.opencms.file.oraclesql.CmsResourceBroker
<br />> 7: . Resource broker
used :
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-b03 mixed mode Sun
Microsystems Inc.
<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: %%% props:
/home/oracle/OraHomeAS/j2ee/CMS_OC4J/applications/cmsdatasource/cmsdatasource/WEB-INF/config/opencms.properties
<br />>
<br />> <b><i>Dariush <dariush@eximia.it></i></b>
wrote:
<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;">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, managed
<br />> directly by
oc4j.
<br />>
<br />> I posted on this list an implementation to use standard
Datasources instead
<br />> of opencms
connpool.
<br />>
<br />> Now I have no
more problems and connections are closed and managed without
<br />>
problems.
<br />>
<br />> Search on list for 'datasource implementation' and
take a look at attached
<br />>
code.
<br />>
<br />> Let me know if you need
help.
<br />>
<br />>
Dariush.
<br />>
<br />> ---------- Original Message
-----------
<br />> From:
Felipe.Ramos@steria.es
<br />> To: Juan David Ayllón
Burguillo <jdayllon @gmail.com="">, The OpenCms mailing
<br />> list
<opencms-dev @opencms.org="">
<br />> Sent: Wed, 20 Oct 2004 17:15:15
+0200
<br />>
Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS
9.0.3
<br />>
<br />> > Hello Juan
David:
<br />>
>
<br />> > It's
very
difficult to give an answer with only that
information.
<br />>
>
<br />>
> It could be a firewall between the DB and the Application, or it could be
<br />> the pool of connections ( don't use the hibernate pool on your
server!
) or
<br />> maybe another one application running on the server, or the driver
used (
<br />> you must use ojdbc14.jar ) .... or what ever.... With more
information 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 OpenCMS 5.0.1and
J2EE
<br />> in an environment very similar to yours, and everything goes very
well, and
<br />> the client is really very happy with the platform and with
our solution. The
<br />> web is finished but it's not yet in internet because
of politicians themes,
<br />> you know... So your 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 />> > Paseo de 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ón Burguillo
<jdayllon @gmail.com="">
<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 mailing
list
<br />> >
<br />> >
To: Lista Opencms
<opencms-dev @opencms.org="">
<br />> > cc:
<br />> > Subject:
[opencms-dev] Urgent Opencms hangs Oracle 9IAS
<br />>
9.0.3
<br />>
<br />>
>
<br />>
>
Hi!
<br />>
>
<br />> > I have a tremendous problem with a portal
developed in Opencms
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
don't
<br />> > see
it.
<br />>
>
<br />> >
I have been informed of a bug closing connections with oracle DB,
i
<br />> >
see that connections opened in Oracle DB is not the problem ( about
5
<br />>
> - 10 connections
).
<br />>
>
<br />> > Actual configuration of the
system:
<br />> > Linux RedHat Advanced Server
2.1
<br />> > Oracle 9IAS
9.0.3.0.0
<br />> > Oracle DB Server
9.2.0.3
<br />> > JDK
1.4.2_03-b02
<br />>
>
<br />> > on 2x Xeon 2.8Ghz 4GB
Ram
<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, please
visit
<br />> >
http://mail.opencms.org/mailman/listinfo/opencms-dev
<br />> >
<br />>
------- End of Original Message
-------
<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
<br />>
</opencms-dev></jdayllon></opencms-dev></jdayllon></blockquote>
<br />>
<hr size="1" />Do you
Yahoo!?
<br />>
<a href="http://us.rd.yahoo.com/mail_us/taglines/aac/*http://promotions.yahoo.com/new_mail/static/ease.html">Yahoo!
Mail Address AutoComplete</a> - You start. We
finish.
<br /><b>------- End of Original Message
-------</b>
<br />
</font>
<br /><b>------- End of Forwarded Message
-------</b>
<br />
<br />
<br />
<br />
</font>
</BODY>
</HTML>