Java Doc for ErrorCode.java in  » Database-DBMS » h2database » org » h2 » constant » Java Source Code / Java DocumentationJava Source Code and Java Documentation

 DROP AGGREGATE UNKNOWN;
 

 CREATE TABLE PARENT(ID INT, NAME VARCHAR);
 CREATE TABLE CHILD(PID INT, NAME VARCHAR);
 SELECT ID, NAME FROM PARENT P, CHILD C WHERE P.ID = C.PID;
 

 CREATE TABLE COUNT(X INT);
 CREATE TABLE ITEMS(ID INT DEFAULT SELECT MAX(X)+1 FROM COUNT);
 DROP TABLE COUNT;
 

 DROP USER SA;
 

 CREATE TABLE TEST(ID INT);
 ALTER TABLE TEST DROP COLUMN ID;
 

 DROP TABLE INFORMATION_SCHEMA.SETTINGS;
 

 SELECT ?, ?1 FROM DUAL;
 

 TRUNCATE TABLE INFORMATION_SCHEMA.SETTINGS;
 

 SELECT AMOUNT, SET(@V, IFNULL(@V, 0)+AMOUNT) FROM TEST;
 

 CREATE TABLE TEST(ID INT CHECK ID>0);
 INSERT INTO TEST VALUES(0);
 

 CREATE ALIAS TEST FOR "java.lang.invalid.Math.sqrt";
 

 CREATE TABLE TEST(NAME VARCHAR PRIMARY KEY);
 INSERT INTO TEST VALUES('Hello', 'World');
 SET COLLATION DE;
 Collation cannot be changed because there is a data table: PUBLIC.TEST
 

 SET COLLATION DE;
 CREATE TABLE TEST(NAME VARCHAR PRIMARY KEY);
 INSERT INTO TEST VALUES('Hello', 'World');
 

 CREATE TABLE TEST(ID INT);
 INSERT INTO TEST VALUES(NULL);
 ALTER TABLE TEST ALTER COLUMN ID VARCHAR NOT NULL;
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR);
 INSERT INTO TEST VALUES('Hello');
 

 CREATE TABLE TEST(ID INT PRIMARY KEY);
 ALTER TABLE TEST ALTER COLUMN ID NULL;
 

 CREATE TABLE TEST(ID INT, PID INT REFERENCES(ID));
 ALTER TABLE TEST DROP COLUMN PID;
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR);
 ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY(ID);
 

 CREATE TABLE TEST(ID INT);
 SELECT NAME FROM TEST;
 

 CALL EXPAND(X'00FF');
 

 jdbc:h2:~/test;MVCC=TRUE
 Session 1:
 CREATE TABLE TEST(ID INT);
 INSERT INTO TEST VALUES(1);
 SET AUTOCOMMIT FALSE;
 UPDATE TEST SET ID = 2;
 Session 2:
 SET AUTOCOMMIT FALSE;
 UPDATE TEST SET ID = 3;
 

 CREATE CONSTANT TEST VALUE 1;
 CREATE CONSTANT TEST VALUE 1;
 

 DROP CONSTANT UNKNOWN;
 

 CREATE TABLE TEST(ID INT NOT NULL);
 ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY(ID);
 ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY(ID);
 

 CREATE TABLE TEST(ID INT);
 ALTER TABLE TEST DROP CONSTRAINT CID;
 

