[opencms-dev] tomcat 4/5 + Oracle 8 + Solaris
Robin Antony
robin at zed.com.sg
Thu Jan 27 03:27:38 CET 2005
Hi,
I am running the latest version of opencms 6.0 alpha 3 on Solaris and
connecting to Oracle 8. I run the setup wizard
and finally it comes to this page for importing the workplace. This is
the exception that gets thrown. I have been on this for several days now
with no use.
On opencms version 5 it just hangs when it reaches the import workplace.
Can someone please help me with this. Any hints or pointers?
Best Regards,
Robin Antony
192: java.lang.NullPointerException
191: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
190: at
org.opencms.main.CmsShell.<init>(CmsShell.java:448)
189: java.lang.NullPointerException
188:
187: >> ... 8 more
186: >> at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)
185: >> at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups
(CmsUserDriver.java:1400)
184: >> at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
183: >> at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:266)
182: >> at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:
295)
181: >>Root cause was: java.sql.SQLException: ORA-00933: SQL
command not properly ended
180: >> [Code 4 - Sql exception]
179: >>Caused by: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
178: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
177: >> at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
176: >> at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
175: >> at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
174: >> at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
173: >> at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
172: >> at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
171: >> at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4457)
170: >> at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:535)
169: >>Root cause was: java.sql.SQLException: ORA-00933: SQL
command not properly ended
168: >> [Code 4 - Sql exception]
167: >>java.lang.RuntimeException: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
166: >>Root cause:
165: >>-----------
164: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
163: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
162: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
161: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
160: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
159: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
158: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
157: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4469)
156: >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
155: > [Code 4 - Sql exception]
154: >Root cause was: java.lang.RuntimeException:
org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver]
[internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
153: >org.opencms.main.CmsException: Critical error while
initializing org.opencms.db.oracle.CmsUserDriver [Code 33 -
DriverManager init error]
152: >Root cause:
151: >-----------
150: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
149: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
148: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
147: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1041)
146:
145: Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
144: [Code 4 - Sql exception]
143: Root cause was: java.lang.RuntimeException:
org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver]
[internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
142: Root cause was: org.opencms.main.CmsException: Critical error
while initializing org.opencms.db.oracle.CmsUserDriver [Code 33 -
DriverManager init error]
141: org.opencms.main.CmsException: Database init failed [Code 33 -
DriverManager init error]
140: Critical error during OpenCms initialization
139:
138: > ... 8 more
137: > at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)
136: > at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups
(CmsUserDriver.java:1400)
135: > at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
134: > at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:266)
133: > at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:
295)
132: >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
131: > [Code 4 - Sql exception]
130: >Caused by: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
129: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
128: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
127: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
126: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
125: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
124: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
123: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
122: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4457)
121: > at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:535)
120: >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
119: > [Code 4 - Sql exception]
118: >java.lang.RuntimeException: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
117: >Root cause:
116: >-----------
115: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
114: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
113: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
112: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
111: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
110: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
109: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
108: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4469)
107:
106: Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
105: [Code 4 - Sql exception]
104: Root cause was: java.lang.RuntimeException:
org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver]
[internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
103: org.opencms.main.CmsException: Critical error while
initializing org.opencms.db.oracle.CmsUserDriver [Code 33 -
DriverManager init error]
102: Critical init error/3
101: ... 8 more
100: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)
99: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups
(CmsUserDriver.java:1400)
98: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
97: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:266)
96: at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:
295)
95:
94: Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
93: [Code 4 - Sql exception]
92: Caused by: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
91: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
90: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
89: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
88: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
87: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
86: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
85: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
84: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4457)
83: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:535)
82:
81: Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
80: [Code 4 - Sql exception]
79: java.lang.RuntimeException: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
78: [CmsDriverManager] Critical error while initializing
org.opencms.db.oracle.CmsUserDriver
77:
76: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
75: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
74: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
73: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
72: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
71: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
70: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
69: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4457)
68: > at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)
67: > at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups
(CmsUserDriver.java:1400)
66: > at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
65: > at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238)
64: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
63: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
62: > at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt
atement.java)
61: > at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java)
60: > at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java)
59: > at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
58: > at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
57: > at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
56: > at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
55: > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
54: > at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
53: > at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
52: >java.sql.SQLException: ORA-00933: SQL command not properly
ended
51: >Root cause:
50: >-----------
49: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
48: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
47: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
46: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
45: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
44: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
43: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
42: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4457)
41: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)
40: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups
(CmsUserDriver.java:1400)
39: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
38: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:266)
37: at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:
295)
36:
35: Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
34: [Code 4 - Sql exception]
33: org.opencms.main.CmsException:
[org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
32: Initialization of default users and groups failed
31: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:142)
30: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)
29: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)
28: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)
27: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:13
0)
26: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)
25: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)
24: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:
4457)
23: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)
22: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups
(CmsUserDriver.java:1400)
21: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
20: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238)
19: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
18: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
17: at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt
atement.java)
16: at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java)
15: at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java)
14: at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
13: at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
12: at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
11: at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
10: at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
9: at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
8: at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
7:
6: java.sql.SQLException: ORA-00933: SQL command not properly
ended
5:
4: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo
id=9d621efd-c454-39a9-a475-bd1f828bb103] where:
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.
java:238), why: java.sql.SQLException: ORA-00933: SQL command not
properly ended
3:
2: OpenCms property file:
/opt/zed/jakarta-tomcat-5.0.28/webapps/opencms/WEB-INF/config/opencms.pr
operties
1: OpenCms WEB-INF path:
/opt/zed/jakarta-tomcat-5.0.28/webapps/opencms/WEB-INF/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050127/224d8325/attachment.htm>
More information about the opencms-dev
mailing list