[opencms-dev] tomcat 4/5 + Oracle 8 + Solaris
lanhao
kylinlan at 163.com
Thu Jan 27 04:07:21 CET 2005
look at
http://mail.opencms.org/pipermail/opencms-dev/2005q1/014620.html
----- Original Message -----
From: Robin Antony
To: opencms-dev at opencms.org
Sent: Thursday, January 27, 2005 10:27 AM
Subject: [opencms-dev] tomcat 4/5 + Oracle 8 + Solaris
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(CmsSetupWorkplaceImportThread.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(CmsSetupWorkplaceImportThread.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:130)
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(CmsSetupWorkplaceImportThread.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:130)
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(CmsSetupWorkplaceImportThread.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(CmsSetupWorkplaceImportThread.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:130)
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(CmsSetupWorkplaceImportThread.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:130)
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(CmsSetupWorkplaceImportThread.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:130)
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(CmsSetupWorkplaceImportThread.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:130)
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(DelegatingPreparedStatement.java:92)
63: > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
62: > at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
61: > at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.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(CmsSetupWorkplaceImportThread.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:130)
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(CmsSetupWorkplaceImportThread.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:130)
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(DelegatingPreparedStatement.java:92)
18: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
17: at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
16: at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.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.properties
1: OpenCms WEB-INF path: /opt/zed/jakarta-tomcat-5.0.28/webapps/opencms/WEB-INF/
------------------------------------------------------------------------------
_______________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050127/4c5eb9fe/attachment.htm>
More information about the opencms-dev
mailing list