wood burning stoves 2.0*
The moose likes JForum and the fly likes RSS button throws java.sql.SQLException error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "RSS button throws java.sql.SQLException error" Watch "RSS button throws java.sql.SQLException error" New topic
Author

RSS button throws java.sql.SQLException error

Fua Moua
Greenhorn

Joined: Apr 11, 2011
Posts: 5
Clicking on a RSS feed button for a main topic throws the below error.

java.sql.SQLException: ORA-00936: missing expression

Below is the detail error.
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at net.jforum.dao.generic.GenericPostDAO.selectLatestByForumForRSS(GenericPostDAO.java:496)
at net.jforum.view.forum.RSSAction.forumTopics(RSSAction.java:88)
... 24 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

... 36 more

URL is: /thermoforum/rss/forumTopics/207.page?null

I saw in post that it was missing the \ in the query and they suggested the below change.
Now I get a different error and I can't figure out why.

java.sql.SQLException: ORA-00903: invalid table name

Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: ORA-00903: invalid table name

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at net.jforum.dao.generic.GenericPostDAO.selectLatestByForumForRSS(GenericPostDAO.java:496)
at net.jforum.view.forum.RSSAction.forumTopics(RSSAction.java:88)
... 24 more
Caused by: java.sql.SQLException: ORA-00903: invalid table name

... 36 more

URL is: /thermoforum/rss/forumTopics/207.page?null


 
 
subject: RSS button throws java.sql.SQLException error
 
Similar Threads
SQL Exception when trying to view RSS feeds
select with an "in" clause...
RSS of latest entries
some problem about Oracle upgrade script
Error accessing RSS links using Oracle