<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Does this work with Oracle or NOT?</TITLE>
<META content="MSHTML 6.00.2800.1491" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=310062618-08042005><FONT face=Arial color=#0000ff size=2>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:</FONT></SPAN></DIV>
<DIV><SPAN class=310062618-08042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=310062618-08042005><FONT face=Arial color=#0000ff
size=2>33: at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)<BR>32: at
org.opencms.main.CmsShell.exit(CmsShell.java:560)<BR>31: java.lang.NullPointerException<BR>30: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:153)<BR>29: at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:107)<BR>28: at
org.opencms.main.CmsShell.exit(CmsShell.java:554)<BR>27: java.lang.NullPointerException<BR>26: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)<BR>25: at
org.opencms.main.CmsShell.start(CmsShell.java:491)<BR>24: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)<BR>23: at
org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)<BR>22: java.lang.NullPointerException<BR>21: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>20: at
org.opencms.main.CmsShell.<init>(CmsShell.java:448)<BR>19: java.lang.NullPointerException<BR>18: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>17: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>16: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>15: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>14: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>13: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>12: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>11: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>10: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>9: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>8: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>7: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:255)<BR>6: at
org.opencms.db.oracle.CmsUserDriver.getOutputStreamFromBlob(CmsUserDriver.java:342)<BR>5: java.lang.AbstractMethodError:
oracle.sql.BLOB.truncate(J)V<BR>4: Critical error during OpenCms
initialization<BR>3: <BR>2: OpenCms property file:
C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\config\opencms.properties<BR>1: OpenCms
WEB-INF path:
C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\<BR></DIV></FONT></SPAN>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]<B>On
Behalf Of </B>Alexander Kandzior<BR><B>Sent:</B> Thursday, April 07, 2005 4:10
PM<BR><B>To:</B> 'The OpenCms mailing list'<BR><B>Subject:</B> RE:
[opencms-dev] Does this work with Oracle or NOT?<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=383480721-07042005><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Best Regards,<BR>Alex.<BR><BR>Alexander Kandzior<BR>Alkacon
Software - The OpenCms Experts<BR><A
href="http://www.alkacon.com/">http://www.alkacon.com</A><BR><BR></FONT></P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Bryan
Cantwell<BR><B>Sent:</B> Thursday, April 07, 2005 7:23 PM<BR><B>To:</B> The
OpenCms mailing list<BR><B>Subject:</B> RE: [opencms-dev] Does this work
with Oracle or NOT?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=023272017-07042005><FONT face=Arial color=#0000ff
size=2>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")</FONT></SPAN></DIV>
<DIV><SPAN class=023272017-07042005><FONT face=Arial color=#0000ff
size=2> </DIV>
<DIV><BR></DIV></FONT></SPAN>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org]<B>On Behalf Of </B>Alexander
Kandzior<BR><B>Sent:</B> Thursday, April 07, 2005 11:08 AM<BR><B>To:</B>
'The OpenCms mailing list'<BR><B>Subject:</B> RE: [opencms-dev] Does this
work with Oracle or NOT?<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=511320616-07042005><FONT face=Arial
color=#0000ff size=2>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.
</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Best Regards,<BR>Alex.<BR><BR>Alexander
Kandzior<BR>Alkacon Software - The OpenCms Experts<BR><A
href="http://www.alkacon.com/">http://www.alkacon.com</A><BR><BR></FONT></P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Bryan
Cantwell<BR><B>Sent:</B> Thursday, April 07, 2005 5:28 PM<BR><B>To:</B>
The OpenCms mailing list<BR><B>Subject:</B> RE: [opencms-dev] Does this
work with Oracle or NOT?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=076462515-07042005>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:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=076462515-07042005>Should I use the classes12.zip instead or
what?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=076462515-07042005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=076462515-07042005>190: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:148)<BR>189: at
org.opencms.main.CmsShell.start(CmsShell.java:491)<BR>188: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:666)<BR>187: at
org.opencms.main.CmsShell.printPrompt(CmsShell.java:719)<BR>186: java.lang.NullPointerException<BR>185: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>184: at
org.opencms.main.CmsShell.<init>(CmsShell.java:448)<BR>183: java.lang.NullPointerException<BR>182: <BR>181: >> ...
8 more<BR>180: >> at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>179: >> at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>178: >> at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>177: >> at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)<BR>176: >>Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>175: >>query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>173: >> at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>172: >> at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>171: >> at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>170: >> at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>169: >> at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>168: >> at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>167: >> at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>166: >> at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>165: >> at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:548)<BR>164: >>Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>163: >>query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL
Exception]<BR>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<BR>161: >>Root
cause:<BR>160: >>-----------<BR>159: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>158: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>157: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>156: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>155: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>154: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>153: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>152: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)<BR>151: >Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>150: >query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>148: >org.opencms.main.CmsException: Critical error
while initializing org.opencms.db.oracle.CmsUserDriver [Code 33 -
DriverManager init error]<BR>147: >Root
cause:<BR>146: >-----------<BR>145: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>144: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>143: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>142: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:964)<BR>141: <BR>140: Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>139: query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>137: Root cause was: org.opencms.main.CmsException:
Critical error while initializing org.opencms.db.oracle.CmsUserDriver
[Code 33 - DriverManager init
error]<BR>136: org.opencms.main.CmsException: Database init failed
[Code 33 - DriverManager init error]<BR>135: Critical error during
OpenCms initialization<BR>134: <BR>133: > ... 8
more<BR>132: > at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>131: > at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>130: > at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>129: > at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)<BR>128: >Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>127: >query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>125: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>124: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>123: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>122: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>121: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>120: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>119: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>118: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>117: > at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:548)<BR>116: >Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>115: >query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>113: >Root
cause:<BR>112: >-----------<BR>111: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>110: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>109: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>108: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>107: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>106: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>105: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>104: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4555)<BR>103: <BR>102: Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>101: query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>99: org.opencms.main.CmsException: Critical error while
initializing org.opencms.db.oracle.CmsUserDriver [Code 33 -
DriverManager init error]<BR>98: Critical init
error/3<BR>97: ... 8 more<BR>96: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>95: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>94: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>93: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)<BR>92: <BR>91: Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>90: query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>88: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>87: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>86: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>85: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>84: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>83: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>82: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>81: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>80: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:548)<BR>79: <BR>78: Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>77: query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>75: [CmsDriverManager] Critical error while initializing
org.opencms.db.oracle.CmsUserDriver<BR>74: <BR>73: > at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>72: > at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>71: > at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>70: > at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>69: > at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>68: > at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>67: > at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>66: > at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>65: > at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>64: > at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>63: > at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>62: > at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:249)<BR>61: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<BR>60: > at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<BR>59: > at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:387)<BR>58: > at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)<BR>57: > at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2660)<BR>56: > at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2371)<BR>55: > at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:677)<BR>54: > at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)<BR>53: > at
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)<BR>52: > at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)<BR>51: > at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)<BR>50: >java.sql.SQLException:
ORA-00933: SQL command not properly ended<BR>49: >Root
cause:<BR>48: >-----------<BR>47: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>46: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>45: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>44: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>43: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>42: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>41: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>40: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>39: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>38: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>37: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>36: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:277)<BR>35: <BR>34: Root
cause was: java.sql.SQLException: ORA-00933: SQL command not properly
ended<BR>33: query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A>
[Code 301 - SQL Exception]<BR>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<BR>31: Initialization of default users and groups
failed<BR>30: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)<BR>29: at
org.opencms.main.CmsShell.<init>(CmsShell.java:445)<BR>28: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1407)<BR>27: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:958)<BR>26: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:131)<BR>25: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2270)<BR>24: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:431)<BR>23: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4543)<BR>22: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:542)<BR>21: at
org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1413)<BR>20: at
org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:148)<BR>19: at
org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:249)<BR>18: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<BR>17: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<BR>16: at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:387)<BR>15: at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)<BR>14: at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2660)<BR>13: at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2371)<BR>12: at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:677)<BR>11: at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)<BR>10: at
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)<BR>9: at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)<BR>8: at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)<BR>7: <BR>6: java.sql.SQLException:
ORA-00933: SQL command not properly ended<BR>5: query: <A
href="mailto:oracle.jdbc.driver.OraclePreparedStatement@1cdc190">oracle.jdbc.driver.OraclePreparedStatement@1cdc190</A><BR>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<BR>3: <BR>2: OpenCms property file:
C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\config\opencms.properties<BR>1: OpenCms
WEB-INF path:
C:\OraHome1\j2ee\OC4J_WEB\applications\opencms\opencms\WEB-INF\<BR></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org]<B>On Behalf Of </B>Alexander
Kandzior<BR><B>Sent:</B> Thursday, April 07, 2005 1:40
AM<BR><B>To:</B> 'The OpenCms mailing list'<BR><B>Subject:</B> RE:
[opencms-dev] Does this work with Oracle or NOT?<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=246393706-07042005><FONT
face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Best Regards,<BR>Alex.<BR><BR>Alexander
Kandzior<BR>Alkacon Software - The OpenCms Experts<BR><A
href="http://www.alkacon.com/">http://www.alkacon.com</A><BR><BR></FONT></P>
<DIV><FONT face=Arial color=#0000ff
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>