IDS 9.40 UC3 / JDBC 2.21

Hi all,

we have a very strange JDBC-Problem.
We have a simple SELECT-Statment, something like

SELECT first_name from adr where name = 'Huber';

Executing this statement via JDBC by using this code:
....
Statement stmt = connection.createStatement();
stmt.executeQuery("SELECT first_name from adr where name = 'Huber'");
....
we get a result after a few milliseconds. In a loop of size 100, it takes
1.2 seconds.

BUT:
=====

Executing this statement via JDBC by using this code:
....
PreparedStatement stmt = connection.prepareStatement(SELECT first_name
from adr where name = ?");
stmt.setString(1, "Huber");
stmt.executeQuery();
....
we get a result after alittle more than 1 seconds. In a loop of size 100,
it takes 100 seconds.


It seems, that Informix has a problem using parameterized
prepared-statements.

Any ideas?

Thanks in advance!

bye
Markus

When running in a loop ,
ensure that you are not re-preparing the select statement each time before
executing it.