<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Does this work with Oracle or NOT?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=246393706-07042005><FONT face=Arial
color=#0000ff size=2>The oracle support was not compiled. You need to supply the
oracle JDBC lib yourself. Check the build.xml, there's a variable defined that
contians the jar location.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Best Regards,<BR>Alex.<BR><BR>Alexander Kandzior<BR>Alkacon
Software - The OpenCms Experts<BR><A
href="http://www.alkacon.com/">http://www.alkacon.com</A><BR><BR></FONT></P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Bryan
Cantwell<BR><B>Sent:</B> Wednesday, April 06, 2005 10:57 PM<BR><B>To:</B> The
OpenCms mailing list<BR><B>Subject:</B> RE: [opencms-dev] Does this work with
Oracle or NOT?<BR></FONT><BR></DIV>
<DIV></DIV>
<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></BLOCKQUOTE></BODY></HTML>