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)