[opencms-dev] Opencms rc1 install error on oracle 8.1.6

[Michael Moossen]

Hi,

for oracle 8 you will need to do some modifications by yourself:

edit the org/opencms/db/oracle/queries.properties file, you can find this file
inside the opencms.jar archive in the WEB-INF/lib folder of your installation.

replace all "FOR UPDATE WAIT 10" by "FOR UPDATE"

please also note, that you may need to use the ojdbc14.jar driver (which comes
with oracle9 and higher)

-- 
Regards
Michael Moossen


Quoting Kosol Tuanveeradej <kosol.t at g-able.com>:

> Dear all
> I install OCMS rc1 with oracle 8.1.6
> I'm got errors when importing workplace and module. Do you have any 
> suggestion to solve this problem.
> 
> Thanks you
> Kosol Tuanveeradej
> ----------------------------------------------
> 
> 57:   
> 56:    Shutdown completed, total uptime was 00:01:05.
> 55:    Shutting down OpenCms, version 6.0 RC 1 Corrin in web application 
> "opencms"
> 54:   
> 53:   
> 52:        at 
>
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:175)
> 51:        at 
>
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:108)
> 50:        at org.opencms.main.CmsShell.exit(CmsShell.java:545)
> 49:    java.lang.NullPointerException
> 48:        at 
>
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:167)
> 47:        at org.opencms.main.CmsShell.start(CmsShell.java:579)
> 46:        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:689)
> 45:        at org.opencms.main.CmsShell.printPrompt(CmsShell.java:563)
> 44:    java.lang.NullPointerException
> 43:        ... 11 more
> 42:        at 
>
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:269)
> 41:        at 
>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> 40:        at 
>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> 39:        at 
>
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
> 38:        at 
>
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
> 37:        at 
>
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
> 36:        at 
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
> 35:        at 
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
> 34:        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
> 33:        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
> 32:        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> 31:        at 
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> 30:   
> 29:    Caused by: java.sql.SQLException: ORA-00933: SQL command not 
> properly ended
> 28:        ... 8 more
> 27:        at 
> org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:620)
> 26:        at 
> org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:1594)
> 25:        at 
> org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:166)
> 24:        at 
>
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:298)
> 23:    Caused by: org.opencms.db.CmsDbSqlException: SQL error when 
> executing the following query: 
> oracle.jdbc.driver.OraclePreparedStatement at 11f56a3
> 22:        ... 7 more
> 21:        at 
> org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4075)
> 20:        at 
> org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:626)
> 19:    Caused by: org.opencms.main.CmsInitException: Critical error 
> during OpenCms initialization: Unable to initialize the user driver
> 18:        at 
>
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:143)
> 17:        at org.opencms.main.CmsShell.<init>(CmsShell.java:448)
> 16:        at 
> org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1426)
> 15:        at 
> org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:918)
> 14:        at 
> org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:162)
> 13:        at 
> org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2564)
> 12:        at 
> org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:446)
> 11:        at 
> org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4085)
> 10:    org.opencms.main.CmsInitException: Critical error while 
> initializing driver org.opencms.db.oracle.CmsUserDriver
> 9:    --------------------
> 8:    Giving up, unable to start OpenCms.
> 7:    Critical error during OpenCms initialization: Unable to initialize 
> the user driver
> 6:    The following critical error occured:
> 5:    --------------------
> 4:   
> 3:   
> 2:    OpenCms property file: 
> D:\Tomcat5\webapps\opencms\WEB-INF\config\opencms.properties
> 1:    OpenCms WEB-INF path:  D:\Tomcat5\webapps\opencms\WEB-INF\
> 
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> 


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.