*
The moose likes JForum and the fly likes java.sql.SQLException: ORA-00942: table or view does not exist Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "java.sql.SQLException: ORA-00942: table or view does not exist" Watch "java.sql.SQLException: ORA-00942: table or view does not exist" New topic
Author

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

sarita rane
Greenhorn

Joined: May 26, 2011
Posts: 4
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

Joined: Nov 09, 2011
Posts: 1012
    
    5

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30136
    
150

And that your jforum database user id has access to that table.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: ORA-00942: table or view does not exist
 
Similar Threads
JForum and Oracle 8i Standard Edition
select with an "in" clause...
RSS button throws java.sql.SQLException error
cursors and sql error
i have a problem when i modify server.xml