[
https://issues.apache.org/jira/browse/ODE-228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12559820#action_12559820
]
doubleaxe edited comment on ODE-228 at 1/16/08 10:25 PM:
------------------------------------------------------------
I use the following oracle sheduler SQL script, I'm not sure if it is perfect,
but it works.
One more thing for this issue: hibernate generated script also can not be
imported into database without editing. Again because of sheduler part, but
there is also some other wrong parts.
create table LARGE_DATA (ID number(19,0) not null, BIN_DATA blob(2G),
INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID));
should be
create table LARGE_DATA (ID number(19,0) not null, BIN_DATA blob, INSERT_TIME
timestamp, MLOCK number(10,0) not null, primary key (ID));
And for
create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY
(CKEY);
identifier is too long SQL error generated.
I don't know if you plan to drop hibernate support, and I don't know if this
script also generated automatically by hibernate (and then it is hibernate
issue).
was (Author: doubleaxe):
patch for oracle sheduler script
> SQL scripts generated for Oracle
> --------------------------------
>
> Key: ODE-228
> URL: https://issues.apache.org/jira/browse/ODE-228
> Project: ODE
> Issue Type: Bug
> Components: Build System
> Affects Versions: 1.1, 1.1.1, 1.2
> Environment: Windows XP Pro, JDK 1.5.0.07, Oracle 10g XE, Apache
> Tomcat 5.5.25
> Reporter: Alexey Ousov
> Priority: Minor
> Attachments: simplesched-oracle.sql.patch
>
>
> SQL scripts for differend databases are generated by simply merging
> OpenJPA/Hibernate generated scripts with hardcoded Sheduler script. Sheduler
> script is writted for derby database only and is merged in all database
> scripts. Due to this Oracle and possybly all other database scripts become
> incorrect.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
