[opencms-dev] tomcat 4/5 + Oracle 8 + Solaris

lanhao kylinlan at 163.com
Thu Jan 27 04:07:21 CET 2005


look at
http://mail.opencms.org/pipermail/opencms-dev/2005q1/014620.html
  ----- Original Message ----- 
  From: Robin Antony 
  To: opencms-dev at opencms.org 
  Sent: Thursday, January 27, 2005 10:27 AM
  Subject: [opencms-dev] tomcat 4/5 + Oracle 8 + Solaris


  Hi,

   I am running the latest version of opencms 6.0 alpha 3 on Solaris and connecting to Oracle 8. I run the setup wizard 

  and finally it comes to this page for importing the workplace. This is the exception that gets thrown. I have been on this for several days now with no use.

  On opencms version 5 it just hangs when it reaches the import workplace. Can someone please help me with this. Any hints or pointers? 

   

  Best Regards,

  Robin Antony

   

   

  192:      java.lang.NullPointerException

  191:                  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  190:                  at org.opencms.main.CmsShell.<init>(CmsShell.java:448)

  189:      java.lang.NullPointerException

  188:      

  187:      >>        ... 8 more

  186:      >>        at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)

  185:      >>        at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1400)

  184:      >>        at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)

  183:      >>        at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:266)

  182:      >>        at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:295)

  181:      >>Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  180:      >> [Code 4 - Sql exception]

  179:      >>Caused by: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  178:      >>        at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  177:      >>        at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  176:      >>        at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  175:      >>        at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  174:      >>        at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  173:      >>        at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  172:      >>        at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  171:      >>        at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4457)

  170:      >>        at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:535)

  169:      >>Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  168:      >> [Code 4 - Sql exception]

  167:      >>java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  166:      >>Root cause:

  165:      >>-----------

  164:      >          at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  163:      >          at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  162:      >          at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  161:      >          at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  160:      >          at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  159:      >          at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  158:      >          at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  157:      >          at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4469)

  156:      >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  155:      > [Code 4 - Sql exception]

  154:      >Root cause was: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  153:      >org.opencms.main.CmsException: Critical error while initializing org.opencms.db.oracle.CmsUserDriver [Code 33 - DriverManager init error]

  152:      >Root cause:

  151:      >-----------

  150:                  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  149:                  at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  148:                  at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  147:                  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1041)

  146:      

  145:      Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  144:      [Code 4 - Sql exception]

  143:      Root cause was: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  142:      Root cause was: org.opencms.main.CmsException: Critical error while initializing org.opencms.db.oracle.CmsUserDriver [Code 33 - DriverManager init error]

  141:      org.opencms.main.CmsException: Database init failed [Code 33 - DriverManager init error]

  140:      Critical error during OpenCms initialization

  139:      

  138:      >          ... 8 more

  137:      >          at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)

  136:      >          at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1400)

  135:      >          at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)

  134:      >          at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:266)

  133:      >          at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:295)

  132:      >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  131:      > [Code 4 - Sql exception]

  130:      >Caused by: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  129:      >          at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  128:      >          at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  127:      >          at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  126:      >          at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  125:      >          at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  124:      >          at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  123:      >          at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  122:      >          at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4457)

  121:      >          at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:535)

  120:      >Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  119:      > [Code 4 - Sql exception]

  118:      >java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  117:      >Root cause:

  116:      >-----------

  115:                  at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  114:                  at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  113:                  at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  112:                  at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  111:                  at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  110:                  at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  109:                  at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  108:                  at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4469)

  107:      

  106:      Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  105:      [Code 4 - Sql exception]

  104:      Root cause was: java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  103:      org.opencms.main.CmsException: Critical error while initializing org.opencms.db.oracle.CmsUserDriver [Code 33 - DriverManager init error]

  102:      Critical init error/3

  101:                  ... 8 more

  100:                  at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)

  99:                    at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1400)

  98:                    at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)

  97:                    at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:266)

  96:                    at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:295)

  95:        

  94:        Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  93:        [Code 4 - Sql exception]

  92:        Caused by: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  91:                    at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  90:                    at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  89:                    at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  88:                    at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  87:                    at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  86:                    at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  85:                    at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  84:                    at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4457)

  83:                    at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:535)

  82:        

  81:        Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  80:        [Code 4 - Sql exception]

  79:        java.lang.RuntimeException: org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  78:        [CmsDriverManager] Critical error while initializing org.opencms.db.oracle.CmsUserDriver

  77:        

  76:        >          at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  75:        >          at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  74:        >          at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  73:        >          at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  72:        >          at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  71:        >          at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  70:        >          at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  69:        >          at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4457)

  68:        >          at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)

  67:        >          at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1400)

  66:        >          at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)

  65:        >          at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)

  64:        >          at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

  63:        >          at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

  62:        >          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)

  61:        >          at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)

  60:        >          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)

  59:        >          at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)

  58:        >          at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)

  57:        >          at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)

  56:        >          at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)

  55:        >          at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)

  54:        >          at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)

  53:        >          at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)

  52:        >java.sql.SQLException: ORA-00933: SQL command not properly ended

  51:        >Root cause:

  50:        >-----------

  49:                    at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  48:                    at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  47:                    at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  46:                    at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  45:                    at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  44:                    at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  43:                    at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  42:                    at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4457)

  41:                    at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)

  40:                    at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1400)

  39:                    at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)

  38:                    at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:266)

  37:                    at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:295)

  36:        

  35:        Root cause was: java.sql.SQLException: ORA-00933: SQL command not properly ended

  34:        [Code 4 - Sql exception]

  33:        org.opencms.main.CmsException: [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  32:        Initialization of default users and groups failed

  31:                    at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:142)

  30:                    at org.opencms.main.CmsShell.<init>(CmsShell.java:445)

  29:                    at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1371)

  28:                    at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1035)

  27:                    at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:130)

  26:                    at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2227)

  25:                    at org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:417)

  24:                    at org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4457)

  23:                    at org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:529)

  22:                    at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultUsersAndGroups(CmsUserDriver.java:1400)

  21:                    at org.opencms.db.oracle.CmsUserDriver.importUser(CmsUserDriver.java:144)

  20:                    at org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238)

  19:                    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

  18:                    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

  17:                    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)

  16:                    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)

  15:                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)

  14:                    at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)

  13:                    at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)

  12:                    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)

  11:                    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)

  10:                    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)

  9:                     at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)

  8:                     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)

  7:         

  6:         java.sql.SQLException: ORA-00933: SQL command not properly ended

  5:         

  4:         [org.opencms.db.oracle.CmsUserDriver] [internalWriteUserInfo id=9d621efd-c454-39a9-a475-bd1f828bb103] where: org.opencms.db.oracle.CmsUserDriver.internalWriteUserInfo(CmsUserDriver.java:238), why: java.sql.SQLException: ORA-00933: SQL command not properly ended

  3:         

  2:         OpenCms property file: /opt/zed/jakarta-tomcat-5.0.28/webapps/opencms/WEB-INF/config/opencms.properties

  1:         OpenCms WEB-INF path:  /opt/zed/jakarta-tomcat-5.0.28/webapps/opencms/WEB-INF/



------------------------------------------------------------------------------




  _______________________________________________
  This mail is send to you from the opencms-dev mailing list
  To change your list options, or to unsubscribe from the list, please visit
  http://mail.opencms.org/mailman/listinfo/opencms-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050127/4c5eb9fe/attachment.htm>


More information about the opencms-dev mailing list