Executing Postgres crosstab query as a prepared statement - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul Executing Postgres crosstab query as a prepared statement, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan Artikel crosstab, Artikel gwt, Artikel Java, Artikel postgres, Artikel preparedstatement, Artikel PSQLException, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : Executing Postgres crosstab query as a prepared statement
link : Executing Postgres crosstab query as a prepared statement

Executing Postgres crosstab query as a prepared statement

I was executing a crosstab query as a prepared statement in Java(in a GWT app) and getting the following error -

PSQLException - Can't use query methods that take a query string on a PreparedStatement.

With some helpful folks from stackflow, I was able to resolve the error with the following code -

String query = "SELECT * FROM crosstab(
                      'SELECT rowid, a_name, value
                       FROM test WHERE a_name = ''att2''
                                    OR a_name = ''att3''
                      ORDER BY 1,2'

) AS ct(row_name text, cat_1 text, cat_2 text, cat_3 text);";

PreparedStatement stat = conn.prepareStatement(query);
ResultSet rs = stat.getResultSet();
//Note that, it is executeQuery() and not executeQuery(query)
stat.executeQuery();
rs = stat.getResultSet();
while (rs.next()) {
    //TODO
}




Thanks!

Demikianlah Artikel Executing Postgres crosstab query as a prepared statement

Sekianlah artikel Executing Postgres crosstab query as a prepared statement kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.

Anda sekarang membaca artikel Executing Postgres crosstab query as a prepared statement dengan alamat link https://dev-create.blogspot.com/2011/10/executing-postgres-crosstab-query-as.html