[ODE-320] Table ODE_JOB isn't created automatically if doesn't exist.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.1.1
• Fix Version/s: Wishlist
• Environment: Apache ODE 1.1.1; ServiceMix 3.2.1; MySQL 5; Windows XP SP2; Sun Java 5
• Assignee: Unassigned
• Reporter: Oleg Atamanenko
• Created: 27/Jun/08 06:42
• Updated: 10/Feb/11 19:07
• Resolved: 10/Feb/11 19:07

Description

The table ODE_JOB isn't created in database during first deployment..

CREATE TABLE ODE_JOB(jobid CHAR(64) DEFAULT '' NOT NULL,
ts BIGINT DEFAULT 0 NOT NULL ,
nodeid char(64) NULL,
scheduled int DEFAULT 0 NOT NULL,
transacted int DEFAULT 0 NOT NULL,
details LONG VARBINARY NULL,
PRIMARY KEY(jobid));
CREATE INDEX IDX_ODE_JOB_TS ON ODE_JOB (ts);
CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB (nodeid);

Issue Links

• duplicates: ODE-319 Automatically create tables upon first deployment in JBI environment.