trouble in PreparedStatement select in ACCESS DB with contains

[Hugo P.]

Hello.

I'm tring to make this work, but unable to do so.

String query = "SELECT * FROM professores WHERE nome Like '?';";
PreparedStatement ps = getConnection().prepareStatement(query);
ps.setString(1, nomeProf);

error I'm getting: UCAExc:::4.0.2 Invalid argument in JDBC call: parameter index out of range: 1

please, help.

[Gord Thompson]

Parameter placeholders are simply bare question marks. They should never be enclosed in quotes, hash marks, or any other delimiter. '?' is not a parameter placeholder, it is a literal string containing a single question mark. To use a parameterized LIKE query you should do something similar to this:

String query = "SELECT * FROM professores WHERE nome Like ?";
PreparedStatement ps = getConnection().prepareStatement(query);
ps.setString(1, nomeProf + "%");

[Hugo P.]

Thanks man, that worked.
I was trying with the quote because the sintaxe for the MS Access use the quote, did'nt realize it wold work with the '%'.
Did'nt realize I should put the '%' inside the ps.setString()

summarizing for people with similar problem:
I was trying :

String query = "SELECT * FROM professores WHERE nome Like %?%";
PreparedStatement ps = getConnection().prepareStatement(query);
ps.setString(1, nomeProf);

It work like:

String query = "SELECT * FROM professores WHERE nome Like ?";
PreparedStatement ps = getConnection().prepareStatement(query);
ps.setString(1,  "%"+nomeProf+"%");

Sorry for the bad english.
Thank you.