CREATE TABLE TEST_SCHEMA.SAVED_SEARCHES(
    SEARCHID INT GENERATED ALWAYS AS IDENTITY AUTO_INCREMENT BY 1 START WITH 1 NOT NULL,
    NAME VARCHAR2(30) NOT NULL,
    USERID VARCHAR2(32 BYTE),
    WORKGROUPID VARCHAR2(50 BYTE),
    ONECLICK VARCHAR2(1 BYTE) NOT NULL
)

<Context reloadable="true" crossContext="true">
    <Resource
        name="jdbc/cts"
        auth="Container"
        type="javax.sql.DataSource"
        removeAbandoned="true"
        removeAbandonedTimeout="30"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
        username="test_schema"
        password="oracle"
        driverClassName="com.test.h2.H2Driver"
        url="jdbc:testh2:mem:testdb;MODE=Oracle;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS TEST_SCHEMA;SET SCHEMA TEST_SCHEMA"
        validationQuery="SELECT 1 FROM DUAL"
    />
</Context>

Syntax error in SQL statement: expected "(, NOT, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement: