<DIV>Hi,</DIV>
<DIV>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</DIV>
<DIV>but when I tried to install it(with opencms wizard), In importing workpalce, some critical errors happened.</DIV>
<DIV>would you please help me what's wrong with me?</DIV>
<DIV>I use:<BR>opencms 5.0.1,<BR>oracle AS 10g,<BR>OC4j 9.0.4,<BR>oracle 10g DB.</DIV>
<DIV> </DIV>
<DIV>Regards,<BR>Farnaz.</DIV>
<DIV><BR>Importing workpalce steps:</DIV>
<DIV>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><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">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><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></BLOCKQUOTE><p>
<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.