[opencms-dev] error! when setup Opencms6.0 alpha2 with Oracle 8
cdg3472
kosol.t at g-able.com
Fri Oct 29 14:53:01 CEST 2004
Dear all
I have problem when i try to use opencms6 alpha2 with oracle8.
I had copy "classes12.jar" and "nls_charset12.jar" to OCMS's lib.
Setup wizard pass connect DB, create DB and Create Table with no problem.
but when I import workplace i got this error
Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
Could anyone please help me to solve this problem?
Best regard,
Kosol
--------------------------------
Kosol Tuanveeradej
kosol.t at g-able.com
Here is content of setup.log file.
=====================================================
1: OpenCms WEB-INF path: D:\Tomcat5_test\webapps\opencms\WEB-INF\
2: OpenCms property file:
D:\Tomcat5_test\webapps\opencms\WEB-INF\config\opencms.properties
3:
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
5:
6: Critical error while loading driver manager
7: 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
8: [Code 4 - Sql exception]
9: Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
10:
11: at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:287)
12: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:268)
13: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
14: at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
15: at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
16: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
17: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
18: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
19: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
20: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
21: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
22: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
23: >-----------
24: >Root cause:
25: >java.sql.SQLException: ORA-00933: SQL command not properly ended
26: > at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
27: > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
28: > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
29: > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
30: > at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
31: > at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
32: > at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
33: > at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
34: > at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
35: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
36: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
37: > at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)
38: > at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
39: > at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
40: > at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
41: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
42: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
43: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
44: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
45: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
46: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
47: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
48:
49: Critical init error/3
50: org.opencms.main.CmsException: Critical error while loading
driver manager [Code 33 - DriverManager init error]
51: Root cause was: 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
52: [Code 4 - Sql exception]
53: Root cause was: java.sql.SQLException: ORA-00933: SQL command not
properly ended
54:
55: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:421)
56: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
57: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
58: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
59: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
60: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
61: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
62: >-----------
63: >Root cause:
64: >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
65: > [Code 4 - Sql exception]
66: >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
67: > at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:287)
68: > at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:268)
69: > at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
70: > at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
71: > at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
72: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
73: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
74: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
75: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
76: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
77: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
78: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
79: >>-----------
80: >>Root cause:
81: >>java.sql.SQLException: ORA-00933: SQL command not properly ended
82: >> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
83: >> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
84: >> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
85: >> at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
86: >> at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
87: >> at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
88: >> at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
89: >> at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
90: >> at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
91: >> at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
92: >> at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
93: >> at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)
94: >> at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
95: >> at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
96: >> at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
97: >> at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
98: >> at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
99: >> at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
100: >> at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
101: >> at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
102: >> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
103: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
104:
105: Critical error during OpenCms initialization
106: org.opencms.main.CmsException: Database init failed [Code 33 -
DriverManager init error]
107: Root cause was: org.opencms.main.CmsException: Critical error
while loading driver manager [Code 33 - DriverManager init error]
108: Root cause was: 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
109: [Code 4 - Sql exception]
110: Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
111:
112: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:975)
113: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
114: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
115: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
116: >-----------
117: >Root cause:
118: >org.opencms.main.CmsException: Critical error while loading
driver manager [Code 33 - DriverManager init error]
119: >Root cause was: 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
120: > [Code 4 - Sql exception]
121: >Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
122: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:421)
123: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
124: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
125: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
126: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
127: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
128: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
129: >>-----------
130: >>Root cause:
131: >>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
132: >> [Code 4 - Sql exception]
133: >>Root cause was: java.sql.SQLException: ORA-00933: SQL command
not properly ended
134: >> at
org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:287)
135: >> at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:268)
136: >> at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
137: >> at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
138: >> at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
139: >> at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
140: >> at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
141: >> at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
142: >> at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
143: >> at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
144: >> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
145: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
146: >>>-----------
147: >>>Root cause:
148: >>>java.sql.SQLException: ORA-00933: SQL command not properly ended
149: >>> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
150: >>> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
151: >>> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
152: >>> at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
153: >>> at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
154: >>> at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
155: >>> at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
156: >>> at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
157: >>> at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
158: >>> at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
159: >>> at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
160: >>> at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)
161: >>> at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
162: >>> at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
163: >>> at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
164: >>> at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
165: >>> at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
166: >>> at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
167: >>> at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
168: >>> at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
169: >>> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
170: >>> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
171:
172: java.lang.NullPointerException
173: at org.opencms.main.CmsShell.<init>(CmsShell.java:448)
174: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
175: java.lang.NullPointerException
176: at org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)
177: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)
178: at org.opencms.main.CmsShell.start(CmsShell.java:491)
179: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
180: java.lang.NullPointerException
181: at org.opencms.main.CmsShell.exit(CmsShell.java:554)
182: at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
183: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
184: java.lang.NullPointerException
185: at org.opencms.main.CmsShell.exit(CmsShell.java:560)
186: at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
187: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
-------------- next part --------------
1: OpenCms WEB-INF path: D:\Tomcat5_test\webapps\opencms\WEB-INF\
2: OpenCms property file: D:\Tomcat5_test\webapps\opencms\WEB-INF\config\opencms.properties
3:
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
5:
6: Critical error while loading driver manager
7: 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
8: [Code 4 - Sql exception]
9: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
10:
11: at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:287)
12: at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:268)
13: at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
14: at org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
15: at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
16: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
17: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
18: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
19: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
20: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
21: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
22: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
23: >-----------
24: >Root cause:
25: >java.sql.SQLException: ORA-00933: SQL command not properly ended
26: > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
27: > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
28: > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
29: > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
30: > at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
31: > at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
32: > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
33: > at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
34: > at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
35: > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
36: > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
37: > at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)
38: > at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
39: > at org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
40: > at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
41: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
42: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
43: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
44: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
45: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
46: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
47: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
48:
49: Critical init error/3
50: org.opencms.main.CmsException: Critical error while loading driver manager [Code 33 - DriverManager init error]
51: Root cause was: 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
52: [Code 4 - Sql exception]
53: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
54:
55: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:421)
56: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
57: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
58: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
59: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
60: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
61: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
62: >-----------
63: >Root cause:
64: >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
65: > [Code 4 - Sql exception]
66: >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
67: > at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:287)
68: > at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:268)
69: > at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
70: > at org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
71: > at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
72: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
73: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
74: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
75: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
76: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
77: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
78: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
79: >>-----------
80: >>Root cause:
81: >>java.sql.SQLException: ORA-00933: SQL command not properly ended
82: >> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
83: >> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
84: >> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
85: >> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
86: >> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
87: >> at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
88: >> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
89: >> at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
90: >> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
91: >> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
92: >> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
93: >> at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)
94: >> at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
95: >> at org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
96: >> at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
97: >> at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
98: >> at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
99: >> at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
100: >> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
101: >> at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
102: >> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
103: >> at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
104:
105: Critical error during OpenCms initialization
106: org.opencms.main.CmsException: Database init failed [Code 33 - DriverManager init error]
107: Root cause was: org.opencms.main.CmsException: Critical error while loading driver manager [Code 33 - DriverManager init error]
108: Root cause was: 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
109: [Code 4 - Sql exception]
110: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
111:
112: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:975)
113: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
114: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
115: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
116: >-----------
117: >Root cause:
118: >org.opencms.main.CmsException: Critical error while loading driver manager [Code 33 - DriverManager init error]
119: >Root cause was: 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
120: > [Code 4 - Sql exception]
121: >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
122: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:421)
123: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
124: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
125: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
126: > at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
127: > at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
128: > at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
129: >>-----------
130: >>Root cause:
131: >>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
132: >> [Code 4 - Sql exception]
133: >>Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
134: >> at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:287)
135: >> at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:268)
136: >> at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
137: >> at org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
138: >> at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
139: >> at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
140: >> at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
141: >> at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
142: >> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
143: >> at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
144: >> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
145: >> at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
146: >>>-----------
147: >>>Root cause:
148: >>>java.sql.SQLException: ORA-00933: SQL command not properly ended
149: >>> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
150: >>> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
151: >>> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
152: >>> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
153: >>> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
154: >>> at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
155: >>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
156: >>> at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
157: >>> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
158: >>> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
159: >>> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
160: >>> at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)
161: >>> at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)
162: >>> at org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:359)
163: >>> at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4793)
164: >>> at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:411)
165: >>> at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:1975)
166: >>> at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:98)
167: >>> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:969)
168: >>> at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1321)
169: >>> at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
170: >>> at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
171:
172: java.lang.NullPointerException
173: at org.opencms.main.CmsShell.<init>(CmsShell.java:448)
174: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
175: java.lang.NullPointerException
176: at org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)
177: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)
178: at org.opencms.main.CmsShell.start(CmsShell.java:491)
179: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
180: java.lang.NullPointerException
181: at org.opencms.main.CmsShell.exit(CmsShell.java:554)
182: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
183: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
184: java.lang.NullPointerException
185: at org.opencms.main.CmsShell.exit(CmsShell.java:560)
186: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
187: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
More information about the opencms-dev
mailing list