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
                    
                    
                    
                                                        二维码
                        
                        
                                                
                        