[opencms-dev] Does this work with Oracle or NOT?

Bryan Cantwell bcantwell at advocare.com
Thu Apr 7 17:27:54 CEST 2005 

Now I am a step closer... I moved the ojdbc4.jar file and did ant war. Deployed the war, and at import workspace this happens:
Should I use the classes12.zip instead or what?
 
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:542)
179: >> at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
178: >> at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
177: >> at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)
176: >>Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
175: >>query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
170: >> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
169: >> at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
168: >> at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
167: >> at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
166: >> at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
165: >> at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:548)
164: >>Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
163: >>query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
156: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
155: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
154: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
153: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
152: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)
151: >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
150: >query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
142:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:964)
141: 
140: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
139: query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:542)
131: > at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
130: > at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
129: > at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)
128: >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
127: >query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
122: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
121: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
120: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
119: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
118: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
117: > at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:548)
116: >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
115: >query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
108:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
107:  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
106:  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
105:  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
104:  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)
103: 
102: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
101: query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:542)
95:  at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
94:  at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
93:  at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)
92: 
91: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
90: query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
85:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
84:  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
83:  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
82:  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
81:  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
80:  at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:548)
79: 
78: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
77: query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [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:249), 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:1407)
70: > at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
69: > at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
68: > at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
67: > at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
66: > at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
65: > at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)
64: > at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
63: > at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
62: > at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:249)
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:387)
58: > at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
57: > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2660)
56: > at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2371)
55: > at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:677)
54: > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
53: > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
52: > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
51: > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
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:1407)
44:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
43:  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
42:  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
41:  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
40:  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
39:  at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)
38:  at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
37:  at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
36:  at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)
35: 
34: Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended
33: query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190 [Code 301 - SQL Exception]
32: org.opencms.db.CmsSqlException: [org.opencms.db.oracle.CmsUserDriver] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:249), 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:1407)
27:  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
26:  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
25:  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
24:  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
23:  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
22:  at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)
21:  at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
20:  at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
19:  at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:249)
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:387)
15:  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
14:  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2660)
13:  at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2371)
12:  at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:677)
11:  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
10:  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
9:  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
8:  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
7: 
6: java.sql.SQLException: ORA-00933: SQL command not properly ended
5: query: oracle.jdbc.driver.OraclePreparedStatement at 1cdc190
4: org.opencms.db.CmsSqlException: [org.opencms.db.oracle.CmsUserDriver] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:249), why: java.sql.SQLException: ORA-00933: SQL command not properly ended
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 Alexander Kandzior
Sent: Thursday, April 07, 2005 1:40 AM
To: 'The OpenCms mailing list'
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?


The oracle support was not compiled. You need to supply the oracle JDBC lib yourself. Check the build.xml, there's a variable defined that contians the jar location.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com <http://www.alkacon.com/> 



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050407/9aaab83a/attachment.htm>

More information about the opencms-dev mailing list