JDBC insert statement not working

Question

I am trying to insert a new record using jdbc. Everything looks fine, I have no exception, but the new record is not inserted into the table. The select rule works correctly.

public Connection getConnection(){ Connection conn=null; try { Class.forName("org.postgresql.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { conn = DriverManager.getConnection(url); conn.setAutoCommit(true); } catch (SQLException e) { e.printStackTrace(); } return conn; } public void insertDish(String name, float mass, float price, String description,int pizzeria_id) { String insertStr = "insert into \"Dish\"(name,mass,price,description,pizzeria_id) values("+"'"+name+"'"+", "+mass+", "+price+", "+"'"+description+"'"+", "+pizzeria_id+")"; Connection conn = getConnection(); try { Statement sql = conn.createStatement(); sql.executeUpdate(insertStr); sql.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } 

What could be wrong?

Answer 1

I had a similar situation where my database query software did not display the inserts / updates made from my Java program because they were not committed and therefore were not visible to other connections.

Try to explicitly commit immediately after the statement:

 sql.executeUpdate(insertStr); conn.commit(); // ADDED sql.close(); 

If this works, you can configure your AutoCommit settings or just stay with an explicit commit.

Answer 2

I would try to turn off automatic commit and execute the transaction manually, see if that helps.