[opencms-dev] Does this work with Oracle or NOT?
Bryan Cantwell
bcantwell at advocare.com
Mon Apr 11 21:03:00 CEST 2005
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(CmsSetupWorkplaceImportThread.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(CmsShell.java:237)
109: at java.lang.reflect.Method.invoke(Method.java:324)
108: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
107: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
106: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
105: at org.opencms.main.CmsShellCommands.importResources(CmsShellCommands.java:514)
104: at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:400)
103: at org.opencms.importexport.CmsImportExportManager.getImportExportHandler(CmsImportExportManager.java:318)
102: at com.opencms.legacy.CmsCosImportExportHandler.matches(CmsCosImportExportHandler.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
More information about the opencms-dev
mailing list