gPUZGpHT

1CREATE TABLE TEST_SCHEMA.SAVED_SEARCHES(
2    SEARCHID INT GENERATED ALWAYS AS IDENTITY AUTO_INCREMENT BY 1 START WITH 1 NOT NULL, 
3    NAME VARCHAR2(30) NOT NULL,
4    USERID VARCHAR2(32 BYTE), 
5    WORKGROUPID VARCHAR2(50 BYTE), 
6    ONECLICK VARCHAR2(1 BYTE) NOT NULL
7)
8	
9<Context reloadable="true" crossContext="true">
10    <Resource 
11        name="jdbc/cts" 
12        auth="Container" 
13        type="javax.sql.DataSource" 
14        removeAbandoned="true" 
15        removeAbandonedTimeout="30" 
16        maxActive="100" 
17        maxIdle="30" 
18        maxWait="10000" 
19        username="test_schema"  
20        password="oracle" 
21        driverClassName="com.test.h2.H2Driver" 
22        url="jdbc:testh2:mem:testdb;MODE=Oracle;DB_CLOSE_DELAY=-1;INIT=CREATE SCHEMA IF NOT EXISTS TEST_SCHEMA;SET SCHEMA TEST_SCHEMA" 
23        validationQuery="SELECT 1 FROM DUAL" 
24    />
25</Context>
26	
27Syntax error in SQL statement: expected "(, NOT, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement: