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

Alexander Kandzior alex at opencms.org
Thu Apr 7 18:07:34 CEST 2005 

So far we tested the Oracle JDBC with the driver that ships for Oracle 9i.
That's not classes12.zip which is for 8.1.7. 

Best Regards,
Alex.

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



 


  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Bryan Cantwell
Sent: Thursday, April 07, 2005 5:28 PM
To: The OpenCms mailing list
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?


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(CmsSetupWorkplaceImportT
hread.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(CmsSetupWorkplaceImportT
hread.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(Cms
UserDriver.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(CmsSetupWorkplaceImportT
hread.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(CmsSetupWorkplaceImportT
hread.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(CmsSetupWorkplaceImportT
hread.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(Cms
UserDriver.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(CmsSetupWorkplaceImportT
hread.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(CmsSetupWorkplaceImportT
hread.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(Cms
UserDriver.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(CmsSetupWorkplaceImportT
hread.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(CmsSetupWorkplaceImportT
hread.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(Cms
UserDriver.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(DelegatingP
reparedStatement.java:92)
60: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
reparedStatement.java:92)
59: > at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:387)
58: > at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.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(CmsSetupWorkplaceImportT
hread.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(Cms
UserDriver.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(CmsSetupWorkplaceImportT
hread.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(Cms
UserDriver.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(DelegatingP
reparedStatement.java:92)
17:  at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
reparedStatement.java:92)
16:  at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:387)
15:  at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.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\opencm
s.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/fb21bb6c/attachment.htm>

More information about the opencms-dev mailing list