Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: ORA-00942: table or view does not exist

 
sarita rane
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hii ,

I am new to Jforum. I just install Jforum on my machine. I am using oracle database.
But I am getting following error

javax.servlet.ServletException: Servlet.init() for servlet jforum threw exception
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Unknown Source)

root cause

net.jforum.exceptions.ForumStartupException: Error while starting jforum
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
net.jforum.dao.generic.GenericCategoryDAO.selectAll(GenericCategoryDAO.java:104)
net.jforum.repository.ForumRepository.loadCategories(ForumRepository.java:798)
net.jforum.repository.ForumRepository.start(ForumRepository.java:128)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
net.jforum.JForum.init(JForum.java:111)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Unknown Source)

root cause

net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.DatabaseException: java.sql.SQLException: ORA-00942: table or view does not exist

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
net.jforum.dao.generic.GenericCategoryDAO.selectAll(GenericCategoryDAO.java:104)
net.jforum.repository.ForumRepository.loadCategories(ForumRepository.java:798)
net.jforum.repository.ForumRepository.start(ForumRepository.java:128)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
net.jforum.JForum.init(JForum.java:111)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Unknown Source)

root cause

net.jforum.exceptions.DatabaseException: java.sql.SQLException: ORA-00942: table or view does not exist

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
net.jforum.dao.generic.GenericCategoryDAO.selectAll(GenericCategoryDAO.java:104)
net.jforum.repository.ForumRepository.loadCategories(ForumRepository.java:798)
net.jforum.repository.ForumRepository.start(ForumRepository.java:128)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
net.jforum.JForum.init(JForum.java:111)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Unknown Source)

root cause

java.sql.SQLException: ORA-00942: table or view does not exist

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
net.jforum.dao.generic.GenericCategoryDAO.selectAll(GenericCategoryDAO.java:104)
net.jforum.repository.ForumRepository.loadCategories(ForumRepository.java:798)
net.jforum.repository.ForumRepository.start(ForumRepository.java:128)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
net.jforum.JForum.init(JForum.java:111)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Unknown Source)



Please help
 
James Boswell
Bartender
Posts: 1051
5
Chrome Eclipse IDE Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sarita

Although I know little about JForum, your database error indicates that your application is attempting to access a table which does not exist.

As you are using oracle, can you use a separate tool (e.g. SQL Developer) to verify what tables are present?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And that your jforum database user id has access to that table.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic