[opencms-dev] Does this work with Oracle or NOT?
Bryan Cantwell
bcantwell at advocare.com
Fri Apr 8 20:29:24 CEST 2005
After looking at the error from before (sql statement not properly ended) I found that it was because the query being run was ended with 'for update wait 10' this made my db throw. I removed the wait 10 from the query.properties file in the oracle dir inside the jar. Now I get the following:
33: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
32: at org.opencms.main.CmsShell.exit(CmsShell.java:560)
31: java.lang.NullPointerException
30: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)
29: at org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)
28: at org.opencms.main.CmsShell.exit(CmsShell.java:554)
27: java.lang.NullPointerException
26: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)
25: at org.opencms.main.CmsShell.start(CmsShell.java:491)
24: at org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)
23: at org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)
22: java.lang.NullPointerException
21: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
20: at org.opencms.main.CmsShell.<init>(CmsShell.java:448)
19: java.lang.NullPointerException
18: at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)
17: at org.opencms.main.CmsShell.<init>(CmsShell.java:445)
16: at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)
15: at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)
14: at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)
13: at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)
12: at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)
11: at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)
10: at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)
9: at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)
8: at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)
7: at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:255)
6: at org.opencms.db.oracle.CmsUserDriver.getOutputStreamFromBlob(CmsUserDriver.java:342)
5: java.lang.AbstractMethodError: oracle.sql.BLOB.truncate(J)V
4: Critical error during OpenCms initialization
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 4:10 PM
To: 'The OpenCms mailing list'
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?
AFAIK there are many different versions of JDBCs from Oracle that are called "odbc14.jar", try to obtain the ones listed on OTN that are for Oracle 9.
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 7:23 PM
To: The OpenCms mailing list
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?
ojdbc14.jar as listed in teh build.xml file is what I moved into the directory. Everything compiled fine. But now the error below occurs.... ("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")
-----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 11:08 AM
To: 'The OpenCms mailing list'
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?
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(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/20050408/af10f363/attachment.htm>
More information about the opencms-dev
mailing list