GeeCON Prague 2014*
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


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: RSS button throws java.sql.SQLException error