Glassfish example source code file (ejbtimer_oracle.sql)

This example Glassfish source code file (ejbtimer_oracle.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

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

The Glassfish ejbtimer_oracle.sql source code

CREATE TABLE EJB__TIMER__TBL (
CREATIONTIMERAW      NUMBER(19)    NOT NULL,
BLOB                 BLOB          NULL,
TIMERID              VARCHAR(256)  NOT NULL,
CONTAINERID          NUMBER(19)    NOT NULL,
OWNERID              VARCHAR(256)  NULL,
STATE                INTEGER       NOT NULL,
PKHASHCODE           INTEGER       NOT NULL,
INTERVALDURATION     NUMBER(19)    NOT NULL,
INITIALEXPIRATIONRAW NUMBER(19)    NOT NULL,
LASTEXPIRATIONRAW    NUMBER(19)    NOT NULL,
SCHEDULE             VARCHAR(255)  NULL,
CONSTRAINT PK_EJB__TIMER__TBL PRIMARY KEY (TIMERID)
)