0 Replies Latest reply on Aug 25, 2006 7:09 PM by billewicz

    SELECT .. FOR UPDATE

    billewicz

      Hello,

      I know that my problem hasn't do much with JBoss but I decided to post it here. If you know more suitable place, show me it please.

      I have a Session EJB deployed on JBoss. I'm using JDBCTemplate (from Spring framework) to connect with Oracle 9i database (defined as datasource in JBoss).

      I tried to use SELECT ... FOR UPDATE statement but when I'm executing it, the application stops and waits forever. As far as I know it shouldn't. Rows in the database aren't blocked (I can make UPDATE or SELECT ... FOR UPDATE freely).

      What it can be? How to solve this problem?

      Best regards,
      Konrad Billewicz