PostgreSQL and Glassfish EJB__TIMER__TBL table

Question

I'm trying to use the timer service provided by Glassfish. Thus, I have to create a table named `EJB__TIMER__TBL` and configure jdbc resource in Glassfish. I want to store this table on postgreSQL on a schema named `glassfish`. So my ddl is this one (I replace the `BLOB` type to `BYTEA`) : ``` CREATE SCHEMA glassfish; 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) ); DROP ROLE IF EXISTS glassfish; CREATE ROLE glassfish WITH NOINHERIT LOGIN PASSWORD '...'; REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA glassfish FROM glassfish; REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA glassfish FROM glassf…

Accepted Answer

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") 
);
```

PostgreSQL and Glassfish EJBTIMERTBL table

Solution

Problem