The error message is indicating that there is a syntax error in the SQL script at line 1, character 2. The issue is with the space between lastName and =.

In H2 database, column names are case-insensitive, but when using Java-based persistence, the convention is to use camelCase or snake_case for column names, not PascalCase (which is what LASTNAME uses).

The fix is to change LastName to last_name in the SQL script. Additionally, you can add the @Column(name = "lastname") annotation on the lastName field in your Java class to ensure consistency.

Here’s an example:

@Entity
public class Person {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    @Column(name = "last_name")
    private String lastName;

    // getters and setters
}

By making these changes, you should be able to resolve the error and successfully connect to your H2 database.

Last modified on 2023-07-29