Hello again!
Ich have another problem with data base access (still jboss 4.0.3SP1 without
ejb rc4; sybase ASA9):
I have to use stored procedures. I mapped two of them with a hbm.xml file.
worked fine with result sets with only one row. but now i want to use this for
a procedure that returns muliple rows. the list that i get contains as many
objects as the procedure returns rows. but they are all the same. just copies
of the first one.
the configuration looks like this:
|
| <class name="xy.classname">
|
| <id name="xxx" type="integer" column="xxx"/>
| <property name="yyy" type="string" column="yyy"/>
| ...
| </class>
|
| <sql-query name="QUERYNAME" callable="true">
| <return class="xy.classname">
| <return-property name="xxx" column="xxx"/>
| <return-property name="yyy" column="yyy"/>
| ...
| </return>
| { call stp_procedurename(:param1,:param2,....) }
| </sql-query>
|
|
is this not possible or have i made a mistake?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3931866#3931866
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3931866
-------------------------------------------------------
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
