[opencms-dev] Install Opencms 6.0 beta1 problem /Tomcat 5.5.4/JDK Blackdown 1.4.1-01/Oracle 8.1.6

Sébastien Brault sebastien.brault at gmail.com
Fri Mar 18 10:55:55 CET 2005


Hi,

I'm trying to install Opencms 6.0 beta on a Linux box, running Tomcat
5.5.4 with a blackdown JDK 1.4.1-01, using an Oracle 8.1.6 database
with classes12.zip JDBC driver.

Everything is ok until the modules import, which cause always the same
error (see below).

If I try to access opencms after the installation, it says "Opencms is
not properly installed".

Any idea to help me ?

Regards.
Sebastien Brault.

198:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
197:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
196:            at org.opencms.main.CmsShell.exit(CmsShell.java:560)
195:    java.lang.NullPointerException
194:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
193:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
192:            at org.opencms.main.CmsShell.exit(CmsShell.java:554)
191:    java.lang.NullPointerException
190:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
189:            at org.opencms.main.CmsShell.start(CmsShell.java:491)
188:            at org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)
187:            at org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)
186:    java.lang.NullPointerException
185:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
184:            at org.opencms.main.CmsShell.<init>(CmsShell.java:448)
183:    java.lang.NullPointerException
182:
181:    >>      ... 8 more
180:    >>      at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)
179:    >>      at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1404)
178:    >>      at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
177:    >>      at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:270)
176:    >>Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
175:    >>query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
174:    >>Caused by: org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
173:    >>      at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
172:    >>      at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
171:    >>      at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
170:    >>      at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
169:    >>      at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
168:    >>      at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
167:    >>      at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
166:    >>      at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526)
165:    >>      at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:539)
164:    >>Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
163:    >>query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
162:    >>java.lang.RuntimeException: org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
161:    >>Root cause:
160:    >>-----------
159:    >       at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
158:    >       at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
157:    >       at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
156:    >       at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
155:    >       at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
154:    >       at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
153:    >       at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
152:    >       at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4538)
151:    >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
150:    >query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
149:    >Root cause was: java.lang.RuntimeException:
org.opencms.db.CmsSqlException: [org.opencms.db.oracle.CmsUserDriver]
where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
148:    >org.opencms.main.CmsException: Critical error while initializing
org.opencms.db.oracle.CmsUserDriver [Code 33 - DriverManager init
error]
147:    >Root cause:
146:    >-----------
145:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
144:            at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
143:            at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
142:            at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1083)
141:
140:    Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
139:    query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
138:    Root cause was: java.lang.RuntimeException:
org.opencms.db.CmsSqlException: [org.opencms.db.oracle.CmsUserDriver]
where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
137:    Root cause was: org.opencms.main.CmsException: Critical error
while initializing org.opencms.db.oracle.CmsUserDriver [Code 33 -
DriverManager init error]
136:    org.opencms.main.CmsException: Database init failed [Code 33 -
DriverManager init error]
135:    Critical error during OpenCms initialization
134:
133:    >       ... 8 more
132:    >       at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)
131:    >       at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1404)
130:    >       at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
129:    >       at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:270)
128:    >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
127:    >query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
126:    >Caused by: org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
125:    >       at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
124:    >       at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
123:    >       at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
122:    >       at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
121:    >       at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
120:    >       at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
119:    >       at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
118:    >       at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526)
117:    >       at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:539)
116:    >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
115:    >query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
114:    >java.lang.RuntimeException: org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
113:    >Root cause:
112:    >-----------
111:            at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
110:            at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
109:            at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
108:            at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
107:            at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
106:            at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
105:            at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
104:            at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4538)
103:
102:    Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
101:    query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code
301 - SQL Exception]
100:    Root cause was: java.lang.RuntimeException:
org.opencms.db.CmsSqlException: [org.opencms.db.oracle.CmsUserDriver]
where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
99:     org.opencms.main.CmsException: Critical error while initializing
org.opencms.db.oracle.CmsUserDriver [Code 33 - DriverManager init
error]
98:     Critical init error/3
97:             ... 8 more
96:             at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)
95:             at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1404)
94:             at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
93:             at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:270)
92:
91:     Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
90:     query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code 301
- SQL Exception]
89:     Caused by: org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
88:             at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
87:             at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
86:             at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
85:             at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
84:             at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
83:             at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
82:             at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
81:             at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526)
80:             at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:539)
79:
78:     Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
77:     query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code 301
- SQL Exception]
76:     java.lang.RuntimeException: org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
75:     [CmsDriverManager] Critical error while initializing
org.opencms.db.oracle.CmsUserDriver
74:
73:     >       at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
72:     >       at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
71:     >       at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
70:     >       at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
69:     >       at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
68:     >       at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
67:     >       at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
66:     >       at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526)
65:     >       at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)
64:     >       at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1404)
63:     >       at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
62:     >       at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242)
61:     >       at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
60:     >       at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
59:     >       at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:339)
58:     >       at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
57:     >       at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
56:     >       at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
55:     >       at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
54:     >       at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
53:     >       at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
52:     >       at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
51:     >       at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
50:     >java.sql.SQLException: ORA-00933: SQL command not properly ended
49:     >Root cause:
48:     >-----------
47:             at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
46:             at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
45:             at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
44:             at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
43:             at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
42:             at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
41:             at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
40:             at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526)
39:             at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)
38:             at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1404)
37:             at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
36:             at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:270)
35:
34:     Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
33:     query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17 [Code 301
- SQL Exception]
32:     org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
31:     Initialization of default users and groups failed
30:             at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
29:             at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
28:             at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1413)
27:             at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1077)
26:             at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)
25:             at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2251)
24:             at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:422)
23:             at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4526)
22:             at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:533)
21:             at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1404)
20:             at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
19:             at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242)
18:             at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
17:             at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
16:             at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:339)
15:             at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
14:             at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
13:             at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
12:             at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
11:             at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
10:             at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
9:              at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
8:              at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
7:
6:      java.sql.SQLException: ORA-00933: SQL command not properly ended
5:      query: oracle.jdbc.driver.OraclePreparedStatement at 9daa17
4:      org.opencms.db.CmsSqlException:
[org.opencms.db.oracle.CmsUserDriver] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:242),
why: java.sql.SQLException: ORA-00933: SQL command not properly ended
3:
2:      OpenCms property file:
/home/braults/OpenCMS/tomcat-5.5.4/webapps/opencms/WEB-INF/config/opencms.properties
1:      OpenCms WEB-INF path:
/home/braults/OpenCMS/tomcat-5.5.4/webapps/opencms/WEB-INF/



More information about the opencms-dev mailing list