Subject | Re: [Firebird-Architect] Re: RFC: Please unify stored procedure execution |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2004-12-21T15:39:06Z |
Hello, Roman!
Tuesday, December 21, 2004, 5:03:34 PM, you wrote:
RR> IBX is InterBase.... Whenn people use IBX they already develop custom
RR> application for InterBase/Firebird. However when they use JDBC the
RR> program against the unified interface that hides the difference
RR> between databases.
Another BDE hell...
I'm wondering how driver architecture developers like to step
on the same rake. Anyway, this is rithoric question.
RR> No, CallableStatement cannot convert {call ...} syntax into SELECT *
RR> FROM .... without any hint.
As I understood there is no way to say to CallableStatement that
procedure must be executed or selected. Right? If so, does
other server's drivers behaive same, i.e. while they support
output and resultset procedures, they always call procedures
as resultsets? Excuse me, I completely do not know JDBC specification
and want to see if there any kind of calling CallableStatement other
than you already gave.
--
Dmitri Kouzmenko
Tuesday, December 21, 2004, 5:03:34 PM, you wrote:
RR> IBX is InterBase.... Whenn people use IBX they already develop custom
RR> application for InterBase/Firebird. However when they use JDBC the
RR> program against the unified interface that hides the difference
RR> between databases.
Another BDE hell...
I'm wondering how driver architecture developers like to step
on the same rake. Anyway, this is rithoric question.
>> ??? JDBC can't execute usual SQL SELECT statement without someRR>
>> extention???
RR> No, CallableStatement cannot convert {call ...} syntax into SELECT *
RR> FROM .... without any hint.
As I understood there is no way to say to CallableStatement that
procedure must be executed or selected. Right? If so, does
other server's drivers behaive same, i.e. while they support
output and resultset procedures, they always call procedures
as resultsets? Excuse me, I completely do not know JDBC specification
and want to see if there any kind of calling CallableStatement other
than you already gave.
--
Dmitri Kouzmenko