Alfresco 3 Stable oracle upgrade db script

[skorde]

Hi
I am using alfresco 2.1 CE with oracle db and I want to upgrade it to Alfresco 3 Stable version.While upgrade , I am getting following error

The schema script could not be found at location classpath:alfresco/dbscripts/upgrade/2.2/${db.script.dialect}/AlfrescoSchemaUpdate-2.2-ACL.sql

Could you please provide me oracle upgrade schema script so that I can upgrade my community version to stable version

[mikeh]

I'm not the database guy, so don't know what state the upgrade scripts are in for Oracle. I suspect the answer will be "use MySQL instead" however.

Mike

[sameer1sharma]

Dear Mike,
       I bought Oracle 11G for using it with Alfresco2.1 CE. Now if I have to migrate to MySQL for using Alfresco3 Labs then tell me what to do with purchased Oracle license? Will you give me some light what could I do…
:-Sameer

[ed_mann]

Sameer,
There is an entry where the proprietary databases would not be supported in the open version. You will need to pay for that support.

Mike,

"use MySQL instead" that's just nuts. Is this project slowly going back to a "proprietary" product?  As i look around and hang out in the ##alfresco channel on freenode, i don't see many community participants. I had planed on getting involved after the 3.2 release so i could coordinate point release to get fixes out, and help with a community build system to run the unit tests. However i have read that there are two separate source repositories.  If this is true i can understand why people don't help out. I would like some clarification on that. Hopefully that has changed for the better.

[sameer1sharma]

Hi,
   Will you tell me how much I've to pay?

[ed_mann]

Sameer,

You will need to call sales to get that information.

[mikeh]

"use MySQL instead" that's just nuts. Is this project slowly going back to a "proprietary" product?  As i look around and hang out in the ##alfresco channel on freenode, i don't see many community participants. I had planed on getting involved after the 3.2 release so i could coordinate point release to get fixes out, and help with a community build system to run the unit tests. However i have read that there are two separate source repositories.  If this is true i can understand why people don't help out. I would like some clarification on that. Hopefully that has changed for the better.

I don't think you mean "proprietary", but anyway we took the decision to drop close-source databases. I don't know why the PostgreSQL scripts were also dropped, it may have just been lack of opportunity to test and validate with that db.

There's an alfresco channel on freenode? I had no idea nor, I suspect, do many of the other Alfresco people. These forums, our Facebook group and Twitter are the places to find Alfresco employees these days

There have always been two SVNs - Community and Enterprise. There are some Enterprise-only components that can't be released under GPL, so we need to do that. There are also some Enterprise-only modules (such as JMX, Kofax OCR, etc. and the closed-source db scripts). Everything else is eventually merged back to HEAD.

Giving the Community commit rights to an SVN branch is something we're actively working on. However, there are some hoops to jump through before we can do this.

Thanks,
Mike

[mikeh]

Dear Mike,
       I bought Oracle 11G for using it with Alfresco2.1 CE. Now if I have to migrate to MySQL for using Alfresco3 Labs then tell me what to do with purchased Oracle license? Will you give me some light what could I do…
:-Sameer

From Alfresco's point of view, our (somewhat rhetorical) question to you would be: Why are you prepared to pay $40k for Oracle 11G but are trying to use the free Alfresco Community Edition with it?

Mike

[ed_mann]

Mike,

I miss spoke, maybe alfresco is going "to" a more proprietary model. Kinda like give away the handle sell the blades. I can understand dropping the close source database. If people can afford license for Oracle, or Sql Server then they can afford to pay for subscription to alfresco. We have both Oracle and Sql Server running where i work so i know a little about the license.

I really don't know how i stumbled on the irc channel, but i thought it was in the forums. I have tried to help people with questions but some things i just don't have knowledge of with alf. I welcome you and others to stop in and just hang out in the channel.

About svn thanks for more insight into why there are two. That makes sense, i need to spend more time in the project to know how things are committed.  When a ticket is fixed does it go internal, and only when you do a new release is it pushed to the community svn? It would make it more of a challenge to do point releases if we don't have the code that fixes things. Also is there some agreement that needs to be signed before a community contributor can submit code? Something that gives Alfresco a non exclusive, perpetual, non-transferable rights to use the code?

Mike thanks for your time in responding to me.

[mikeh]

When a ticket is fixed does it go internal, and only when you do a new release is it pushed to the community svn? It would make it more of a challenge to do point releases if we don't have the code that fixes things. Also is there some agreement that needs to be signed before a community contributor can submit code? Something that gives Alfresco a non exclusive, perpetual, non-transferable rights to use the code?

A community-supplied patch is always applied to HEAD first, then merged to Enterprise if appropriate. That's only fair. As to other fixes, it depends on what cycle of development we're in.

Basically, we concentrate on new features into HEAD and release that as Community (was Labs). We then do some extra QA on the other databases, plus other Enterprise-only modules and other app containers for about 4-6 weeks. Then we release the Enterprise version. Sometime after that (depending on many variables) all those GPL-able Enterprise fixes are merged back to HEAD and the cycle repeats. Often there's parallel development on HEAD at the same time (which is a cause of contention, as the Enterprise fixes merge in with these new pieces).

As I understand the process*, contributors don't have to sign anything unless they wish to do so, but all code must be GPL in order for us to accept it onto HEAD. The best way to contribute is to attach a patch to a JIRA ticket. (* Because HEAD is already GPL, I think the license means any code contributed thereto is therefore also GPL. However, I am not a lawyer!)

Thanks,
Mike

[ra74]

Hi Mike

When preview 3.2 was released I though that oracle was not supported because of technical problems but now I'm reading there is a new policy to not support
commercial databases in the community edition at all.
Please tell me if I know quite well oracle and java and propably can manage with minor problems will I be able to perform upgrade 2.1 -> 3.2 ?
I mean do all neccessary scrips are commited into svn ? In theory after some time things from enterprise are commited into public svn so anyway sooner or later such upgrade should be possible. Am I right ?

PS Regarding payments I can add that oracle in quite often a corporate standart and several applications are running on it. Money for oracle licences comes from diffrent excel cell
Using another database is not allowed. Fortunately we're using alresco only as a content repository and can without problems migrate
I wish all the best to the alfresco I like its clean design but well my department is not going to pay - $30k is too much, we have too many systems we have to pay
and even we were not able to get from sales more details what we get for it