From: | Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Cc: | peter(at)retep(dot)org(dot)uk |
Subject: | jdbc: Batch updates-Prepared Statements |
Date: | 2001-05-28 08:42:19 |
Message-ID: | Pine.GSO.4.10.10105281110250.18361-100000@sappho.ics.forth.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hello,
At postgresql JDBC driver a Statement.executeBatch() command
is equivalent to a transaction containing the update commands of the
batch. I think this is not compatible with java jdbc documentation
where states that when
an Statement.executeBatch() command is executed the batch of commands
are executed but no in a new transaction. If you want to create a new
transaction you have to state it explicitly. That is you should turn off
autocommit and finally execute the Connection.commit command.
According to current implementation I can't have multiple
Statement.executeBatch() commands in one transaction.
I also want to ask whether in postgresql JBDC driver 'Prepared statements'
are more efficient than 'Statements'.
thank you in advance.
Regards,
Sofia Alexaki
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2001-05-28 16:14:15 | Re: Re: ODBC Security |
Previous Message | Joe Conway | 2001-05-28 05:02:17 | remote database queries |