[ 
https://issues.apache.org/jira/browse/OOZIE-750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13225420#comment-13225420
 ] 

[email protected] commented on OOZIE-750:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4258/
-----------------------------------------------------------

Review request for oozie.


Summary
-------

Currently the upgrade tool requires a manual step to alter a column length 
after doing and upgrade. 

It was done this way because OpenJPA schematool ignores the column length 
modification. 

the ooziedb tool should use direct JDBC with the corresponding syntax for each 
DB. 

In addition, the -sqlfile FILE option should not be required, and if not 
provide the sql scripts should be written to a file in /tmp.


This addresses bug OOZIE-750.
    https://issues.apache.org/jira/browse/OOZIE-750


Diffs
-----

  trunk/docs/src/site/twiki/AG_Install.twiki 1298503 
  trunk/docs/src/site/twiki/AG_OozieUpgrade.twiki 1298503 
  trunk/tools/src/main/java/org/apache/oozie/tools/OozieDBCLI.java 1298503 

Diff: https://reviews.apache.org/r/4258/diff


Testing
-------

manually tested against derby/mysql5.0/oracle11/postgres9


Thanks,

Alejandro


                
> enhance ooziedb tool not to require manual upgrade steps and not to require 
> the -sqlfile option
> -----------------------------------------------------------------------------------------------
>
>                 Key: OOZIE-750
>                 URL: https://issues.apache.org/jira/browse/OOZIE-750
>             Project: Oozie
>          Issue Type: Improvement
>          Components: tools
>    Affects Versions: 3.2.0
>            Reporter: Alejandro Abdelnur
>            Assignee: Alejandro Abdelnur
>             Fix For: 3.2.0
>
>
> Currently the upgrade tool requires a manual step to alter a column length 
> after doing and upgrade.
> It was done this way because OpenJPA schematool ignores the column length 
> modification.
> the ooziedb tool should use direct JDBC with the corresponding syntax for 
> each DB.
> In addition, the -sqlfile FILE option should not be required, and if not 
> provide the sql scripts should be written to a file in /tmp.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to