You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Pothakamury, Uday" <ud...@citigroup.com> on 2004/06/08 22:46:01 UTC
[Bug] RC6 seems to be producing invalid SQL for Oracle when u sing ReportQuerys
Dear folks,
This is the error that I am encountering when I upgraded an application from rc4 to rc6.
I read the posts which say that there is a fix available. Kindly let me know how the fix
can be applied in my situation. I appreciate any help.
Here is the error dump:--
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during th
e execution of the query (for a com.city.grants.data.Grant): ORA-00937: not a si
ngle-group group function
ORA-00937: not a single-group group function
java.sql.SQLException: ORA-00937: not a single-group group function
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:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcc
essImpl.java:282)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryO
bject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:1
83)
at org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Report
QueryRsIterator.java:43)
at org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterat
or(ReportRsIteratorFactoryImpl.java:59)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQue
ry(PersistenceBrokerImpl.java:1780)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIterat
orFromQuery(PersistenceBrokerImpl.java:1827)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIterat
orByQuery(PersistenceBrokerImpl.java:1755)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCount(Persistence
BrokerImpl.java:1726)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Deleg
atingPersistenceBroker.java:326)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Deleg
atingPersistenceBroker.java:326)
at com.city.grants.dao.SearchByQueryDAO.searchGrants(SearchByQueryDAO.ja
va:119)
at com.city.grants.delegate.SearchDelegate.searchGrants(SearchDelegate.j
ava:22)
at com.city.grants.action.AdminSearchAction.processRequest(AdminSearchAc
tion.java:79)
at com.city.grants.action.GrantCoreAction.perform(GrantCoreAction.java:2
1)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionSer
vlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:158
6)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:
252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:
527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.j
ava:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
java.sql.SQLException: ORA-00937: not a single-group group function
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:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcc
essImpl.java:282)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryO
bject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:1
83)
at org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Report
QueryRsIterator.java:43)
at org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterat
or(ReportRsIteratorFactoryImpl.java:59)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQue
ry(PersistenceBrokerImpl.java:1780)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIterat
orFromQuery(PersistenceBrokerImpl.java:1827)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIterat
orByQuery(PersistenceBrokerImpl.java:1755)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCount(Persistence
BrokerImpl.java:1726)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Deleg
atingPersistenceBroker.java:326)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Deleg
atingPersistenceBroker.java:326)
at com.city.grants.dao.SearchByQueryDAO.searchGrants(SearchByQueryDAO.ja
va:119)
at com.city.grants.delegate.SearchDelegate.searchGrants(SearchDelegate.j
ava:22)
at com.city.grants.action.AdminSearchAction.processRequest(AdminSearchAc
tion.java:79)
at com.city.grants.action.GrantCoreAction.perform(GrantCoreAction.java:2
1)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionSer
vlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:158
6)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:
252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:
527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.j
ava:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: ORA-00937: not
a single-group group function
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcc
essImpl.java:317)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryO
bject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:1
83)
at org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Report
QueryRsIterator.java:43)
at org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterat
or(ReportRsIteratorFactoryImpl.java:59)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQue
ry(PersistenceBrokerImpl.java:1780)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIterat
orFromQuery(PersistenceBrokerImpl.java:1827)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIterat
orByQuery(PersistenceBrokerImpl.java:1755)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCount(Persistence
BrokerImpl.java:1726)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Deleg
atingPersistenceBroker.java:326)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Deleg
atingPersistenceBroker.java:326)
at com.city.grants.dao.SearchByQueryDAO.searchGrants(SearchByQueryDAO.ja
va:119)
at com.city.grants.delegate.SearchDelegate.searchGrants(SearchDelegate.j
ava:22)
at com.city.grants.action.AdminSearchAction.processRequest(AdminSearchAc
tion.java:79)
at com.city.grants.action.GrantCoreAction.perform(GrantCoreAction.java:2
1)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionSer
vlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:158
6)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:
252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:
527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.j
ava:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Caused by: java.sql.SQLException: ORA-00937: not a single-group group function
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:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcc
essImpl.java:282)
... 26 more
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org