PreparedStatement Error

[karthik swamy]

hello everyone,
just view this SQL queryi.e
This is what i am getting from database :
select * from fpStar where org_id in(#orgid#) and colStar='new' and secCOl='old' Union select * from opStar where org_id in(#orgid#) and colStar='new' and secCOl='old'
then in jsp I am replacing like this :

String strNoQues="?,?";

String strQuery=query.replaceAll(query,"#ORGID#",strNoQues);

then the query looks like this :
select * from fpStar where org_id in(?,?) and colStar='new' and secCOl='old' Union select * from opStar where org_id in(?,?) and colStar='new' and secCOl='old'
then i am binding it with prepareStatement

int iQueCnt = 0, idx = 0;
	while ((idx = Query.indexOf("?", idx)) != -1){
	idx++;
	iQueCnt++;
	}

	PreparedStatement pstmt=con.prepareStatement(Query);
	int b=0;
	for(int a=0;a<iQueCnt;a++){
	pstmt.setString(a+1,iQueVal[b]);	
	if(b==iQueVal.length){
	b=0;
		}
	}

if i need to set String only for org_id then it works

but if then query comes like this:
select * from fpStar where org_id in(?,?) and colStar=? and secCOl=? Union select * from opStar where org_id in(?,?) and colStar=? and secCOl=?
then code the java code fails to work...

so please suggest me any solutions for this...



Thanks and regards,
Karthik Swamy

[Roberto Perillo]

Champ, since this is more related to JDBC, I'm moving this to the JDBC forum.

[Martin Vajsar]

Karthik, please TellTheDetails (see especially ItDoesntWorkIsUseless).

Post the exception you're experiencing, including stack trace. Or, if you're not getting an exception, describe the output the code generates and explain why is it wrong.

[Paul Clapham]

In that code with the cryptically-named variables "a" and "b", the value of "b" is always zero. Since you made it a variable, perhaps that wasn't what you intended.