You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Oleg Atamanenko (JIRA)" <ji...@apache.org> on 2008/06/27 08:43:45 UTC
[jira] Created: (ODE-320) Table ODE_JOB isn't created automatically
if doesn't exist.
Table ODE_JOB isn't created automatically if doesn't exist.
-----------------------------------------------------------
Key: ODE-320
URL: https://issues.apache.org/jira/browse/ODE-320
Project: ODE
Issue Type: Bug
Affects Versions: 1.1.1
Environment: Apache ODE 1.1.1
ServiceMix 3.2.1
MySQL 5
Windows XP SP2
Sun Java 5
Reporter: Oleg Atamanenko
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);
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (ODE-320) Table ODE_JOB isn't created
automatically if doesn't exist.
Posted by "Oleg Atamanenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12608672#action_12608672 ]
Oleg Atamanenko commented on ODE-320:
-------------------------------------
Gaswerk project contain needed SQL too.
https://gaswerk.svn.sourceforge.net/svnroot/gaswerk/assemblies/soa-stack/trunk/gaswerk-database/gaswerk-soa-stack-db/src/main/sql/complete-db-mysql.sql
> Table ODE_JOB isn't created automatically if doesn't exist.
> -----------------------------------------------------------
>
> Key: ODE-320
> URL: https://issues.apache.org/jira/browse/ODE-320
> Project: ODE
> Issue Type: Bug
> Affects Versions: 1.1.1
> Environment: Apache ODE 1.1.1
> ServiceMix 3.2.1
> MySQL 5
> Windows XP SP2
> Sun Java 5
> Reporter: Oleg Atamanenko
>
> 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);
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.