JAVA

Hello, I am getting this error:

Syntax error: Encountered "," at line 1, column 74.

I can't find where the error is though, can someone help me, thank you

CODE:

import java.sql.*; public class SWC {

public static void main(String[] args) { final String DB_URL = "jdbc:derby:swc;create=true"; try{ Connection conn = DriverManager.getConnection(DB_URL); Statement stmt = conn.createStatement(); // ************************CREATE TABLES**************************** stmt.execute("CREATE TABLE VENDOR (" + "VendorID INTEGER PRIMARY KEY," + "VendorName VARCHAR(50))," + "Country VARCHAR(25))," + "EstimatedOrderDays INTEGER");

stmt.execute("CREATE TABLE ITEM(" + "ItemNumber INTEGER PRIMARY KEY," + "ItemDescription VARCHAR(100)," + "ItemCost DOUBLE," + "VendorID INTEGER REFERENCES VENDOR(VendorID))");

//************************INSERT DATA****************************

String vendorInserts = "INSERT INTO VENDOR (VendorID, VendorName, Country, EstimatedOrderDays) VALUES " + "(100, 'Venchi', 'Italy, 7)," + "(200, 'Callebaut', 'Belgium', 6)," + "(300, 'Domori', 'Italy', 6)," + "(400, 'El Rey Chocolate','Venezuela', 5)," + "(500, 'Cacao Barry','France', 6)"; stmt.execute(vendorInserts);

String itemInserts = "INSERT INTO ITEM (ItemNumber, ItemDescription, ItemCost, VendorID) VALUES " + "(1, 'Venchi 3.5 oz white chocolate bar', 7.99,100)," + "(2, 'Venchi 3.5 oz fondente dark bar', 7.99, 100)," + "(3, 'Venchi 3.5 oz cuor di cacao bittersweet bar',8.99, 100)," + "(4, 'Venchi 12 oz Crema Cioccolato e nocciole chocolate hazelnut spread', 19.95, 100)," + "(5, 'Venchi 8 oz thick hot chocolate powder', 11.99, 100)," + "(6, 'Callebaut 5 kg hazelnut praline pail',109.99, 200)," + "(7, 'Callebaut 5 lb caramel loaf', 21.99, 200)," + "(8, 'Callebaut 28 oz milk chocolate mousse powder', 21.99, 200)," + "(9, 'Callebaut 28 oz dark chocolate mousse powder', 21.99, 200)," + "(10, 'Callebaut 28 oz white chocolate mousse powder', 21.99, 200)," + "(11, 'Callebaut hot chocolate sticks 300 ct', 22.99, 200)," + "(12, 'Domori Fusion Lattesal milk chocolate and sea salt bar 3.5 oz', 8.99, 300)," + "(13, 'Domori Fusion Peperoncino dark chocolate and chili pepper bar 3.5 oz', 8.99, 300)," + "(14, 'El Rey 2.8 oz Apamate dark bar', 4.99, 400)," + "(15, 'El Rey 2.8 oz Mijao dark bar', 4.99, 400)";

stmt.execute(itemInserts); stmt.close(); conn.close(); System.out.println("SUCCESS"); } catch(Exception ex){ System.out.println(ex.getMessage()); } } }