0 Replies Latest reply on Jan 10, 2004 10:52 AM by mandar

    Question about CMP using SQL Server

    mandar Newbie

      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)

      Thanks in advance.