| 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
|
|
|