import java.sql.*; public class xx { public static void main(String args[]) throws Exception { Class.forName("org.postgresql.Driver"); Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/cas","math",""); // Thread.sleep(10000); conn.setAutoCommit(false); Statement stmt = conn.createStatement(); stmt.execute("set search_path to cas_metadata_sega, cas_metadata"); String query="UPDATE table_list SET description = ? WHERE " + " id = cas_get_table_id ( ?,? )"; String desc="\\tag{image SRC=\"/vizier/new2.gif\"}3rd release of DENIS (2005Sep)"; PreparedStatement pstmt = conn.prepareStatement(query); String catalog="cas_data_sega"; String table="b_denis_denis5"; pstmt.setString(1,desc); pstmt.setString(2,catalog); pstmt.setString(3,table); pstmt.executeUpdate(); pstmt.close(); conn.rollback(); } }