How to truncate PostgreSQL tables from JDBC
•
Java
I have a PostgreSQL database. I want to truncate some tables using JDBC What do I do?
This is what I've tried, but there's no work... Not even reporting any errors:
Use callablestatement
try (Connection connection = getConnection(); CallableStatement statement = connection.prepareCall("TRUNCATE " + tableName)) { return statement.execute(); }
Use statement
try (Connection connection = getConnection(); Statement statement = connection.createStatement()) { return statement.execute("TRUNCATE " + tableName); }
Use Preparedstatement
try (Connection connection = getConnection(); PreparedStatement statement = connection.prepareStatement("TRUNCATE " + tableName)) { return statement.execute(); }
Solution
After truncation, I need to submit:
try (Connection connection = getConnection(); Statement statement = connection.createStatement()) { int result = statement.executeUpdate("TRUNCATE " + tableName); connection.commit(); return result; }
Start with the documentation:
The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
二维码