Creating a table throws SQL Exception : <p>I would like to create a simple SQL database with one table. Line 8 throws a SQLSyntaxErrorException.</p>

<pre><code>public class LoadDatabase {
public static void main(String[] args) {

    //if createConnection() returns a connection issue SQL Statements
    try (Connection connection = ConnectToDatabase.createConnection()){
        Statement command = connection.createStatement();
        //gives SQL command "create table" to database
        command.executeUpdate(ConnectToDatabase.CREATE_TABLE);
        command.close();
    } catch (ClassNotFoundException e) {
        System.err.println("Could not find database driver");
    } catch (SQLException e) {
        System.err.println("SQL Error");
        e.printStackTrace();
    }

}
}
</code></pre>

<p>This is the table</p>

<pre><code>//SQL command to create a new table as constant variable
public final static String CREATE_TABLE =
        "CREATE TABLE BOOK_INVENTORY (" +
        "TITLE VARCHAR, " +
        "AUTHOR VARCHAR, " +
        "PAGES INT, " +
        "ISBN VARCHAR, " +
    ")";
</code></pre>
