[opencms-dev] Does this work with Oracle or NOT?

[Bryan Cantwell]

I actually undeployed and cleaned off all of opencms from my oracle 9ias. Checked out clean copy, altered the line below and then deployed the war file. 
Now at the import workspace I get this in the log:
94:  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
93:  at org.opencms.main.CmsShell.<init>(CmsShell.java:448)
92: java.lang.NullPointerException
91: 
90: >> at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
89: >> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
88: >> at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
87: >> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
86: >> at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
85: >> at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
84: >> at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)
83: >> at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4531)
82: >> at java.lang.Class.forName(Class.java:141)
81: >> at java.lang.Class.forName0(Native Method)
80: >> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
79: >> at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
78: >> at com.evermind.naming.ContextClassLoader.loadClass(ContextClassLoader.java:138)
77: >> at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
76: >> at com.evermind.naming.ContextClassLoader.findClass(ContextClassLoader.java:486)
75: >>java.lang.ClassNotFoundException: org.opencms.db.oracle.CmsVfsDriver
74: >>Root cause:
73: >>-----------
72: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
71: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
70: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
69: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
68: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
67: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
66: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)
65: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)
64: >Root cause was: java.lang.ClassNotFoundException: org.opencms.db.oracle.CmsVfsDriver
63: >org.opencms.main.CmsException: Critical error while initializing org.opencms.db.oracle.CmsVfsDriver [Code 33 - DriverManager init error]
62: >Root cause:
61: >-----------
60:  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
59:  at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
58:  at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
57:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:964)
56: Root cause was: java.lang.ClassNotFoundException: org.opencms.db.oracle.CmsVfsDriver
55: Root cause was: org.opencms.main.CmsException: Critical error while initializing org.opencms.db.oracle.CmsVfsDriver [Code 33 - DriverManager init error]
54: org.opencms.main.CmsException: Database init failed [Code 33 - DriverManager init error]
53: Critical error during OpenCms initialization
52: 
51: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
50: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
49: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
48: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
47: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
46: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
45: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)
44: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4531)
43: > at java.lang.Class.forName(Class.java:141)
42: > at java.lang.Class.forName0(Native Method)
41: > at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
40: > at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
39: > at com.evermind.naming.ContextClassLoader.loadClass(ContextClassLoader.java:138)
38: > at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
37: > at com.evermind.naming.ContextClassLoader.findClass(ContextClassLoader.java:486)
36: >java.lang.ClassNotFoundException: org.opencms.db.oracle.CmsVfsDriver
35: >Root cause:
34: >-----------
33:  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
32:  at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
31:  at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
30:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
29:  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
28:  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
27:  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)
26:  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)
25: Root cause was: java.lang.ClassNotFoundException: org.opencms.db.oracle.CmsVfsDriver
24: org.opencms.main.CmsException: Critical error while initializing org.opencms.db.oracle.CmsVfsDriver [Code 33 - DriverManager init error]
23: Critical init error/3
22:  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
21:  at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
20:  at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
19:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
18:  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
17:  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
16:  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)
15:  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4531)
14:  at java.lang.Class.forName(Class.java:141)
13:  at java.lang.Class.forName0(Native Method)
12:  at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
11:  at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
10:  at com.evermind.naming.ContextClassLoader.loadClass(ContextClassLoader.java:138)
9:  at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
8:  at com.evermind.naming.ContextClassLoader.findClass(ContextClassLoader.java:486)
7: java.lang.ClassNotFoundException: org.opencms.db.oracle.CmsVfsDriver
6: [CmsDriverManager] Critical error while initializing org.opencms.db.oracle.CmsVfsDriver
5: log4j:WARN Please initialize the log4j system properly.
4: log4j:WARN No appenders could be found for logger (org.apache.commons.digester.Digester.sax).
3: 
2: OpenCms property file: C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\config\opencms.properties
1: OpenCms WEB-INF path:  C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\


-----Original Message-----
From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org]On Behalf Of Tristan Tarrant
Sent: Wednesday, April 06, 2005 11:52 AM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Does this work with Oracle or NOT?


On Wed, 2005-04-06 at 11:14 -0500, Bryan Cantwell wrote:


Has anyone ever actually made OpenCMS work in Oracle? 
I have Oracle 9IAS and 817 db. I have deployed the war file it seems fine. I step thru the setup wizard and all goes fine, even creates the tables fine... But when the workspace import comes it 


We use OpenCMS with Oracle 10g. The problem you are having is related to the XML parser. Oracle provides its own implementation and it is very difficult to change it (and not recommended). What makes it blow up is at line 478 of org.opencms.configuration.CmsConfigurationManager (I'm looking at current CVS).
Change the line from:

m_digester.setValidating(true);

to

m_digester.setValidating(false);

and it should work.

Tristan 

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