This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Prepared Statement Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Prepared Statement Problem" Watch "Prepared Statement Problem" New topic

Prepared Statement Problem

Ross Howard Miller

Joined: Jan 23, 2012
Posts: 11
I'm getting a SQLException invalid column index.

James Boswell

Joined: Nov 09, 2011
Posts: 1051

Hi Ross

On what line is this exception being thrown?
Paul Clapham

Joined: Oct 14, 2005
Posts: 19747

Why do you have those quotes around the parameter marker in the SQL?
Michael Dirks

Joined: May 22, 2006
Posts: 4
You're putting quotes around your parameter which means that instead of the query trying to find the row number where call_no_display = callNumber, it's trying to find a case where call_display equals a string that has a question mark in it.

try this instead:
String getRowNumber = "SELECT row_number FROM call_no_browse WHERE call_no_display = ? ";
sarath j nair

Joined: Nov 10, 2011
Posts: 11

You Should get this Error " getting a SQLException invalid column index. " because Its not a proper Query

sql="insert into OTEMPLOYEE(ADMIN) values(?)";
PreparedStatement ps=null;
ps.setInt(1, admin);
I agree. Here's the link:
subject: Prepared Statement Problem
jQuery in Action, 3rd edition