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

Frans Postma fpostma at xs4all.nl
Tue Apr 12 00:19:23 CEST 2005


Given that setup log should be several THOUSAND lines long (I kid you not), I don't think you're almost there :)
Setup really should abort on exceptionslike these in my opinion.

Anyway, you're sure that
a) dom4j-1.5.2.jar  is in webapps/lib
b) there is no other dom*jar lingering around someplace??

The class jaxen wants is in dom4j-1.5.2.jar for sure, so either it doesn't find it, finds the wrong one or tomcat doesn't let it
access that second class file.

You're using tomcat 5.0 or 5.5 ?? (5.5 security was strengthened I believe).

Frans 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Bryan Cantwell
> Sent: maandag 11 april 2005 21:03
> To: The OpenCms mailing list
> Subject: RE: [opencms-dev] Does this work with Oracle or NOT?
> 
> Looks like my Oracle deployment is almost there, But I still 
> have this dom4j challenge, here is the import workspace output:
> 157:	
> 156:	Shutdown completed, total uptime was 00:07:13.
> 155:	Shutting down OpenCms, version 6.0 beta 2 Corrin in web 
> application 'opencms'
> 154:	
> 153:	
> 152:	The OpenCms system used for the setup will now shut down.
> 151:	The setup is finished!
> 150:	
> 149:	
> 148:	Admin at Offline>exit
> 147:	Admin at Offline>
> 146:	Indexing statistics: indexed files: 0, returned 
> threads: 0, abandoned threads: 0, duration: 00:00:00
> 145:	------ ... finished indexing
> 144:	------ Indexing ------ System folder------  ...
> 143:	Indexing statistics: indexed files: 0, returned 
> threads: 0, abandoned threads: 0, duration: 00:00:00
> 142:	------ ... finished indexing
> 141:	------ Indexing ------ Offline project (VFS)------  ...
> 140:	Indexing statistics: indexed files: 0, returned 
> threads: 0, abandoned threads: 0, duration: 00:00:00
> 139:	------ ... finished indexing
> 138:	------ Indexing ------ Online project (VFS)------  ...
> 137:	Admin at Offline>updateIndex
> 136:	Admin at Offline># Build search indexes
> 135:	Admin at Offline>
> 134:	Admin at Offline>importModulesFromSetupBean
> 133:	Admin at Offline># Import the modules that have been 
> selected in the setup wizard
> 132:	Admin at Offline>
> 131:	Admin at Offline>setSiteRoot /sites/default/
> 130:	Admin at Online>createDefaultProject Offline The Offline Project
> 129:	Admin at Online># Create the default "Offline" project
> 128:	Admin at Online>
> 127:	9a8a185a-aac9-11d9-ac2a-f9f8d361dbdd
> 126:	Statistics: published files: 0, published folders: 5, 
> deleted folders: 0, duration: 00:00:01
> 125:	------ ... finished publishing folders
> 124:	( 5 / 5 ) Publishing folder /system/ ...  o.k.
> 123:	( 4 / 5 ) Publishing folder /sites/default/ ...  o.k.
> 122:	( 3 / 5 ) Publishing folder /sites/ ...  o.k.
> 121:	( 2 / 5 ) Publishing folder /channels/ ...  o.k.
> 120:	( 1 / 5 ) Publishing folder / ...  o.k.
> 119:	------ Publishing folders ...
> 118:	Admin at _setupProject>publishProject
> 117:	Admin at _setupProject>unlockCurrentProject
> 116:	Admin at _setupProject># Publish the project
> 115:	Admin at _setupProject>
> 114:		at 
> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWo
> rkplaceImportThread.java:148)
> 113:		at org.opencms.main.CmsShell.start(CmsShell.java:491)
> 112:		at 
> org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
> 111:		at 
> org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
> 110:		at 
> org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsSh
> ell.java:237)
> 109:		at java.lang.reflect.Method.invoke(Method.java:324)
> 108:		at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth
> odAccessorImpl.java:25)
> 107:		at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
> orImpl.java:39)
> 106:		at 
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 105:		at 
> org.opencms.main.CmsShellCommands.importResources(CmsShellComm
> ands.java:514)
> 104:		at 
> org.opencms.importexport.CmsImportExportManager.importData(Cms
> ImportExportManager.java:400)
> 103:		at 
> org.opencms.importexport.CmsImportExportManager.getImportExpor
> tHandler(CmsImportExportManager.java:318)
> 102:		at 
> com.opencms.legacy.CmsCosImportExportHandler.matches(CmsCosImp
> ortExportHandler.java:210)
> 101:		at 
> org.dom4j.tree.AbstractNode.selectNodes(AbstractNode.java:161)
> 100:		at 
> org.dom4j.tree.AbstractNode.createXPath(AbstractNode.java:205)
> 99:		at 
> org.dom4j.DocumentFactory.createXPath(DocumentFactory.java:196)
> 98:		at 
> org.dom4j.xpath.DefaultXPath.<init>(DefaultXPath.java:51)
> 97:		at 
> org.dom4j.xpath.DefaultXPath.parse(DefaultXPath.java:312)
> 96:		at 
> org.jaxen.dom4j.Dom4jXPath.<init>(Dom4jXPath.java:103)
> 95:	java.lang.NoClassDefFoundError: org/dom4j/Element
> 94:	Exception while calling method 'importResources'
> 93:	Admin at _setupProject>importResources setupdata/vfs /
> 92:	Admin at _setupProject># Import the workplace
> 91:	Admin at _setupProject>
> 90:	Admin at _setupProject>chacc / group Guests +v+r+i
> 89:	Admin at _setupProject>chacc / group Users +v+w+r+c+i
> 88:	Admin at _setupProject>chacc / group Projectmanagers +v+w+r+c+d+i
> 87:	Admin at _setupProject>chacc / group Administrators +v+w+r+c+d+i
> 86:	Admin at _setupProject># Apply folder permissions
> 85:	Admin at _setupProject>
> 84:	[org.opencms.file.CmsResource, path: /sites/default/, 
> structure id 99863ce8-aac9-11d9-ac2a-f9f8d361dbdd, resource 
> id: 99863ce9-aac9-11d9-ac2a-f9f8d361dbdd, type id: 0, folder: 
> true, flags: 0, project: 2, state: 2, date created: Mon Apr 
> 11 13:38:02 PDT 2005, user created: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date lastmodified: Mon 
> Apr 11 13:38:02 PDT 2005, user lastmodified: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date released: Wed Dec 
> 31 16:00:00 PST 1969, date expired: Sun Aug 17 00:12:55 PDT 
> 292278994, size: -1 sibling count: 1]
> 83:	Admin at _setupProject>createFolder /sites/ default/
> 82:	[org.opencms.file.CmsResource, path: /channels/, 
> structure id 9970b916-aac9-11d9-ac2a-f9f8d361dbdd, resource 
> id: 9970b917-aac9-11d9-ac2a-f9f8d361dbdd, type id: 0, folder: 
> true, flags: 0, project: 2, state: 2, date created: Mon Apr 
> 11 13:38:02 PDT 2005, user created: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date lastmodified: Mon 
> Apr 11 13:38:02 PDT 2005, user lastmodified: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date released: Wed Dec 
> 31 16:00:00 PST 1969, date expired: Sun Aug 17 00:12:55 PDT 
> 292278994, size: -1 sibling count: 1]
> 81:	Admin at _setupProject>createFolder / channels/
> 80:	[org.opencms.file.CmsResource, path: /sites/, structure 
> id 995b3544-aac9-11d9-ac2a-f9f8d361dbdd, resource id: 
> 995b3545-aac9-11d9-ac2a-f9f8d361dbdd, type id: 0, folder: 
> true, flags: 0, project: 2, state: 2, date created: Mon Apr 
> 11 13:38:02 PDT 2005, user created: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date lastmodified: Mon 
> Apr 11 13:38:02 PDT 2005, user lastmodified: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date released: Wed Dec 
> 31 16:00:00 PST 1969, date expired: Sun Aug 17 00:12:55 PDT 
> 292278994, size: -1 sibling count: 1]
> 79:	Admin at _setupProject>createFolder / sites/
> 78:	[org.opencms.file.CmsResource, path: /system/, 
> structure id 993eac92-aac9-11d9-ac2a-f9f8d361dbdd, resource 
> id: 993eac93-aac9-11d9-ac2a-f9f8d361dbdd, type id: 0, folder: 
> true, flags: 0, project: 2, state: 2, date created: Mon Apr 
> 11 13:38:02 PDT 2005, user created: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date lastmodified: Mon 
> Apr 11 13:38:02 PDT 2005, user lastmodified: 
> c300ba5c-01e8-3727-b305-5dcc9ccae1ee, date released: Wed Dec 
> 31 16:00:00 PST 1969, date expired: Sun Aug 17 00:12:55 PDT 
> 292278994, size: -1 sibling count: 1]
> 77:	Admin at _setupProject>createFolder / system/
> 76:	Admin at _setupProject># Create folder structure
> 75:	Admin at _setupProject>
> 74:	Admin at _setupProject>setSiteRoot /
> 73:	Admin at _setupProject># Switch to the root context
> 72:	Admin at _setupProject>
> 71:	[Propertydefinition] name:locale 
> id:9921fccf-aac9-11d9-ac2a-f9f8d361dbdd
> 70:	Admin at _setupProject>createPropertyDefinition locale
> 69:	[Propertydefinition] name:template-elements 
> id:990ca00c-aac9-11d9-ac2a-f9f8d361dbdd
> 68:	Admin at _setupProject>createPropertyDefinition template-elements
> 67:	[Propertydefinition] name:template 
> id:98f98d39-aac9-11d9-ac2a-f9f8d361dbdd
> 66:	Admin at _setupProject>createPropertyDefinition template
> 65:	[Propertydefinition] name:stream 
> id:98e40966-aac9-11d9-ac2a-f9f8d361dbdd
> 64:	Admin at _setupProject>createPropertyDefinition stream
> 63:	[Propertydefinition] name:cache 
> id:98d0f693-aac9-11d9-ac2a-f9f8d361dbdd
> 62:	Admin at _setupProject>createPropertyDefinition cache
> 61:	[Propertydefinition] name:internal 
> id:98c054c0-aac9-11d9-ac2a-f9f8d361dbdd
> 60:	Admin at _setupProject>createPropertyDefinition internal
> 59:	[Propertydefinition] name:content-conversion 
> id:98aad0ed-aac9-11d9-ac2a-f9f8d361dbdd
> 58:	Admin at _setupProject>createPropertyDefinition content-conversion
> 57:	[Propertydefinition] name:content-encoding 
> id:9897be1a-aac9-11d9-ac2a-f9f8d361dbdd
> 56:	Admin at _setupProject>createPropertyDefinition content-encoding
> 55:	[Propertydefinition] name:default-file 
> id:9884ab47-aac9-11d9-ac2a-f9f8d361dbdd
> 54:	Admin at _setupProject>createPropertyDefinition default-file
> 53:	[Propertydefinition] name:exportname 
> id:986cdd84-aac9-11d9-ac2a-f9f8d361dbdd
> 52:	Admin at _setupProject>createPropertyDefinition exportname
> 51:	[Propertydefinition] name:export 
> id:9859cab1-aac9-11d9-ac2a-f9f8d361dbdd
> 50:	Admin at _setupProject>createPropertyDefinition export
> 49:	[Propertydefinition] name:NavPos 
> id:9846b7de-aac9-11d9-ac2a-f9f8d361dbdd
> 48:	Admin at _setupProject>createPropertyDefinition NavPos
> 47:	[Propertydefinition] name:NavText 
> id:982a081b-aac9-11d9-ac2a-f9f8d361dbdd
> 46:	Admin at _setupProject>createPropertyDefinition NavText
> 45:	[Propertydefinition] name:Keywords 
> id:9814ab58-aac9-11d9-ac2a-f9f8d361dbdd
> 44:	Admin at _setupProject>createPropertyDefinition Keywords
> 43:	[Propertydefinition] name:Description 
> id:97f7fb95-aac9-11d9-ac2a-f9f8d361dbdd
> 42:	Admin at _setupProject>createPropertyDefinition Description
> 41:	[Propertydefinition] name:Title 
> id:97c5ef12-aac9-11d9-ac2a-f9f8d361dbdd
> 40:	Admin at _setupProject>createPropertyDefinition Title
> 39:	Admin at _setupProject># Initialize the default property 
> definitions
> 38:	Admin at _setupProject>
> 37:	[Project]:_setupProject , Id=2 :Initial site import
> 36:	Admin at Online>setCurrentProject _setupProject
> 35:	Admin at Online># Switch to the setup project
> 34:	Admin at Online>
> 33:	[Project]:tempFileProject , Id=3 :The project for 
> temporary Workplace files
> 32:	Admin at Online>createTempfileProject
> 31:	Admin at Online># Create the setup project
> 30:	Admin at Online>
> 29:	You are now logged in as user 'Admin'.
> 28:	Guest at Online>login Admin admin
> 27:	Guest at Online># Login the Admin user
> 26:	Guest at Online>
> 25:	Guest at Online>Echo is now on
> 24:	Guest at Online># Turn echo on
> 23:	
> 22:	
> 21:	This is OpenCms 6.0 beta 2 Corrin
> 20:	
> 19:	Copyright (c) 2002-2005 Alkacon Software
> 18:	OpenCms comes with ABSOLUTELY NO WARRANTY
> 17:	This is free software, and you are welcome to
> 16:	redistribute it under certain conditions.
> 15:	Please see the GNU Lesser General Public Licence for
> 14:	further details.
> 13:	
> 12:	Starting Workplace import and database setup for OpenCms!
> 11:	
> 10:	Workplace temporary file project does not yet exist!
> 9:	Workplace init: Unable to read locales folder 
> '/system/workplace/locales/', locales disabled!
> 8:	Workplace init: Unable to read editor folder 
> '/system/workplace/editors/', editors disabled!
> 7:	Workplace init: Unable to read views folder 
> '/system/workplace/views/', no views available!
> 6:	Job execution threads will use class loader of thread: 
> OpenCms: Setup workplace import
> 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 Frans Postma
> Sent: Friday, April 08, 2005 6:10 PM
> To: 'The OpenCms mailing list'
> Subject: RE: [opencms-dev] Does this work with Oracle or NOT?
> 
> 
> Bryan,
>  
> The "for update wait 10" construct was introduced in Oracle 9i. 
>  
> Are you *sure* there are no OLD classes*/ojdbc* files getting 
> in the way and thus giving you a 8.1.7. command set ?? The
> blob/abstract error also seems to indicate you have the wrong 
> class, it's been some time I used it.
>  
> The filenames are by the way NOT related to oracle-versions. 
> They are related to the JDK/JRE you want to use. 
>   
> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/
> htdocs/jdbc9201.html
>  
> Hunt down and find anything called classes*.zip, odbc* or 
> classes*.jar and rename them except one (you know; "there can be only
> one" ;-) I'm not sure if you need OCI to handle blobs, I 
> think not (in ora9 at least). 
>  
> Oh look, you can query the jdbc/driver version:
> 
> import java.sql.*;
> import oracle.jdbc.driver.*;
> 
> class JDBCVersion
> {
>    public static void main (String args[]) throws SQLException {
>       // Load the Oracle JDBC driver
>       DriverManager.registerDriver
>               (new oracle.jdbc.driver.OracleDriver());
>       Connection conn = DriverManager.getConnection
>               ("jdbc:oracle:thin:@host:port:sid","scott","tiger");
> 
>       // Create Oracle DatabaseMetaData object
>       DatabaseMetaData meta = conn.getMetaData();
> 
>       // gets driver info:
>       System.out.println("JDBC driver version is " + 
> meta.getDriverVersion());
>    }
> }
> ====================================================
> 
> Well, have fun... I'm of to sleeeeeeeeeeeeeeeeeeeeeeep.
> 
> Frans
> 
> 
> _______________________________________________
> 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
> 
> 




More information about the opencms-dev mailing list