|
»
»
fix for Continuum 1.3.4 to operate with Oracle RDBMS
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
fix for Continuum 1.3.4 to operate with Oracle RDBMS
by Marc Lustig
::
Rate this Message:
Here is the fix.
I patched this dirty by replacing the class files in the jar's. Continuum started up fine with an empty DB as well as with an old DB that was running with 1.2 before. Could not identify any issues. Project Groups are displayed correctly and login is successfull. No guarantee for any other side-effects thou. Apparently the maven-modules do not match the generated jar-files, so it's a bit messy. Please notice that in order to run Continuum with Oracle you also have to tune the package.jpox file. Also, note that we run the oracle6 JDBC-driver, not the oracle14 one. diff -rbwB continuum-model/src/main/java/org/apache/continuum/model/project/ProjectSummaryResult.java continuum-model.org/src/main/java/org/apache/continuum/model/p roject/ProjectSummaryResult.java 28c28 < private long thesize; --- > private long size; 30c30 < public ProjectSummaryResult( int projectGroupId, int projectState, long thesize ) --- > public ProjectSummaryResult( int projectGroupId, int projectState, long size ) 36c36 < this.thesize = thesize; --- > this.size = size; 59c59 < public long getThesize() --- > public long getSize() 61c61 < return thesize; --- > return size; 64c64 < public void setThesize( long thesize ) --- > public void setSize( long size ) 66c66 < this.thesize = thesize; --- > this.size = size; diff -rbwB continuum-store/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java 326c326 < query.setResult( "projectGroup.id as projectGroupId, state as projectState, count(state) as thesize" ); --- > query.setResult( "projectGroup.id as projectGroupId, state as projectState, count(state) as size" ); 354c354 < int size = new Long( result.getThesize()).intValue(); --- > int size = new Long( result.getSize() ).intValue(); (END) |
|
|
Re: fix for Continuum 1.3.4 to operate with Oracle RDBMS
by Emmanuel Venisse-2
::
Rate this Message:
Hi Marc,
I think it would be better to use an ORM file like the one we have for MSSQL : https://svn.apache.org/repos/asf/continuum/branches/continuum-1.3.x/continuum-model/src/main/resources/package-mssql.orm Can you try to do it instead of your patch? Thanks Emmanuel On Tue, Sep 22, 2009 at 11:25 AM, Marc Lustig <ml@...> wrote: > > Here is the fix. > I patched this dirty by replacing the class files in the jar's. Continuum > started up fine with an empty DB as well as with an old DB that was running > with 1.2 before. Could not identify any issues. Project Groups are > displayed > correctly and login is successfull. No guarantee for any other side-effects > thou. > > Apparently the maven-modules do not match the generated jar-files, so it's > a > bit messy. > > Please notice that in order to run Continuum with Oracle you also have to > tune the package.jpox file. > Also, note that we run the oracle6 JDBC-driver, not the oracle14 one. > > > diff -rbwB > > continuum-model/src/main/java/org/apache/continuum/model/project/ProjectSummaryResult.java > continuum-model.org/src/main/java/org/apache/continuum/model/p > roject/ProjectSummaryResult.java > 28c28<http://continuum-model.org/src/main/java/org/apache/continuum/model/p%0Aroject/ProjectSummaryResult.java%0A28c28> > < private long thesize; > --- > > private long size; > 30c30 > < public ProjectSummaryResult( int projectGroupId, int projectState, > long thesize ) > --- > > public ProjectSummaryResult( int projectGroupId, int projectState, > > long size ) > 36c36 > < this.thesize = thesize; > --- > > this.size = size; > 59c59 > < public long getThesize() > --- > > public long getSize() > 61c61 > < return thesize; > --- > > return size; > 64c64 > < public void setThesize( long thesize ) > --- > > public void setSize( long size ) > 66c66 > < this.thesize = thesize; > --- > > this.size = size; > > > diff -rbwB > continuum-store/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java > > continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java > 326c326<http://continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java%0A326c326> > < query.setResult( "projectGroup.id as projectGroupId, state as > projectState, count(state) as thesize" ); > --- > > query.setResult( "projectGroup.id as projectGroupId, state as > > projectState, count(state) as size" ); > 354c354 > < int size = new Long( result.getThesize()).intValue(); > --- > > int size = new Long( result.getSize() ).intValue(); > (END) > > -- > View this message in context: > http://www.nabble.com/fix-for-Continuum-1.3.4-to-operate-with-Oracle-RDBMS-tp25530641p25530641.html > Sent from the Continuum - Dev mailing list archive at Nabble.com. > > |
|
|
Re: fix for Continuum 1.3.4 to operate with Oracle RDBMS
by Marc Lustig
::
Rate this Message:
Hi Emmanuel,
is the ProjectSummaryResult.java auto-generated based on the model? The ProjectDaoImpl.java is surely not generated and needs to be patched anyway. Marc
|
|
|
Re: fix for Continuum 1.3.4 to operate with Oracle RDBMS
by Emmanuel Venisse-2
::
Rate this Message:
They aren't generated.
Sorry, I misread your patch, so I'm agree now, the "size" must be renamed. On Thu, Sep 24, 2009 at 1:44 PM, Marc Lustig <ml@...> wrote: > > Hi Emmanuel, > > is the ProjectSummaryResult.java auto-generated based on the model? > The ProjectDaoImpl.java is surely not generated and needs to be patched > anyway. > > Marc > > > > Emmanuel Venisse-2 wrote: > > > > Hi Marc, > > > > I think it would be better to use an ORM file like the one we have for > > MSSQL > > : > > > https://svn.apache.org/repos/asf/continuum/branches/continuum-1.3.x/continuum-model/src/main/resources/package-mssql.orm > > > > Can you try to do it instead of your patch? > > Thanks > > > > Emmanuel > > > > On Tue, Sep 22, 2009 at 11:25 AM, Marc Lustig <ml@...> wrote: > > > >> > >> Here is the fix. > >> I patched this dirty by replacing the class files in the jar's. > Continuum > >> started up fine with an empty DB as well as with an old DB that was > >> running > >> with 1.2 before. Could not identify any issues. Project Groups are > >> displayed > >> correctly and login is successfull. No guarantee for any other > >> side-effects > >> thou. > >> > >> Apparently the maven-modules do not match the generated jar-files, so > >> it's > >> a > >> bit messy. > >> > >> Please notice that in order to run Continuum with Oracle you also have > to > >> tune the package.jpox file. > >> Also, note that we run the oracle6 JDBC-driver, not the oracle14 one. > >> > >> > >> diff -rbwB > >> > >> > continuum-model/src/main/java/org/apache/continuum/model/project/ProjectSummaryResult.java > >> continuum-model.org/src/main/java/org/apache/continuum/model/p > >> roject/ProjectSummaryResult.java > >> 28c28< > http://continuum-model.org/src/main/java/org/apache/continuum/model/p%0Aroject/ProjectSummaryResult.java%0A28c28 > > > >> < private long thesize; > >> --- > >> > private long size; > >> 30c30 > >> < public ProjectSummaryResult( int projectGroupId, int projectState, > >> long thesize ) > >> --- > >> > public ProjectSummaryResult( int projectGroupId, int projectState, > >> > long size ) > >> 36c36 > >> < this.thesize = thesize; > >> --- > >> > this.size = size; > >> 59c59 > >> < public long getThesize() > >> --- > >> > public long getSize() > >> 61c61 > >> < return thesize; > >> --- > >> > return size; > >> 64c64 > >> < public void setThesize( long thesize ) > >> --- > >> > public void setSize( long size ) > >> 66c66 > >> < this.thesize = thesize; > >> --- > >> > this.size = size; > >> > >> > >> diff -rbwB > >> > continuum-store/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java > >> > >> > continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java > >> 326c326< > http://continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java%0A326c326 > > > >> < query.setResult( "projectGroup.id as projectGroupId, state > >> as > >> projectState, count(state) as thesize" ); > >> --- > >> > query.setResult( "projectGroup.id as projectGroupId, state > >> as > >> > projectState, count(state) as size" ); > >> 354c354 > >> < int size = new Long( result.getThesize()).intValue(); > >> --- > >> > int size = new Long( result.getSize() ).intValue(); > >> (END) > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/fix-for-Continuum-1.3.4-to-operate-with-Oracle-RDBMS-tp25530641p25530641.html > >> Sent from the Continuum - Dev mailing list archive at Nabble.com. > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/fix-for-Continuum-1.3.4-to-operate-with-Oracle-RDBMS-tp25530641p25560046.html > Sent from the Continuum - Dev mailing list archive at Nabble.com. > > |
|
|
Re: fix for Continuum 1.3.4 to operate with Oracle RDBMS
by Emmanuel Venisse-2
::
Rate this Message:
Can you file an issue for this point?
Emmanuel On Thu, Sep 24, 2009 at 2:52 PM, Emmanuel Venisse < emmanuel.venisse@...> wrote: > They aren't generated. > > Sorry, I misread your patch, so I'm agree now, the "size" must be renamed. > > > On Thu, Sep 24, 2009 at 1:44 PM, Marc Lustig <ml@...> wrote: > >> >> Hi Emmanuel, >> >> is the ProjectSummaryResult.java auto-generated based on the model? >> The ProjectDaoImpl.java is surely not generated and needs to be patched >> anyway. >> >> Marc >> >> >> >> Emmanuel Venisse-2 wrote: >> > >> > Hi Marc, >> > >> > I think it would be better to use an ORM file like the one we have for >> > MSSQL >> > : >> > >> https://svn.apache.org/repos/asf/continuum/branches/continuum-1.3.x/continuum-model/src/main/resources/package-mssql.orm >> > >> > Can you try to do it instead of your patch? >> > Thanks >> > >> > Emmanuel >> > >> > On Tue, Sep 22, 2009 at 11:25 AM, Marc Lustig <ml@...> >> wrote: >> > >> >> >> >> Here is the fix. >> >> I patched this dirty by replacing the class files in the jar's. >> Continuum >> >> started up fine with an empty DB as well as with an old DB that was >> >> running >> >> with 1.2 before. Could not identify any issues. Project Groups are >> >> displayed >> >> correctly and login is successfull. No guarantee for any other >> >> side-effects >> >> thou. >> >> >> >> Apparently the maven-modules do not match the generated jar-files, so >> >> it's >> >> a >> >> bit messy. >> >> >> >> Please notice that in order to run Continuum with Oracle you also have >> to >> >> tune the package.jpox file. >> >> Also, note that we run the oracle6 JDBC-driver, not the oracle14 one. >> >> >> >> >> >> diff -rbwB >> >> >> >> >> continuum-model/src/main/java/org/apache/continuum/model/project/ProjectSummaryResult.java >> >> continuum-model.org/src/main/java/org/apache/continuum/model/p >> >> roject/ProjectSummaryResult.java >> >> 28c28< >> http://continuum-model.org/src/main/java/org/apache/continuum/model/p%0Aroject/ProjectSummaryResult.java%0A28c28 >> > >> >> < private long thesize; >> >> --- >> >> > private long size; >> >> 30c30 >> >> < public ProjectSummaryResult( int projectGroupId, int >> projectState, >> >> long thesize ) >> >> --- >> >> > public ProjectSummaryResult( int projectGroupId, int >> projectState, >> >> > long size ) >> >> 36c36 >> >> < this.thesize = thesize; >> >> --- >> >> > this.size = size; >> >> 59c59 >> >> < public long getThesize() >> >> --- >> >> > public long getSize() >> >> 61c61 >> >> < return thesize; >> >> --- >> >> > return size; >> >> 64c64 >> >> < public void setThesize( long thesize ) >> >> --- >> >> > public void setSize( long size ) >> >> 66c66 >> >> < this.thesize = thesize; >> >> --- >> >> > this.size = size; >> >> >> >> >> >> diff -rbwB >> >> >> continuum-store/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java >> >> >> >> >> continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java >> >> 326c326< >> http://continuum-store.org/src/main/java/org/apache/continuum/dao/ProjectDaoImpl.java%0A326c326 >> > >> >> < query.setResult( "projectGroup.id as projectGroupId, >> state >> >> as >> >> projectState, count(state) as thesize" ); >> >> --- >> >> > query.setResult( "projectGroup.id as projectGroupId, >> state >> >> as >> >> > projectState, count(state) as size" ); >> >> 354c354 >> >> < int size = new Long( result.getThesize()).intValue(); >> >> --- >> >> > int size = new Long( result.getSize() ).intValue(); >> >> (END) >> >> >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/fix-for-Continuum-1.3.4-to-operate-with-Oracle-RDBMS-tp25530641p25530641.html >> >> Sent from the Continuum - Dev mailing list archive at Nabble.com. >> >> >> >> >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/fix-for-Continuum-1.3.4-to-operate-with-Oracle-RDBMS-tp25530641p25560046.html >> Sent from the Continuum - Dev mailing list archive at Nabble.com. >> >> > |
| Free embeddable forum powered by Nabble | Forum Help |
