JDBC-Problem
Posted in 2004
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