multiple inserts in a single sql statement

From: <rachamallu_reddy_at_my-dejanews.com>
Date: Tue, 09 Mar 1999 19:10:43 GMT
Message-ID: <7c3rna$s3a$1@nnrp1.dejanews.com>

Hi,

My application talks to Oracle8 via JDBC1.2. In the application, I do a lot of inserts. Right now I have a sql statement for every insert. This means JDBC calls for every insert. With this scenario, the performance is not good.

With JDBC2.0, I can batch a set of sql statements, before sending them over to the server.

I don't want to use JDBC2.0 now. Until then, is there any way to send multiple insert's as a single sql statement?

Any insight will be really appreciated.

thanks
reddy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 13:10:43 CST