<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<TITLE>Does this work with Oracle or NOT?</TITLE>
<META content="MSHTML 6.00.2800.1491" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=667165520-06042005><FONT face=Arial color=#0000ff size=2>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.
</FONT></SPAN></DIV>
<DIV><SPAN class=667165520-06042005><FONT face=Arial color=#0000ff size=2>Now at
the import workspace I get this in the log:</FONT></SPAN></DIV>
<DIV><SPAN class=667165520-06042005><FONT face=Arial color=#0000ff
size=2>94: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>93: at
org.opencms.main.CmsShell.<init>(CmsShell.java:448)<BR>92: java.lang.NullPointerException<BR>91: <BR>90: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>89: >> at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>88: >> at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>87: >> at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>86: >> at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>85: >> at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>84: >> at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)<BR>83: >> at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4531)<BR>82: >> at
java.lang.Class.forName(Class.java:141)<BR>81: >> at
java.lang.Class.forName0(Native Method)<BR>80: >> at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)<BR>79: >> at
java.lang.ClassLoader.loadClass(ClassLoader.java:235)<BR>78: >> at
com.evermind.naming.ContextClassLoader.loadClass(ContextClassLoader.java:138)<BR>77: >> at
java.lang.ClassLoader.loadClass(ClassLoader.java:289)<BR>76: >> at
com.evermind.naming.ContextClassLoader.findClass(ContextClassLoader.java:486)<BR>75: >>java.lang.ClassNotFoundException:
org.opencms.db.oracle.CmsVfsDriver<BR>74: >>Root
cause:<BR>73: >>-----------<BR>72: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>71: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>70: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>69: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>68: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>67: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>66: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)<BR>65: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)<BR>64: >Root
cause was: java.lang.ClassNotFoundException:
org.opencms.db.oracle.CmsVfsDriver<BR>63: >org.opencms.main.CmsException:
Critical error while initializing org.opencms.db.oracle.CmsVfsDriver [Code 33 -
DriverManager init error]<BR>62: >Root
cause:<BR>61: >-----------<BR>60: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>59: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>58: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>57: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:964)<BR>56: Root
cause was: java.lang.ClassNotFoundException:
org.opencms.db.oracle.CmsVfsDriver<BR>55: Root cause was:
org.opencms.main.CmsException: Critical error while initializing
org.opencms.db.oracle.CmsVfsDriver [Code 33 - DriverManager init
error]<BR>54: org.opencms.main.CmsException: Database init failed [Code 33
- DriverManager init error]<BR>53: Critical error during OpenCms
initialization<BR>52: <BR>51: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>50: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>49: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>48: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>47: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>46: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>45: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)<BR>44: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4531)<BR>43: > at
java.lang.Class.forName(Class.java:141)<BR>42: > at
java.lang.Class.forName0(Native Method)<BR>41: > at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)<BR>40: > at
java.lang.ClassLoader.loadClass(ClassLoader.java:235)<BR>39: > at
com.evermind.naming.ContextClassLoader.loadClass(ContextClassLoader.java:138)<BR>38: > at
java.lang.ClassLoader.loadClass(ClassLoader.java:289)<BR>37: > at
com.evermind.naming.ContextClassLoader.findClass(ContextClassLoader.java:486)<BR>36: >java.lang.ClassNotFoundException:
org.opencms.db.oracle.CmsVfsDriver<BR>35: >Root
cause:<BR>34: >-----------<BR>33: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>32: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>31: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>30: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>29: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>28: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>27: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)<BR>26: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)<BR>25: Root
cause was: java.lang.ClassNotFoundException:
org.opencms.db.oracle.CmsVfsDriver<BR>24: org.opencms.main.CmsException:
Critical error while initializing org.opencms.db.oracle.CmsVfsDriver [Code 33 -
DriverManager init error]<BR>23: Critical init error/3<BR>22: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>21: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>20: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>19: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>18: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>17: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>16: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:425)<BR>15: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4531)<BR>14: at
java.lang.Class.forName(Class.java:141)<BR>13: at
java.lang.Class.forName0(Native Method)<BR>12: at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)<BR>11: at
java.lang.ClassLoader.loadClass(ClassLoader.java:235)<BR>10: at
com.evermind.naming.ContextClassLoader.loadClass(ContextClassLoader.java:138)<BR>9: at
java.lang.ClassLoader.loadClass(ClassLoader.java:289)<BR>8: at
com.evermind.naming.ContextClassLoader.findClass(ContextClassLoader.java:486)<BR>7: java.lang.ClassNotFoundException:
org.opencms.db.oracle.CmsVfsDriver<BR>6: [CmsDriverManager] Critical error
while initializing org.opencms.db.oracle.CmsVfsDriver<BR>5: log4j:WARN
Please initialize the log4j system properly.<BR>4: log4j:WARN No appenders
could be found for logger
(org.apache.commons.digester.Digester.sax).<BR>3: <BR>2: OpenCms
property file:
C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\config\opencms.properties<BR>1: OpenCms
WEB-INF path:
C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\<BR></FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]<B>On
Behalf Of </B>Tristan Tarrant<BR><B>Sent:</B> Wednesday, April 06, 2005 11:52
AM<BR><B>To:</B> The OpenCms mailing list<BR><B>Subject:</B> Re: [opencms-dev]
Does this work with Oracle or NOT?<BR><BR></FONT></DIV>On Wed, 2005-04-06 at
11:14 -0500, Bryan Cantwell wrote:<BR>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#0000ff>Has anyone ever
actually made OpenCMS work in Oracle? </FONT></FONT><FONT
color=#000000></FONT><BR><FONT size=2><FONT color=#0000ff>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 </FONT></FONT><BR></BLOCKQUOTE>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).<BR>Change the line
from:<BR><BR>m_digester.setValidating(true);<BR><BR>to<BR><BR>m_digester.setValidating(false);<BR><BR>and
it should work.<BR><BR>Tristan </BLOCKQUOTE></BODY></HTML>