It's ok... found the fix in BrokerHelper.java in cvs. Daniel.
-----Original Message----- From: Daniel Perry [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 12:35 To: OJB Users List Subject: collection proxy gives sql error sorry... not sure why i replied then... monday morning... Upgraded to RC6, and everything seemed to be fine..... until now :) One bit of code (that grabs a list - proxied collection) causes some nasty sql errors. Upon calling the .size() method it generates some sql (I'll hazard a guess of a COUNT query) without a group by statement. I seem to remember someone pointing this out before, but cant find the message.... Is there an easy fix? Daniel. [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during th e execution of the query (for a com.netcase.pdp.bo.KSFNos): General error, mess age from server: "Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause" General error, message from server: "Mixing of GROUP columns (MIN(),MAX(),COUNT ()...) with no GROUP columns is illegal if there is no GROUP BY clause" java.sql.SQLException: General error, message from server: "Mixing of GROUP col umns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GR OUP BY clause" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.Connection.execSQL(Connection.java:2051) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1496) 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 org.apache.ojb.broker.accesslayer.CollectionProxy.loadSize(Collection Proxy.java:83) at org.apache.ojb.broker.accesslayer.CollectionProxy.size(CollectionProx y.java:164) at com.netcase.pdp.service.KSFDataService.deletePostOutlines(KSFDataServ ice.java:343) at com.netcase.pdp.connect.soap.SoapKSFImporter.importKSF(SoapKSFImporte r.java:63) at com.netcase.pdp.connect.soap.SoapKSFImporter.main(SoapKSFImporter.jav a:44) Exception in thread "main" org.apache.ojb.broker.PersistenceBrokerException: org .apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException: General error, message from server: "Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause" at org.apache.ojb.broker.accesslayer.CollectionProxy.loadSize(Collection Proxy.java:87) at org.apache.ojb.broker.accesslayer.CollectionProxy.size(CollectionProx y.java:164) at com.netcase.pdp.service.KSFDataService.deletePostOutlines(KSFDataServ ice.java:343) at com.netcase.pdp.connect.soap.SoapKSFImporter.importKSF(SoapKSFImporte r.java:63) at com.netcase.pdp.connect.soap.SoapKSFImporter.main(SoapKSFImporter.jav a:44) Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLExce ption: General error, message from server: "Mixing of GROUP columns (MIN(),MAX( ),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause" 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 org.apache.ojb.broker.accesslayer.CollectionProxy.loadSize(Collection Proxy.java:83) ... 4 more Caused by: java.sql.SQLException: General error, message from server: "Mixing o f GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if the re is no GROUP BY clause" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.Connection.execSQL(Connection.java:2051) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1496) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcc essImpl.java:282) ... 15 more --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
