Skip to content

GitLab

Open
Created by Moritz Schott@moritzMaintainer

Handle case when output-db already exists

The following error is thrown if the output-db already exists:

Exception in thread "main" org.h2.jdbc.JdbcSQLException: Tabelle "METADATA" besteht bereits
Table "METADATA" already exists; SQL statement:

CREATE CACHED TABLE PUBLIC.METADATA(
    KEY VARCHAR NOT NULL,
    VALUE VARCHAR
) [42101-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.command.ddl.CreateTable.update(CreateTable.java:115)
	at org.h2.command.CommandContainer.update(CommandContainer.java:98)
	at org.h2.command.Command.executeUpdate(Command.java:258)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
	at org.h2.tools.RunScript.execute(RunScript.java:170)
	at org.heigit.ohsome.clustertools.CreateH2Extract.main(CreateH2Extract.java:89)

this is ok but better error messages might exist