Java Prepared Statement execution not returning any data

[dennis zined]

I have a prepared statement with a simple query...my problem is that it does not return any data. For example,

statement = con.prepareStatement("select * from <some table> where <field1> = ? and <field2> = ?");
statement.setString(1, "param1");
statement.setString(2, "param2");
resultSet = statement.executeQuery();

If I use the same sql but with inline parameters...it returns me the data I expect. For example,

statement = con.prepareStatement("select * from <some table> where <field1> = 'param1' and <field2> = 'param2'");
resultSet = statement.executeQuery();

There was a similar post at experts-exchange but I have to pay to see the solution.

Has anybody encountered this before?

Thanks.

[JulianInactive KennedyInactive]

Hi Dennis,

I've not encountered this problem, but can you give a real example and state which database and JDBC driver you're using?

Jules

[Jeanne Boyarsky]

Dennis,
You actually don't have to sign up to see the solution. Just keep scrolling down past all the ads and you see the answers.

[JulianInactive KennedyInactive]

OK, so to summarise:

Ensure that you're not getting any exceptions, e.g. ones that you're ignoring with code like catch(Exception e) { }

Ensure that your SQL returns rows when executed in the database directly, i.e. outside Java

Ensure that you're connecting using the same credentials (i.e. machine, database, user/schema, etc.)

Ensure that the data you're trying to read has been committed if it was added in a different session. Alternatively set the transaction isolation in Java for dirty reads using code like con.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED); WARNING: do this only if you mean it and know what you're doing

Hope that helps.

Jules