HSQLDB, openJPA, .. nonfatal general error ... org.apache.openjpa.persistence.PersistenceException: invalid schema name

Problem

- short message:
nonfatal general error ... org.apache.openjpa.persistence.PersistenceException: invalid schema name

- full message:
[CREATE TABLE testone.eshop_categories (category_id BIGINT NOT NULL, category_name VARCHAR(70), PRIMARY KEY (category_id))] {stmnt 1548490201 CREATE
TABLE testone.eshop_categories (category_id BIGINT NOT NULL, category_name VARCHAR(70), PRIMARY KEY (category_id))} [code=-4850, state=3F000]



Solution

Depending on the database and how you access it, for instance HSQLDB, the schema shall not be declared.
For instance, change:

@Entity
@Table(name="eshop_categories", schema="testone")
public class Category {

To

@Entity
@Table(name="eshop_categories")
public class Category {