Querying in JDBC to oracle DB
I have done a JDBC connection to an oracle database and trying to run update and select statements using prepared statements.
The Problem is when i write a select * from tablename; i am getting the correct result but when i do select * from tablename where columnname=? and preparedStatement.setString(1, value.toUpperCase);
i am getting 0 rows when i did a analysis and using TOAD found that the query going to database is like this
select * from tablename where coulmnname= :1 ;
Let me know if anyone has resolved this issue.