The above method is in from the Bean class and is being called from servlet. This is actually to fetch data from database and display on the browser. Am using JSP and JSTL to display on the browser. Now my problem is am getting "Parameter index out of range(2) number of parameters which is (1)" error on the tomcat console. Am not able to trace out the problem in this code. Can anyone tell me the origin of the error and how to handle it?
And one more issue is, I have given 2 queries(query1, query2) to execute. I actually wanted to combine those 2 queries to a single query but din't knew how. I mean how to combine 2 select statements? Can I write 2 separate queries to fetch data? Is my code correct?
Thanks & Regards
I "try", I "catch" and "finally" WIN !!!