Chantal,
I just tried it and it ran ok?
con = getConnection();
Statement st = con.createStatement();
String sql = "vacuum analyze";
st.execute(sql);
This if from the logs
ProcessQuery
2002-03-08 11:50:42 DEBUG: CommitTransactionCommand
2002-03-08 11:50:45 DEBUG: StartTransactionCommand
2002-03-08 11:50:45 DEBUG: query: vacuum analyze
2002-03-08 11:50:45 DEBUG: ProcessUtility: vacuum analyze
2002-03-08 11:50:45 DEBUG: --Relation pg_type--
2002-03-08 11:50:45 DEBUG: Index pg_type_oid_index: Pages 5; Tuples
144: Deleted 795.
CPU 0.00s/0.02u sec elapsed 0.01 sec.
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Chantal Ackermann
Sent: Friday, March 08, 2002 11:09 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] vacuum
hello all,
I try to call VACUUM ANALYZE through a PreparedStatement. As the logfile
only
lists debug messages for VACUUM that I start in psql I suspect that the
the
VACUUM in my java app is never called.
Prepared Statement prepVacuumAnalyze = con.prepareStatement( "VACUUM
ANALYZE"
);
prepVacuumAnalyze.execute();
con.commit(); // auto commit is off
Is it not possible to call such SQL commands in jdbc?
thank you
Chantal
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
