postgresql - Java Crosstab - preparedstatement query -

i have typical crosstab query static parameters. works fine createstatement. want use preparestatement query instead.

         string query = "select * crosstab(                           'select rowid, a_name, value                             test a_name = ''att2''                                          or a_name = ''att3''                            order 1,2'          ) ct(row_name text, category_1 text, category_2 text, category_3 text);";          preparedstatement stat = conn.preparestatement(query);          resultset rs = stat.getresultset();       stat.executequery(query);      rs = stat.getresultset();       while (rs.next()) {              //todo          } 

but not seem work.

i psqlexception - can't use query methods take query string on preparedstatement.

any ideas missing?

you have fallen confusing type hierarchy of preparedstatement extends statement:

preparedstatement has same execute*(string) methods statement, they're not supposed used, use parameterless execute*() methods of preparedstatement --- have given actual query string execute using conn.preparestatement().