nferrier@tapsellferrier.co.uk wrote:
> >I can't use it, because I haven't change query in 3pty software (btw)
> >In standard jdbc this is work :
> > Statement st = con.createStatement();
> > ResultSet rs = con.executeQuery("select * from tab");
>
>
> What do you mean "standard jdbc"?
>
> If you use the unpatched postgresql driver you have to always specify
> the ";".
I never specify the ";" and it works for me.
>
> This is different to Oracle but it isn't part of the JDBC standard.
Maybe not explicitly, but I definitely read that from the specification.
- None of the examples use semicolons.
- It's clearly intended for SQL to be portable between databases, with
the JDBC escapes, requiring drivers to support entry-level SQL-92
syntax, etc. Oracle requires statements to _not_ have semicolons at the
end. Any third-party tools will do things this way.
- JDBC is not intended for running multiple statements at one, except
through executeBatch(). And there's support for grabbing multiple result
sets from a single execution, but that's for callable statements that
have multiple ref cursors as output parameters. You definitely can't
retrieve both update counts and result sets. So without support for
multiple statements, adding statement separators is silly.
I'm really, really looking forward to your streaming result sets
(everything else in my application streams already!), but please don't
require me to do things in a way incompatible with the rest of the world
for no good reason.
Thanks,
Scott