Hi Andrejus, I've tried set RowCountThreshold like you, but my app is keeping use count on selcet.I'm getting this exception when I try to sroty any column :<05/11/2012 09h55min49s BRST> <2012-11-05 09:55:49.511--UnitOfWork(10194008)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Column "Funcionarios.nome" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.Error Code: 8127Call: SELECT COUNT(id) FROM "Funcionarios" ORDER BY nome DESCQuery: ReportQuery(referenceClass=Funcionarios sql="SELECT COUNT(id) FROM "Funcionarios" ORDER BY nome DESC")> <05/11/2012 09h55min49s BRST> <2012-11-05 09:55:49.542--UnitOfWork(27153634)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Column "Funcionarios.nome" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.Error Code: 8127Call: SELECT COUNT(id) FROM "Funcionarios" ORDER BY nome DESCQuery: ReportQuery(referenceClass=Funcionarios sql="SELECT COUNT(id) FROM "Funcionarios" ORDER BY nome DESC")>
Doar utilizatorii înregistraţi pot adăuga comentarii [ Înregistrare | Logare ]