Hi,
I plan to use SQL Server 2000 for CMP entity beans.
How can I do
1) Row level locking (SELECT FOR UPDATE) instead of the default Page level locking done by SQL Server 2000 ? What should be EQB-QL or Jboss-QL queries to achieve this ? Or Is there any setting in the database that will do row level locking ?
2) How can I run query like
SELECT TOP 5 * from table using EJB-QL or Jboss-QL ?
The number 5 is dynamic and will be passed as parameter
getRows(int count)
getRows(5)
Thanks in advance.
Regards
Mandar