Can't create table "system_user" in h2

91
July 01, 2022, at 00:50 AM

i am having a problem creating a simple table in h2.

create table system_user (id bigint not null, username varchar(255), primary key (id));

When executing i am getting the error:

Syntax Fehler in SQL Befehl "create table [*]system_user (id bigint not null, username varchar(255), primary key (id))"; erwartet "identifier"
Syntax error in SQL statement "create table [*]system_user (id bigint not null, username varchar(255), primary key (id))"; expected "identifier"; SQL statement:
create table system_user (id bigint not null, username varchar(255), primary key (id)) [42001-210] 42001/42001 (Hilfe)
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax Fehler in SQL Befehl "create table [*]system_user (id bigint not null, username varchar(255), primary key (id))"; erwartet "identifier"
Syntax error in SQL statement "create table [*]system_user (id bigint not null, username varchar(255), primary key (id))"; expected "identifier"; SQL statement:
create table system_user (id bigint not null, username varchar(255), primary key (id)) [42001-210]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:521)
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:496)
    at org.h2.message.DbException.getSyntaxError(DbException.java:265)
    at org.h2.command.Parser.readIdentifier(Parser.java:5759)
    at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:5719)
    at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:5748)
    at org.h2.command.Parser.parseCreateTable(Parser.java:9280)
    at org.h2.command.Parser.parseCreate(Parser.java:6779)
    at org.h2.command.Parser.parsePrepared(Parser.java:746)
    at org.h2.command.Parser.parse(Parser.java:674)
    at org.h2.command.Parser.parse(Parser.java:644)
    at org.h2.command.Parser.prepareCommand(Parser.java:551)
    at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:615)
    at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:553)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:237)
    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:223)
    at org.h2.server.web.WebApp.getResult(WebApp.java:1339)
    at org.h2.server.web.WebApp.query(WebApp.java:1137)
    at org.h2.server.web.WebApp$1.next(WebApp.java:1103)
    at org.h2.server.web.WebApp$1.next(WebApp.java:1090)
    at org.h2.server.web.WebThread.process(WebThread.java:189)
    at org.h2.server.web.WebThread.run(WebThread.java:102)
    at java.base/java.lang.Thread.run(Thread.java:833)

Does anyone have the same problem?

Rent Charter Buses Company
READ ALSO
E/ExtMediaPlayer-JNI: env->IsInstanceOf fails

E/ExtMediaPlayer-JNI: env->IsInstanceOf fails

I'm trying for a month to play an audio from https url, but every time I catch the same errorI'm new in android and I don't know what to try to fix this

112
Cyclic references when converting with MapStruct. Overflow error. Context does not work

Cyclic references when converting with MapStruct. Overflow error. Context does not work

I have 2 entities, with 1-to-1 association (ProfileEntity and VCardEntity)

118
Use Log4j1 and Log4j2 in the same project

Use Log4j1 and Log4j2 in the same project

I have a project in which Log4j1 is used all over the place, I upgraded to log4j2 but there is a jar depending on Log4j1 and I cannot change it

105
How to mock StorageOptions.newBuilder()

How to mock StorageOptions.newBuilder()

Can you help me in mocking StorageOptionsnewBuilder()

108