Hi Noel, thanks for the reply.
This is the full stacktrace of the error
SQL Error [90043] [90043]: Error creating or initializing trigger
"MY_TRIGGER" object, class "..source..", cause: "org.h2.message.DbException:
Syntax error in SQL statement ""
org.h2.api.Trigger create() {
return new org.h2.api.Trigger() {
@Override
public void remove() throws SQLException {
}
@Override
public void init(Connection conn, String schemaName, String
triggerName, String tableName, boolean before,
int type) throws SQLException {
}
@Override
public void fire(Connection conn, Object[] oldRow, Object[]
newRow) throws SQLException {
}
@Override
public void close() throws SQLException {
}
};
} "" [42000-193]"; see root cause for details; SQL statement:
CREATE TRIGGER MY_TRIGGER BEFORE INSERT ON CURRENT_APPLICATION_PROPERTY AS
$$
org.h2.api.Trigger create() {
return new org.h2.api.Trigger() {
@Override
public void remove() throws SQLException {
}
@Override
public void init(Connection conn, String schemaName, String
triggerName, String tableName, boolean before,
int type) throws SQLException {
}
@Override
public void fire(Connection conn, Object[] oldRow, Object[]
newRow) throws SQLException {
}
@Override
public void close() throws SQLException {
}
};
} $$ [90043-193]
Error creating or initializing trigger "MY_TRIGGER" object, class
"..source..", cause: "org.h2.message.DbException: Syntax error in SQL
statement ""
org.h2.api.Trigger create() {
return new org.h2.api.Trigger() {
@Override
public void remove() throws SQLException {
}
@Override
public void init(Connection conn, String schemaName, String
triggerName, String tableName, boolean before,
int type) throws SQLException {
}
@Override
public void fire(Connection conn, Object[] oldRow, Object[]
newRow) throws SQLException {
}
@Override
public void close() throws SQLException {
}
};
} "" [42000-193]"; see root cause for details; SQL statement:
CREATE TRIGGER MY_TRIGGER BEFORE INSERT ON CURRENT_APPLICATION_PROPERTY AS
$$
org.h2.api.Trigger create() {
return new org.h2.api.Trigger() {
@Override
public void remove() throws SQLException {
}
@Override
public void init(Connection conn, String schemaName, String
triggerName, String tableName, boolean before,
int type) throws SQLException {
}
@Override
public void fire(Connection conn, Object[] oldRow, Object[]
newRow) throws SQLException {
}
@Override
public void close() throws SQLException {
}
};
} $$ [90043-193]
Syntax error in SQL statement "
org.h2.api.Trigger create() {
return new org.h2.api.Trigger() {
@Override
public void remove() throws SQLException {
}
@Override
public void init(Connection conn, String schemaName, String
triggerName, String tableName, boolean before,
int type) throws SQLException {
}
@Override
public void fire(Connection conn, Object[] oldRow, Object[]
newRow) throws SQLException {
}
@Override
public void close() throws SQLException {
}
};
} " [42000-193]
Syntax error in SQL statement "
org.h2.api.Trigger create() {
return new org.h2.api.Trigger() {
@Override
public void remove() throws SQLException {
}
@Override
public void init(Connection conn, String schemaName, String
triggerName, String tableName, boolean before,
int type) throws SQLException {
}
@Override
public void fire(Connection conn, Object[] oldRow, Object[]
newRow) throws SQLException {
}
@Override
public void close() throws SQLException {
}
};
} " [42000-193]
java.lang.NullPointerException:
Il giorno mercoledì 22 marzo 2017 12:13:34 UTC+1, Noel Grandin ha scritto:
>
> what does the rest of the exception trace look like?
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
