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
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3932368#3932368
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3932368
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
