Missing IN or OUT parameter at index:: 1

[Allen Bandela]

I'm getting the above SQLException while executing a PreparedStatement. I didn't get an error while testing though.

ps=conn.prepareStatement("select * from tableName where columnB = ?" + " Order by columnA");
ps.setString(1,this.columnBValue);

Its pretty simple. But, wonder why the exception. Driver used Oracle Jdbc driver. Has anyone faced a similar situation and what was your approach to solve it. Thanks.

[Jan Cumps]

At first sight, your example code looks ok.
Maybe if you post the real code, and the complete error output, we can tell more.

Regards, Jan

[Allen Bandela]

Thanks for trying to help.Here's the code. And the exception error message is in the subject line. Its a java.sql.SQLException.
ColumnA is a Number and ColumnB is a VARCHAR2.

private Static PreparedStatement ps=null;
private Static Connection prevConn=null;
private ResultSet execQuery(Connection conn){
try{
if(ps==null || conn!=prevConn){
 if(ps!=null){
 ps.close();
 }
ps=conn.prepareStatement("select * from tableName where columnB = ?" + " order by columnA);
prevConn=conn;
 }
ps.setString(1, this.columnBValue);
ResultSet rs = null;
rs= ps.executeQuery();
 
}catch(SQLException e){
 e.printStackTrace();
}
         return rs;
}

(Do you think that if this.columnBValue is null, it would give this exception?)

[ July 03, 2007: Message edited by: Sylvester James ]

[ July 03, 2007: Message edited by: Sylvester James ]
[ July 03, 2007: Message edited by: Sylvester James ]

[Jan Cumps]

(Do you think that if this.columnBValue is null, it would give this exception?)

That's something you can test. Try how the code behaves when the attribute has a value, and when it's null.

[Herman Schelti]

hi Sylvester,

why do you have a static Preparedstatement and Connection?

Herman
PS your code does not compile, please only sent exact code (just copy/paste)