Yess :) - i got the problem: In InterBase this "call" Syntax for Stored
Procedures is not really working. With the following SqlMap the Stored
Procedure works fine for InterBase:
<select id="selectMainSports" resultMap="mainSportsResult"
parameterClass="ebet.SystemConfig">
SELECT * FROM WEB_HSPORTART(#language#, #company#, 0,
#betMode#)
</select>
Now this costed me a lot of time, I hope this can help anyone other out
there who has to do with JayBird/Interbase.
Thanks a lot for your support,
Michael
-----Ursprüngliche Nachricht-----
Von: Brandon Goodin [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 29. Mai 2005 10:02
An: Michael Glitzner
Betreff: Re: Stored procedures not working?
"When I execute the parameters "[D, 0, TW]" directly
against the database"
I'm still trying to determine if you have acutally tested this out
with straight JDBC. When you say that you have tested it directly
against the database that makes me think that you are using a client
tool that does not use straight jdbc. Did you execute it against the
database using straight JDBC with the JayBird JDBC Driver?
Brandon
