[Opensource] RE: Expresso Oracle 4.02 and Oracle Frustration
McBrayer, Roy
Roy.McBrayer at mail.va.gov
Fri Sep 13 12:54:07 PDT 2002
Here is the trace from my log file (see below dashed line). The actual
error on the web page is
Root Cause:
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
CREATE TABLE EVENT(Event CHAR(30) not null, Descrip varchar2(4000)(80) not
null)(com.jcorporate.expresso.core.ExpressoSchema.createTable(), db/context
'default'):ORA-00907: missing right parenthesis
The complete web page trace is below the log file trace.
Thanks,
Roy
----------------------------------------------------------------------------
2002-09-13 14:36:45,828 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.dbInitialize(ConfigManager.
java:234)) - DB connection testing disabled
2002-09-13 14:36:45,828 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.dbInitialize(ConfigManager.
java:244)) - All connection pools initialized
2002-09-13 14:36:45,828 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.mapOtherDBs(ConfigManager.j
ava:1099)) - Reading DBObject mappings to other databases, context
'default'...
2002-09-13 14:36:47,812 ERROR [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.mapOtherDBs(ConfigManager.j
ava:1120)) - Unable to read database mapping entries for context 'default'
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT DBConnName, DBObjName, Descrip FROM DBOTHERMAP
(com.jcorporate.expresso.services.dbobj.DBOtherMap, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBObject.j
ava:4469)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveList(Sec
uredDBObject.java:533)
at
com.jcorporate.expresso.core.misc.ConfigManager.mapOtherDBs(ConfigManager.ja
va:1106)
at
com.jcorporate.expresso.core.misc.ConfigManager.load(ConfigManager.java:946)
at
com.jcorporate.expresso.core.misc.ConfigManager.config(ConfigManager.java:89
7)
at
com.jcorporate.expresso.core.servlet.StdServlet.init(StdServlet.java:303)
at
com.jcorporate.expresso.core.servlet.DBServlet.init(DBServlet.java:70)
at
com.jcorporate.expresso.core.servlet.InitServlet.init(InitServlet.java:125)
at
com.jcorporate.expresso.core.servlet.DefaultInit.init(DefaultInit.java:50)
at org.apache.catalina.core.StandardWrapper.load(Unknown Source)
at org.apache.catalina.core.StandardContext.loadOnStartup(Unknown
Source)
at org.apache.catalina.core.StandardContext.start(Unknown Source)
at org.apache.catalina.core.ContainerBase.addChild(Unknown Source)
at org.apache.catalina.core.StandardHost.addChild(Unknown Source)
at org.apache.catalina.core.StandardHost.install(Unknown Source)
at org.apache.catalina.startup.HostConfig.deployApps(Unknown Source)
at org.apache.catalina.startup.HostConfig.start(Unknown Source)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(Unknown
Source)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Unknown Source)
at org.apache.catalina.core.ContainerBase.start(Unknown Source)
at org.apache.catalina.core.ContainerBase.start(Unknown Source)
at org.apache.catalina.core.StandardEngine.start(Unknown Source)
at org.apache.catalina.core.StandardService.start(Unknown Source)
at org.apache.catalina.core.StandardServer.start(Unknown Source)
at org.apache.catalina.startup.Catalina.start(Unknown Source)
at org.apache.catalina.startup.Catalina.execute(Unknown Source)
at org.apache.catalina.startup.Catalina.process(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Unknown Source)
2002-09-13 14:36:47,828 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.load(ConfigManager.java:949
)) - Reading setup values
2002-09-13 14:36:47,921 ERROR [main] dbobj.Setup
(com.jcorporate.expresso.services.dbobj.Setup.readSetups(Setup.java:436)) -
WARNING: Unable to read setup values for db 'default'
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT SetupValue, SchemaClass, SetupCode, Descrip FROM SETUP
(com.jcorporate.expresso.services.dbobj.Setup, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBObject.j
ava:4469)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveList(Sec
uredDBObject.java:533)
at
com.jcorporate.expresso.services.dbobj.Setup.readSetups(Setup.java:388)
at
com.jcorporate.expresso.services.dbobj.Setup.readSetups(Setup.java:463)
at
com.jcorporate.expresso.core.misc.ConfigManager.load(ConfigManager.java:950)
at
com.jcorporate.expresso.core.misc.ConfigManager.config(ConfigManager.java:89
7)
at
com.jcorporate.expresso.core.servlet.StdServlet.init(StdServlet.java:303)
at
com.jcorporate.expresso.core.servlet.DBServlet.init(DBServlet.java:70)
at
com.jcorporate.expresso.core.servlet.InitServlet.init(InitServlet.java:125)
at
com.jcorporate.expresso.core.servlet.DefaultInit.init(DefaultInit.java:50)
at org.apache.catalina.core.StandardWrapper.load(Unknown Source)
at org.apache.catalina.core.StandardContext.loadOnStartup(Unknown
Source)
at org.apache.catalina.core.StandardContext.start(Unknown Source)
at org.apache.catalina.core.ContainerBase.addChild(Unknown Source)
at org.apache.catalina.core.StandardHost.addChild(Unknown Source)
at org.apache.catalina.core.StandardHost.install(Unknown Source)
at org.apache.catalina.startup.HostConfig.deployApps(Unknown Source)
at org.apache.catalina.startup.HostConfig.start(Unknown Source)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(Unknown
Source)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Unknown Source)
at org.apache.catalina.core.ContainerBase.start(Unknown Source)
at org.apache.catalina.core.ContainerBase.start(Unknown Source)
at org.apache.catalina.core.StandardEngine.start(Unknown Source)
at org.apache.catalina.core.StandardService.start(Unknown Source)
at org.apache.catalina.core.StandardServer.start(Unknown Source)
at org.apache.catalina.startup.Catalina.start(Unknown Source)
at org.apache.catalina.startup.Catalina.execute(Unknown Source)
at org.apache.catalina.startup.Catalina.process(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Unknown Source)
2002-09-13 14:36:47,921 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.load(ConfigManager.java:953
)) - Starting job handler(s)
2002-09-13 14:36:47,921 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.startJobHandler(ConfigManag
er.java:720)) - Starting job handler(s)
2002-09-13 14:36:47,921 WARN [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.startJobHandler(ConfigManag
er.java:731)) - Job handler for configuration 'default' not enabled.
2002-09-13 14:36:47,921 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.startJobHandler(ConfigManag
er.java:759)) - All job handlers started
2002-09-13 14:36:47,921 INFO [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.load(ConfigManager.java:956
)) - Expresso initialization complete
2002-09-13 14:37:13,796 ERROR [HttpProcessor[8088][4]] dbobj.DBObject
(com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4702
)) - Database exception setting cache size - using zero
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT CacheSize, PageLimit, DBObjectName FROM DBOBJLIMIT WHERE DBObjectName
= 'com.jcorporate.expresso.services.dbobj.DefaultUserInfo'
(com.jcorporate.expresso.services.dbobj.DBObjLimit, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieve(DBObject.java:4004)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.retrieve(SecuredDBObject.
java:492)
at
com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4687)
at
com.jcorporate.expresso.core.dbobj.DBObject.getCacheSize(DBObject.java:1926)
at
com.jcorporate.expresso.core.dbobj.DBObject.isCached(DBObject.java:3306)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieveFromCache(DBObject.java:
4092)
at
com.jcorporate.expresso.core.dbobj.DBObject.find(DBObject.java:1563)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.find(SecuredDBObject.java
:294)
at com.jcorporate.expresso.core.security.User.find(User.java:207)
at
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckLogin.ja
va:292)
at
com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:168)
at
com.jcorporate.expresso.core.servlet.CheckLogin.<init>(CheckLogin.java:102)
at org.apache.jsp.frame$jsp._jspService(frame$jsp.java:174)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
2002-09-13 14:37:13,812 ERROR [HttpProcessor[8088][4]] servlet.CheckLogin
(com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:175))
- com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT RegDomId, UpdateDate, Passwd, EmailValCode, UserName, RegComplete,
LoginName, CreateDate, AccountStatus, EMail, ExpUid FROM USERS WHERE
LoginName = 'Admin' (com.jcorporate.expresso.services.dbobj.DefaultUserInfo,
db/context 'default'):ORA-00942: table or view does not exist
2002-09-13 14:37:14,015 ERROR [HttpProcessor[8088][4]] dbobj.DBObject
(com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4702
)) - Database exception setting cache size - using zero
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT CacheSize, PageLimit, DBObjectName FROM DBOBJLIMIT WHERE DBObjectName
= 'com.jcorporate.expresso.services.dbobj.DefaultUserInfo'
(com.jcorporate.expresso.services.dbobj.DBObjLimit, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieve(DBObject.java:4004)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.retrieve(SecuredDBObject.
java:492)
at
com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4687)
at
com.jcorporate.expresso.core.dbobj.DBObject.getCacheSize(DBObject.java:1926)
at
com.jcorporate.expresso.core.dbobj.DBObject.isCached(DBObject.java:3306)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieveFromCache(DBObject.java:
4092)
at
com.jcorporate.expresso.core.dbobj.DBObject.find(DBObject.java:1563)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.find(SecuredDBObject.java
:294)
at com.jcorporate.expresso.core.security.User.find(User.java:207)
at
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckLogin.ja
va:292)
at
com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:168)
at
com.jcorporate.expresso.core.servlet.CheckLogin.<init>(CheckLogin.java:102)
at org.apache.jsp.header$jsp._jspService(header$jsp.java:160)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
2002-09-13 14:37:14,031 ERROR [HttpProcessor[8088][4]] servlet.CheckLogin
(com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:175))
- com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT RegDomId, UpdateDate, Passwd, EmailValCode, UserName, RegComplete,
LoginName, CreateDate, AccountStatus, EMail, ExpUid FROM USERS WHERE
LoginName = 'Admin' (com.jcorporate.expresso.services.dbobj.DefaultUserInfo,
db/context 'default'):ORA-00942: table or view does not exist
2002-09-13 14:37:14,078 ERROR [HttpProcessor[8088][3]] dbobj.DBObject
(com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4702
)) - Database exception setting cache size - using zero
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT CacheSize, PageLimit, DBObjectName FROM DBOBJLIMIT WHERE DBObjectName
= 'com.jcorporate.expresso.services.dbobj.DefaultUserInfo'
(com.jcorporate.expresso.services.dbobj.DBObjLimit, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieve(DBObject.java:4004)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.retrieve(SecuredDBObject.
java:492)
at
com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4687)
at
com.jcorporate.expresso.core.dbobj.DBObject.getCacheSize(DBObject.java:1926)
at
com.jcorporate.expresso.core.dbobj.DBObject.isCached(DBObject.java:3306)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieveFromCache(DBObject.java:
4092)
at
com.jcorporate.expresso.core.dbobj.DBObject.find(DBObject.java:1563)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.find(SecuredDBObject.java
:294)
at com.jcorporate.expresso.core.security.User.find(User.java:207)
at
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckLogin.ja
va:292)
at
com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:168)
at
com.jcorporate.expresso.core.servlet.CheckLogin.<init>(CheckLogin.java:102)
at org.apache.jsp.toc$jsp._jspService(toc$jsp.java:154)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
2002-09-13 14:37:14,093 ERROR [HttpProcessor[8088][3]] servlet.CheckLogin
(com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:175))
- com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT RegDomId, UpdateDate, Passwd, EmailValCode, UserName, RegComplete,
LoginName, CreateDate, AccountStatus, EMail, ExpUid FROM USERS WHERE
LoginName = 'Admin' (com.jcorporate.expresso.services.dbobj.DefaultUserInfo,
db/context 'default'):ORA-00942: table or view does not exist
2002-09-13 14:37:14,843 ERROR [HttpProcessor[8088][4]] dbobj.DBObject
(com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4702
)) - Database exception setting cache size - using zero
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT CacheSize, PageLimit, DBObjectName FROM DBOBJLIMIT WHERE DBObjectName
= 'com.jcorporate.expresso.services.dbobj.DefaultUserInfo'
(com.jcorporate.expresso.services.dbobj.DBObjLimit, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieve(DBObject.java:4004)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.retrieve(SecuredDBObject.
java:492)
at
com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4687)
at
com.jcorporate.expresso.core.dbobj.DBObject.getCacheSize(DBObject.java:1926)
at
com.jcorporate.expresso.core.dbobj.DBObject.isCached(DBObject.java:3306)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieveFromCache(DBObject.java:
4092)
at
com.jcorporate.expresso.core.dbobj.DBObject.find(DBObject.java:1563)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.find(SecuredDBObject.java
:294)
at com.jcorporate.expresso.core.security.User.find(User.java:207)
at
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckLogin.ja
va:292)
at
com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:168)
at
com.jcorporate.expresso.core.servlet.CheckLogin.<init>(CheckLogin.java:102)
at org.apache.jsp.main$jsp._jspService(main$jsp.java:195)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
2002-09-13 14:37:14,859 ERROR [HttpProcessor[8088][4]] servlet.CheckLogin
(com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:175))
- com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT RegDomId, UpdateDate, Passwd, EmailValCode, UserName, RegComplete,
LoginName, CreateDate, AccountStatus, EMail, ExpUid FROM USERS WHERE
LoginName = 'Admin' (com.jcorporate.expresso.services.dbobj.DefaultUserInfo,
db/context 'default'):ORA-00942: table or view does not exist
2002-09-13 14:37:17,515 ERROR [HttpProcessor[8088][4]] dbobj.DBObject
(com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4702
)) - Database exception setting cache size - using zero
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT CacheSize, PageLimit, DBObjectName FROM DBOBJLIMIT WHERE DBObjectName
= 'com.jcorporate.expresso.services.dbobj.DefaultUserInfo'
(com.jcorporate.expresso.services.dbobj.DBObjLimit, db/context
'default'):ORA-00942: table or view does not exist
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:511)
at
com.jcorporate.expresso.core.db.DBConnection.execute(DBConnection.java:530)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieve(DBObject.java:4004)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.retrieve(SecuredDBObject.
java:492)
at
com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:4687)
at
com.jcorporate.expresso.core.dbobj.DBObject.getCacheSize(DBObject.java:1926)
at
com.jcorporate.expresso.core.dbobj.DBObject.isCached(DBObject.java:3306)
at
com.jcorporate.expresso.core.dbobj.DBObject.retrieveFromCache(DBObject.java:
4092)
at
com.jcorporate.expresso.core.dbobj.DBObject.find(DBObject.java:1563)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.find(SecuredDBObject.java
:294)
at com.jcorporate.expresso.core.security.User.find(User.java:207)
at
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckLogin.ja
va:292)
at
com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:168)
at
com.jcorporate.expresso.core.servlet.CheckLogin.<init>(CheckLogin.java:102)
at org.apache.jsp.setup$jsp._jspService(setup$jsp.java:239)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
2002-09-13 14:37:17,531 ERROR [HttpProcessor[8088][4]] servlet.CheckLogin
(com.jcorporate.expresso.core.servlet.CheckLogin.init(CheckLogin.java:175))
- com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT RegDomId, UpdateDate, Passwd, EmailValCode, UserName, RegComplete,
LoginName, CreateDate, AccountStatus, EMail, ExpUid FROM USERS WHERE
LoginName = 'Admin' (com.jcorporate.expresso.services.dbobj.DefaultUserInfo,
db/context 'default'):ORA-00942: table or view does not exist
2002-09-13 14:37:20,171 WARN [HttpProcessor[8088][3]] html.Page
(com.jcorporate.expresso.services.html.Page.display(Page.java:146)) -
com.jcorporate.expresso.services.html.Page.display(PrintWriter):Cannot
determine stylesheet location
com.jcorporate.expresso.core.db.DBException: No Setup Value 'ContextPath'
for default schema, db 'default' Table does not yet exist
at
com.jcorporate.expresso.services.dbobj.Setup.getValueRequired(Setup.java:249
)
at com.jcorporate.expresso.services.html.Page.display(Page.java:141)
at com.jcorporate.expresso.services.html.Page.display(Page.java:88)
at
com.jcorporate.expresso.services.servlet.DBCreate.doGet(DBCreate.java:179)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
2002-09-13 14:37:23,140 INFO [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:463))
- Verifying table EVENT
2002-09-13 14:37:23,140 WARN [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:469))
- com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
SELECT COUNT(*) FROM EVENT (com.jcorporate.expresso.services.dbobj.Event,
db/context 'default'):ORA-00942: table or view does not exist
2002-09-13 14:37:23,156 INFO [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:471))
- Table for object com.jcorporate.expresso.services.dbobj.Event did not
exist in db 'default' - creating
2002-09-13 14:37:23,281 WARN [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.initializeMaps(Schema.java:1283))
- Unable to map java.sql.Types value -104 to a string. The database may
have returned an invalid type map. New type being added...
2002-09-13 14:37:23,281 WARN [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.initializeMaps(Schema.java:1283))
- Unable to map java.sql.Types value -103 to a string. The database may
have returned an invalid type map. New type being added...
2002-09-13 14:37:23,281 WARN [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.initializeMaps(Schema.java:1283))
- Unable to map java.sql.Types value -102 to a string. The database may
have returned an invalid type map. New type being added...
2002-09-13 14:37:23,281 WARN [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.initializeMaps(Schema.java:1283))
- Unable to map java.sql.Types value -101 to a string. The database may
have returned an invalid type map. New type being added...
2002-09-13 14:37:23,296 INFO [HttpProcessor[8088][4]] dbobj.Schema
(com.jcorporate.expresso.core.dbobj.Schema.createTable(Schema.java:1038)) -
Running Create:CREATE TABLE EVENT(Event CHAR(30) not null, Descrip
varchar2(4000)(80) not null)
----------------------------------------------------------------------------
-------------------------------------------------------------
WEb page error
A Servlet Exception Has Occurred
Exception Report:
javax.servlet.ServletException: Unable to execute statement: CREATE TABLE
EVENT(Event CHAR(30) not null, Descrip varchar2(4000)(80) not
null)(com.jcorporate.expresso.core.ExpressoSchema.createTable(), db/context
'default'):ORA-00907: missing right parenthesis
at
com.jcorporate.expresso.core.servlet.StdServlet.showError(StdServlet.java:28
0)
at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:325)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
Root Cause:
com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
CREATE TABLE EVENT(Event CHAR(30) not null, Descrip varchar2(4000)(80) not
null)(com.jcorporate.expresso.core.ExpressoSchema.createTable(), db/context
'default'):ORA-00907: missing right parenthesis
at
com.jcorporate.expresso.core.db.DBConnection.executeUpdate(DBConnection.java
:597)
at
com.jcorporate.expresso.core.dbobj.Schema.createTable(Schema.java:1039)
at
com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:474)
at
com.jcorporate.expresso.core.utility.DBTool.createTables(DBTool.java:1896)
at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:298)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:479)
More information about the Opensource
mailing list