Not all variables bound. Where in your code do you actually set your bind variables. I don't quite see it assigned. I see one statement "pstmt = this.setBindParams(pstmt);" which looks to try to set them, but pstmt is the statement not the values.
I could be wrong here, but that is my impression. I have worked with prepared statements in
JDBC and in VB Command Objects, and usually there are assignment statements like
statement = "Select * from a_table where field_a = :bind_var1"
Then you have a statement that is similar, but in psuedo-code here:
statement.setBind(bind_var1, "My Value")
something along those ines, I don't remember code by heart here, but it would be something similar.
Am I missing anything? Am I completely off base?
Mark