users@glassfish.java.net

How to use COUNT(1) in jpa or toplink essentials...?

From: <glassfish_at_javadesktop.org>
Date: Mon, 08 Oct 2007 08:33:00 PDT

Hi All,

I have a requirement to use count(1) for validating codes used in the application. so i want to execute something like:

select COUNT(1) from...where ...='...'

we are using "count(object)" currently but this is not recommended for the production environment due to performance issues in the query..

Any help will be greatly appreciated.

Regards,
Sarvesh
[Message sent by forum member 'sarveshsh' (sarveshsh)]

http://forums.java.net/jive/thread.jspa?messageID=238960