1 Reply Latest reply on Mar 24, 2006 9:49 AM by Ralf Alt

    MSSQL wrong results in ejb3

    Ralf Alt Newbie

      Hallo,

      I'm using ms sql 2000 with the newest jdbc (sqljdbc.jar) for 2000 and 2005 databases and the Jboss 4.0.4RC1.

      The programm uses the createNativeQuery() methode. If I profile the generated sql by ejb I get:
      declare @P1 int
      set @P1=0
      exec sp_prepexec @P1 output, NULL, N'select id from mytable where id = -1'
      select @P1
      Returns in the SQL Query Analyzer):
      ID DESC
      ----------- -----------

      (0 row(s) affected)


      -----------
      123

      (1 row(s) affected)

      For the id = -1 there is no recordeset returned (checked in SQL Query Analyzer). But the method getResultList() returns one row.

      I think the problem is the select @P1 statement. This select returns allways numbers greater 0, I think this number is NOT the count of resultsets.

      Is this a bug in ejb/hibernate or what can I do?

      Thanks
      Ralf