• In embedded mode (URL of the form jdbc:h2:~/test) if all connections are opened within the same process and class loader.
• In server and cluster mode (URL of the form jdbc:h2:tcp://localhost/test) using remote connections.

 SET EXCLUSIVE TRUE;
 

 jdbc:h2:mem:
 BACKUP TO 'test.zip';
 

 jdbc:h2:~/test;ACCESS_MODE_DATA=R
 CREATE TABLE TEST(ID INT);
 

 CREATE TABLE TEST(ID INT);
 SELECT XYZ.PUBLIC.TEST.ID FROM TEST;
 

 CALL CAST(DATE '2001-01-01' AS BOOLEAN);
 CALL CAST('CHF 99.95' AS INT);
 

 CALL DATE '2007-January-01';
 

 CALL 1/0;
 

 CREATE TABLE TEST(ID INT, ID INT);
 

 CREATE TABLE TEST(ID INT PRIMARY KEY);
 INSERT INTO TEST VALUES(1);
 INSERT INTO TEST VALUES(1);
 

 jdbc:h2:~/test;LOG=0;LOG=1
 

 CREATE TABLE TEST(ID INT);
 CREATE TRIGGER TRIGGER_A AFTER INSERT ON TEST
 CALL "java.lang.String";
 

 jdbc:h2:˜/test;DATABASE_EVENT_LISTENER='java.lang.String'
 

 CREATE ALIAS SYS_PROP FOR "java.lang.System.getProperty";
 CALL SYS_PROP(NULL);
 

 CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
 

 DROP ALIAS SQRT;
 

 SELECT * FROM SIN(1);
 

 CALL SPECIAL_SIN(10);
 

 CALL X'00023';
 Hexadecimal string with odd number of characters: 00023
 

 CALL X'000023';
 

 CALL X'ABCDEFGH';
 CALL CAST('ABCDEFGH' AS BINARY);
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR);
 CREATE INDEX IDX_ID ON TEST(ID);
 CREATE TABLE ADDRESS(ID INT);
 CREATE INDEX IDX_ID ON ADDRESS(ID);
 

 CREATE TABLE TEST(ID INT, CONSTRAINT UID UNIQUE(ID));
 DROP INDEX UID_INDEX_0;
 Index UID_INDEX_0 belongs to a constraint
 

 ALTER TABLE TEST DROP CONSTRAINT UID;
 

 DROP INDEX ABC;
 

 BigDecimal bd = new MyDecimal("$10.3");
 prep.setBigDecimal(1, bd);
 Invalid class, expected java.math.BigDecimal but got MyDecimal
 

 BigDecimal bd = new BigDecimal("10.3");
 prep.setBigDecimal(1, bd);
 

 CALL ABS(1, 2)
 

 CREATE TABLE TEST(ID INT);
 INSERT INTO TEST VALUES(1), (2);
 SELECT MAX(ID) FROM TEST WHERE ID = MAX(ID) GROUP BY ID;
 

 CREATE SEQUENCE TEST INCREMENT 0;
 

 CALL 'Hello' LIKE '1+' ESCAPE '+';
 

 SET ALLOW_LITERALS NONE;
 CALL 1+1;
 

 CREATE TABLE TEST(ID INT);
 -- connection 1:
 SET AUTOCOMMIT FALSE;
 INSERT INTO TEST VALUES(1);
 -- connection 2:
 SET AUTOCOMMIT FALSE;
 INSERT INTO TEST VALUES(1);
 

 PreparedStatement prep = conn.prepareStatement("SELECT * FROM TEST");
 prep.execute("DELETE FROM TEST");
 

 Statement stat = conn.createStatement();
 stat.execute("DELETE FROM TEST");
 

 CREATE ALIAS TEST FOR "java.lang.Math.test";
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR);
 INSERT INTO TEST VALUES(1, 'Hello'), (2, 'World');
 SELECT ID, MAX(NAME) FROM TEST;
 Column ID must be in the GROUP BY list.
 

 SELECT ID, MAX(NAME) FROM TEST GROUP BY ID;
 

 ResultSet rs = stat.executeQuery("SELECT * FROM TEST");
 rs.next();
 rs.insertRow();
 

 ResultSet rs = stat.executeQuery("SELECT * FROM DUAL");
 rs.getString(1);
 

 ResultSet rs = stat.executeQuery("SELECT * FROM DUAL");
 rs.next();
 rs.getString(1);
 

 CREATE TABLE TEST(ID INT, PARENT INT);
 INSERT INTO TEST VALUES(1, 1), (2, 1);
 ALTER TABLE TEST ADD CONSTRAINT TEST_ID_PARENT
 FOREIGN KEY(PARENT) REFERENCES(ID) ON DELETE SET DEFAULT;
 DELETE FROM TEST WHERE ID=1;
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR NOT NULL);
 INSERT INTO TEST(ID) VALUES(1);
 

 CALL CAST(1000000 AS TINYINT);
 

 CREATE TABLE TEST(ID INT);
 CREATE VIEW TEST_VIEW AS SELECT * FROM TEST;
 ALTER TABLE TEST ADD COLUMN NAME VARCHAR;
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR);
 INSERT INTO TEST VALUES(2, 'Hello'), (1, 'Hello');
 SELECT DISTINCT NAME FROM TEST ORDER BY ID;
 Order by expression ID must be in the result list in this case
 

 SELECT DISTINCT ID, NAME FROM TEST ORDER BY ID;
 

 CALL -CAST(-128 AS TINYINT);
 

 CALL SIN(?);
 

 CALL PARSEDATETIME('2001 January', 'yyyy mm');
 

 CREATE TABLE PARENT(ID INT);
 CREATE TABLE CHILD(P_ID INT REFERENCES PARENT(ID));
 INSERT INTO PARENT VALUES(1);
 INSERT INTO CHILD VALUES(1);
 DELETE FROM PARENT;
 

 CREATE TABLE PARENT(ID INT);
 CREATE TABLE CHILD(P_ID INT REFERENCES PARENT(ID));
 INSERT INTO CHILD VALUES(1);
 

 java org.h2.tools.Server -tcp -tcpAllowOthers true
 

 Server server = Server.createTcpServer(new String[] { 
 "-tcpAllowOthers", "true" });
 server.start();
 

 rs.first();
 

 CREATE USER TEST_USER PASSWORD 'abc';
 REVOKE SELECT ON TEST FROM TEST_USER;
 

 GRANT SELECT, TEST_ROLE ON TEST TO SA;
 

 CREATE ROLE TEST_ROLE;
 CREATE ROLE TEST_ROLE;
 

 CREATE ROLE TEST_ROLE;
 GRANT TEST_ROLE TO SA;
 GRANT TEST_ROLE TO SA;
 

 DROP ROLE PUBLIC;
 

 DROP ROLE TEST_ROLE_2;
 

 Row not found when trying to delete from index UID_INDEX_0
 

 ROLLBACK TO SAVEPOINT S_UNKNOWN;
 

 Savepoint sp = conn.setSavepoint("Joe");
 sp.getSavepointId();
 

 Savepoint sp = conn.setSavepoint();
 sp.getSavepointName();
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR);
 INSERT INTO TEST VALUES(1, 'Hello'), (1, 'World');
 SELECT X, (SELECT NAME FROM TEST WHERE ID=X) FROM DUAL;
 

 CREATE SCHEMA TEST_SCHEMA;
 CREATE SCHEMA TEST_SCHEMA;
 

 DROP SCHEMA PUBLIC;
 

 CREATE SCHEMA TEST_SCHEMA;
 CREATE TABLE TEST(ID INT);
 CREATE INDEX TEST_ID ON TEST(ID);
 ALTER INDEX TEST_ID RENAME TO TEST_SCHEMA.IDX_TEST_ID;
 

 DROP SCHEMA UNKNOWN;
 

 CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR);
 ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY(NAME);
 

 CREATE SEQUENCE TEST_SEQ;
 CREATE SEQUENCE TEST_SEQ;
 

 SELECT NEXT VALUE FOR SEQUENCE XYZ;
 

 stat.setQueryTimeout(1);
 stat.cancel();
 

 CALL STRINGDECODE('\i');
 

 CREATE TABLE TEST(ID INT);
 INSERT INTO TEST VALUES(1), (2);
 SELECT * FROM TEST WHERE ID IN (SELECT 1, 2 FROM DUAL);
 

 CREATE TABLE TEST(ID INT);
 INSERT INTO TEST VALUES(1), (2);
 SELECT * FROM TEST WHERE ID IN (1, 2);
 

 SELECT SUM('Hello') FROM DUAL;
 

 CREATE ALIAS REMAINDER FOR "IEEEremainder";
 

 CREATE TABLE TEST(ID INT);
 INSERT INTO TEST(1);
 

 CREATE TABLE TEST(ID INT);
 CREATE TABLE TEST(ID INT PRIMARY KEY);
 

 SELECT * FROM ABC;
 

 CALL TIMESTAMP '2001-02-30 12:00:00';
 

 CALL TIME '14:61:00';
 

 Connection conn;
 conn = DriverManager.getConnection("jdbc:h2:˜/test");
 conn = null;
 The connection was not closed by the application and is 
 garbage collected
 

 conn.close();
 

 PREPARE COMMIT ABC;
 COMMIT TRANSACTION TEST;
 

 CREATE TABLE TEST(ID INT);
 CREATE TRIGGER TRIGGER_A AFTER INSERT ON TEST
 CALL "org.h2.samples.TriggerSample$MyTrigger";
 CREATE TRIGGER TRIGGER_A AFTER INSERT ON TEST
 CALL "org.h2.samples.TriggerSample$MyTrigger";
 

 DROP TRIGGER TRIGGER_XYZ;
 

 CREATE TABLE TEST(ID VERYSMALLINT);
 

 SET MODE UNKNOWN;
 

 jdbc:h2:~/test;CIPHER=DES
 

 CALL COMPRESS(STRINGTOUTF8(SPACE(100)), 'BZIP');
 

 CALL COMPRESS(STRINGTOUTF8(SPACE(100)), 'DEFLATE l 10');
 

 CALL COMPRESS(STRINGTOUTF8(SPACE(100)), 'DEFLATE l 9');
 

 jdbc:h2:~/test;FILE_LOCK=LDAP
 

 SELECT * FROM DUAL A LEFT JOIN DUAL B ON B.X=(SELECT MAX(X) FROM DUAL);
 

 jdbc:h2:~/test;UNKNOWN=TRUE
 

 jdbc:h2:;;
 

 CREATE USER TEST_USER;
 CREATE USER TEST_USER;
 

 CREATE DOMAIN EMAIL AS VARCHAR CHECK LOCATE('@', VALUE) > 0;
 CREATE DOMAIN EMAIL AS VARCHAR CHECK LOCATE('@', VALUE) > 0;
 

 DROP DOMAIN UNKNOWN;
 

 DROP USER TEST_USER;
 

 GRANT SELECT ON TEST TO UNKNOWN;
 

 SELECT * FROM TABLE(X DECIMAL(2, 2) = (123.34));
 

 CREATE TABLE TEST(ID INT, NAME VARCHAR(2));
 INSERT INTO TEST VALUES(1, 'Hello');
 

 CREATE VIEW DUMMY AS SELECT * FROM DUAL;
 CREATE VIEW DUMMY AS SELECT * FROM DUAL;
 

 CREATE FORCE VIEW TEST_VIEW AS SELECT * FROM TEST;
 SELECT * FROM TEST_VIEW;
 

 DROP VIEW XYZ;
 

 String url = "jdbc:h2:˜/test;CIPHER=AES";
 String passwords = "filePasswordUserPassword";
 DriverManager.getConnection(url, "sa", pwds);
 

 String url = "jdbc:h2:˜/test;CIPHER=AES";
 String passwords = "filePassword userPassword";
 DriverManager.getConnection(url, "sa", pwds);