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]
