You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Alexey Ousov (JIRA)" <ji...@apache.org> on 2008/01/16 06:49:34 UTC
[jira] Created: (ODE-228) SQL scripts generated for Oracle
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
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.
[jira] Issue Comment Edited: (ODE-228) SQL scripts generated for
Oracle
Posted by "Alexey Ousov (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Resolved: (ODE-228) SQL scripts generated for Oracle
Posted by "Matthieu Riou (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matthieu Riou resolved ODE-228.
-------------------------------
Resolution: Fixed
Fix Version/s: 1.1.1
Assignee: Matthieu Riou
Thanks for the patch!
Yes we plan to drop Hibernate support at some point (not too soon though but gradually). I'm aware of the blob(2g) problem and yes it's an issue with Hibernate mappings. There's no way you can declare a blob in a way that will be mapped successfully for all tables. So we made it so that it works for Derby and MySQL first.
> 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
> Assignee: Matthieu Riou
> Priority: Minor
> Fix For: 1.1.1
>
> 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.
[jira] Updated: (ODE-228) SQL scripts generated for Oracle
Posted by "Alexey Ousov (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexey Ousov updated ODE-228:
-----------------------------
Attachment: simplesched-oracle.sql.patch
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.
[jira] Commented: (ODE-228) SQL scripts generated for Oracle
Posted by "Matthieu Riou (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12559565#action_12559565 ]
Matthieu Riou commented on ODE-228:
-----------------------------------
I don't have Oracle installed at the moment, could you give a bit more detail on which parts of the script Oracle chokes on? Is it only the blob definition?
A patch on dao-jpa-ojpa-derby/src/main/scripts/simplesched-oracle.sql would be *very* welcome :)
> 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
>
> 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.