Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: local policy)
From: "Michael Glitzner" <michael.glitzner@inode.at>
To: <ibatis-user-java@incubator.apache.org>,
	"'Brandon Goodin'" <brandon.goodin@gmail.com>
Subject: AW: Stored procedures not working?
Date: Sun, 29 May 2005 10:38:09 +0200
Message-ID: <000101c56429$be237a40$6500a8c0@michael>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <2fe5ef5b050529010248ee447@mail.gmail.com>
Importance: Normal

Okey, now I tested it with the JDBC-Driver and it seems that there ist
he bottleneck. The JayBird Driver doesn't return me more than 1 dataset,
when I jump to the second one with next() I get the following error:

"org.firebirdsql.jdbc.FBSQLException: The resultSet is not in a row, use
next"

But I don't have any idea now how to solve this problem, am I doing
anything wrong with my stored procedure call?

Thx for your help!

Greetings, Michael

-----Urspr=FCngliche Nachricht-----
Von: Brandon Goodin [mailto:brandon.goodin@gmail.com]=20
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