So what db are u using
I dont find a sql for mysql there
also I think BLOB is a keyword in MYSQL so I can't create a script that uses something that as a field name..Any ideas
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) NOT NULL,
STATE INTEGER NOT NULL,
PKHASHCODE INTEGER NOT NULL,
INTERVALDURATION BIGINT NOT NULL,
INITIALEXPIRATIONRAW BIGINT NOT NULL,
LASTEXPIRATIONRAW BIGINT NOT NULL,
CONSTRAINT PK_EJB__TIMER__TBL PRIMARY KEY (TIMERID)
)
Cheers
Priya
[Message sent by forum member 'priyasubu' (priyasubu)]
http://forums.java.net/jive/thread.jspa?messageID=250483