Glassfish example source code file (ejbtimer_db2.sql)

This example Glassfish source code file (ejbtimer_db2.sql) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - Glassfish tags/keywords

bigint, bigint, blob, constraint, integer, not, not, null, null, ownerid, pk_ejb__timer__tbl, timerid, varchar, varchar

The Glassfish ejbtimer_db2.sql source code

CREATE TABLE EJB__TIMER__TBL (
CREATIONTIMERAW      BIGINT         NOT NULL,
BLOB                 BLOB(2G)       NOT LOGGED,
TIMERID              VARCHAR(255)   NOT NULL,
CONTAINERID          BIGINT         NOT NULL,
OWNERID              VARCHAR(255)   NULL,
STATE                INTEGER        NOT NULL,
PKHASHCODE           INTEGER        NOT NULL,
INTERVALDURATION     BIGINT         NOT NULL,
INITIALEXPIRATIONRAW BIGINT         NOT NULL,
LASTEXPIRATIONRAW    BIGINT         NOT NULL,
SCHEDULE             VARCHAR(255)   NULL,
CONSTRAINT PK_EJB__TIMER__TBL PRIMARY KEY (TIMERID) 
)