Subject | Re: [Firebird-Java] PreparedStatement and nested queries |
---|---|
Author | Marco Parmeggiani |
Post date | 2004-04-02T10:39Z |
In data Fri, 2 Apr 2004 12:01:10 +0200, hai scritto:
i'm using the latest 1.0 driver.
i'm testing the code against a 1.0 server and against a 1.5 server.
the problem seems to be in the server.
1.5 server prepare the statement with parameters in order of appearance in
the query string.
para4
para6
para7
1.0 server prepare the statement with parameters in order of "statement"
para7
para4
para6
i am a bit upset about this... switching to 1.5 will broke my code. did i
do something wrong doing those type of queries?
ciao
> A question on PreparedStatement parameter index (the one used in setStringargh. more info.
> etc), let's suppose to have this query with some nested queries:
i'm using the latest 1.0 driver.
i'm testing the code against a 1.0 server and against a 1.5 server.
the problem seems to be in the server.
1.5 server prepare the statement with parameters in order of appearance in
the query string.
para4
para6
para7
1.0 server prepare the statement with parameters in order of "statement"
para7
para4
para6
i am a bit upset about this... switching to 1.5 will broke my code. did i
do something wrong doing those type of queries?
ciao