prepared statement and DB field char

Hi,

I have a field in Database which is of CHAR(11) type. I am using
prepared statement to set parameter value in this field in Java in DAO class. I used
setString method of prepared statement for this purpose but i didnt get
any success in it.

Can any one help me which prepared statement method should I use to set
parameter in this field.

thanks

setString() is correct. What error did you get?

Thanks for reply.

My query is like this:

sql = "select empname from employ where empno = ?";

Here empno is char(11) in DB.

and then I set value

ps.setString(1,"101");

Originally, there is record which has empno=101 in DB. but in my case there is no data fetch from DB and also not any error is coming.

Thanks

That just means your query selected zero records, then.

Perhaps you think there is a row in the table containing "101" in the empno column? Is it not possible that row actually contains "101 " or " 101"?

Thanks for reply.

there is DB field char(11) so in db there is 11 size for that field.

so I have write querey like this.

select empname from emp where trim(empno)= '101';

now its working.

thanks again.

Use VARCHAR or VARCHAR2 instead of CHAR as your column data-type, to avoid the trailing blanks on your data.