Connection 2005-10-27 - By Mike New
Back
> Hi,
> I have a question.
> I have to insert 5 records in a database.
> I get the connection from datasource and create the preparedStatement.
> My question is, is it good to use one Connection and preparedStatement to
> insert all the 5 records or
> do I have to get the connection using ds.getConnection() and
> preparedStatement for each insert?
> Which one would be better in performance?
> Please note that I don't want to use executebatch() for this.
If performance is your only concern, using a prepared statement should be
faster I guess..
Mike
>
> Thanks in advance,
>
> ===========================================================================
> To unsubscribe, send email to listserv@(protected) and include in the
> body
> of the message "signoff J2EE-INTEREST". For general help, send email to
> listserv@(protected) and include in the body of the message "help".
>
-- ---- ---- ------ _/ /// // -- ---- ---- ---- --
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
|
|
