Re: Java applets / Informix Connect / JDBC / Informix DS 7.22

Chas wrote: >performing these insertions? Preferably within a transaction which will be >committed once all insertions have been successful, or rolled back >otherwise. Preferably avoiding the ugly solution of executing 1,000 >separate insert statements via informix.api.Statement.exec(). > Chas, SQL syntax does not include the ability to perform multiple inserts with a single statement. Each insert requires a well formed SQL Insert statement. You could create a JDBC PreparedStatement once, then execute this over the 1000 iterations simply substituting the new values. I think this is as good as it gets. Mike Fontenot