This week's book giveaway is in the Performance forum. We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line! See this thread for details.
I am using org.apache.commons.dbcp.BasicDataSource for database connection and Spring JDBCtemplate.queryForList() with a preparedStatement. The preparedstatment does not return data when I pass a string as below thought there is data in the database. The query works for other integer values that are passed. I am not clear as what I am missing here.
Any help is highly appreciated.
Thanks in advance.
posted 7 years ago
Your preparedStatement is responsible to know the parameter types; post it's code.