PostgreSQL and Glassfish EJB__TIMER__TBL table PostgreSQL and Glassfish EJB__TIMER__TBL table postgresql postgresql

PostgreSQL and Glassfish EJB__TIMER__TBL table


Ok I found the solution of my problem.

I didn't know that SQL can be case sensitive. Glassfish calls SELECT ... FROM "EJB__TIMER__TBL" with double quotes so I have to create a table named "EJB__TIMER__TBL" not "ejb__timer__tbl" or anything else.

The workaround is just to recreate my table with double quotes :

CREATE TABLE glassfish."EJB__TIMER__TBL" ("CREATIONTIMERAW"      BIGINT        NOT NULL,"BLOB"                 BYTEA,"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,"APPLICATIONID"        BIGINT        NOT NULL,CONSTRAINT "PK_EJB__TIMER__TBL" PRIMARY KEY ("TIMERID") );