On 07/25/14 18:53, Mark Rotteveel wrote:
> The separation between Statement and PreparedStatement (and > CallableStatement) in JDBC may seem like overkill, but if you are > executing statements without parameters and you are only executing them > once, it is overhead to have to prepare a query before you can execute. > As I understand the execute immediate functionality in Firebird, it is > limited in that it can only be used to execute statements that don't > produce a result set (or have a singleton result), and you can't ask for > things like update counts. So currently Jaybird simply prepares and > execute for its Statement implementation, but a single shot > prepare-and-execute would actually be nice ;) In FB3 one can execute immediate any SQL statement, including one with input parameters & output result set. There is IAttachment::openCursor() call, which differs from IStatement one by presence of SQL text parameter. I.e. if you know on advance that this is select query and what parameters it needs (or no parameters) and want to execute it only once - no problems, you can do it. ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
