Help

[Yakabuff]

So I have a very simple table I made in SQL using h2

CREATE TABLE USERS(
    username varchar(255) NOT NULL,
    password varchar(255),

); 

I'm trying to use javalite to add an entry to it so I made this following the instructions on the site.

package DBTEST;

import org.javalite.activejdbc.Base;

public class makeDB {
    public static void main(String[] args) {
        Base.open("org.h2.Driver", "jdbc:h2:./test", "sa", "");

        User e = new User();
        e.set("username", "John");
        e.set("password", "Doe");
        e.saveIt();


        User.findAll().dump();
        Base.close();
    }
}

I have a class Users for this table

package DBTEST;

import org.javalite.activejdbc.Model;
import org.javalite.activejdbc.annotations.Table;

@Table("USERS")
public class User extends Model {
}

I keep getting this exception

Exception in thread "main" org.javalite.activejdbc.DBException: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "USERS" not found; SQL statement:

Can anyone help? I have no idea why this is happening

[ipolevoy]

Please, see this StackOverflow answer: https://stackoverflow.com/questions/61571370/table-not-found-exception-using-javalite/61596890#61596890

Working example with your code: https://github.com/javalite/h2-example

[Yakabuff]

Thanks for the help Igor. Much appreciated.

[ipolevoy]

@Yakabuff no problem - good luck with your project!