[opencms-dev] Does this work with Oracle or NOT?
Frans Postma
fpostma at xs4all.nl
Sat Apr 9 01:09:41 CEST 2005
Bryan,
The "for update wait 10" construct was introduced in Oracle 9i.
Are you *sure* there are no OLD classes*/ojdbc* files getting in the way and thus giving you a 8.1.7. command set ?? The
blob/abstract error also seems to indicate you have the wrong class, it's been some time I used it.
The filenames are by the way NOT related to oracle-versions. They are related to the JDK/JRE you want to use.
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html
Hunt down and find anything called classes*.zip, odbc* or classes*.jar and rename them except one (you know; "there can be only
one" ;-) I'm not sure if you need OCI to handle blobs, I think not (in ora9 at least).
Oh look, you can query the jdbc/driver version:
import java.sql.*;
import oracle.jdbc.driver.*;
class JDBCVersion
{
public static void main (String args[]) throws SQLException {
// Load the Oracle JDBC driver
DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@host:port:sid","scott","tiger");
// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData();
// gets driver info:
System.out.println("JDBC driver version is " + meta.getDriverVersion());
}
}
====================================================
Well, have fun... I'm of to sleeeeeeeeeeeeeeeeeeeeeeep.
Frans
________________________________
From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Bryan Cantwell
Sent: vrijdag 8 april 2005 20:29
To: The OpenCms mailing list
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?
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/>
More information about the opencms-dev
mailing list