Re: Slow performance with SQL and stmt.executeUpdate()

From: Alfred <user@xxxxxxxxxxx>
Date: Sun, 27 May 2007 07:55:32 +0200

joeNOSPAM@xxxxxxx wrote:

On May 25, 2:35 pm, John Gordon <gor...@xxxxxxxxx> wrote:
...
Hi, yes. Look at the Statement addBatch() and executeBatch() calls.

Joe Weinstein at BEA Systems

To OP: And use PreparedStatement for operations like this
because on server side it will be a precompiled procedure
after creating.

Alfred

.

References:
- Slow performance with SQL and stmt.executeUpdate()
  - From: John Gordon
- Re: Slow performance with SQL and stmt.executeUpdate()
  - From: joeNOSPAM@xxxxxxx

Prev by Date: Re: JDBC: Fast way to find the number of rows in a ResultSet?
Next by Date: Re: jdbc connection to MS access database
Previous by thread: Re: Slow performance with SQL and stmt.executeUpdate()
Index(es):
- Date
- Thread

Relevant Pages

Re: Behavior of Connection.commit()
... Joe Weinstein at BEA Systems ... Some folks are used to Oracle's SQL-PLUS application committing on close, so you *could* have a connection configuration option to go the other way, but *boy* is that odd/ugly as desired behavior. ...
(microsoft.public.sqlserver.jdbcdriver)
Re: JDBC Driver for SQL 7.0 ?
... freeware jTDS should too. ... Joe Weinstein at BEA Systems ... Prev by Date: ...
(microsoft.public.sqlserver.jdbcdriver)
Re: CachedRowSetImpl.getTimestamp() throwing exception
... added property to add to your connections: ... Let me know if this clears the problem up... ... Joe Weinstein at BEA Systems ...
(comp.lang.java.databases)
Re: RefCursor works in SQL*Plus but not JDBC
... seems to have nothing to do with RefCursors so far... ... Joe Weinstein at BEA Systems ... Prev by Date: ...
(comp.lang.java.databases)