Search:

here one more surprise ! i declared that same method ( copy and paste) in another class show( before it was theater). it worked there with no problem every thing works fine.

now that my problem is...

here is the table details


and database is mysql 5.5! all other query works fine, some of them are used to insert into this table also. i'm shocked how can this happens?

private String available_stmt = "select tickets from shows where show_name =? and tid=? and showdate=?";

public int availablity(String theater, String show, java.sql.Date date) {
int...