Inserting a product into a derby database with SQL through Java

Question

I can't identify why this code is not inserting the product into the database. I have very similar code that inserts a new user working perfectly. The only real difference is that in this SQL command im trying to insert price which is of the datatype float. Is there a problem with the SQL command or is it something else. Any help is greatly appreciated. Thank You!

        public void insertProduct(Product newProduct){
        
        DBManager dmbgr = new DBManager();
        Connection con = dmbgr.getConnection();
        Statement stmt = null;
        
        try {
        
            stmt = con.createStatement();
            String sql = String.format("INSERT INTO PRODUCTS(NAME,DESCRIPTION,CATEGORY,BRAND,PRICE,IMAGE_LOCATION,COLOR,PRODUCT_CODE) " + 
                            "VALUES('%s','%s','%s','%s','%f','%s','%s','%s')",newProduct.getName(),newProduct.getDescription(),newProduct.getCategory(),newProduct.getBrand(),newProduct.getPrice(),newProduct.getImageLocation(),newProduct.getColor(),newProduct.getCode());
            stmt.executeUpdate(sql);
        }
        catch (SQLException e){
            e.printStackTrace();
         }finally {
            try {
                stmt.close();
                con.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

question from:https://stackoverflow.com/questions/65846149/inserting-a-product-into-a-derby-database-with-sql-through-java

Answer 1

Waitting for answers