Eclipse Community Forums: EMF » [CDO] Does actually work with PostgreSQL or Oracle?

Help

Home

Home » Modeling » EMF » [CDO] Does actually work with PostgreSQL or Oracle?

Show: Today's Messages :: Show Polls :: Message Navigator

[CDO] Does actually work with PostgreSQL or Oracle? [message #1057855]

Thu, 09 May 2013 10:53

Marc Gil

Messages: 81
Registered: July 2009

Member

Hi,

I'm having serious problems when running a CDO server using PostgreSQL or Oracle. Indeed, it only seems to work with MySQL without any problem, in 4.2M6 version.

I put two bugzillas related with Oracle:
- https://bugs.eclipse.org/bugs/show_bug.cgi?id=407254
- https://bugs.eclipse.org/bugs/show_bug.cgi?id=407358

And another one related with PostgreSQL:
- https://bugs.eclipse.org/bugs/show_bug.cgi?id=404582

With the 4.2M5 version of CDO, MySQL, PostgreSQL works perfectly (not Oracle). But since 4.2M6 version, PostgreSQL don't work.

Does anybody achieve to run a CDO server with PostgreSQL or Oracle with 4.2M6 version or later?

Cheers,
Marc

Report message to a moderator

Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057960 is a reply to message #1057855]

Fri, 10 May 2013 07:27

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Hi Marc,

CDO is supposed to work with these database systems and it used to do it properly. Then with M6 we came up with an
almost completely new DB framework to address some tricky concurrency issues. This new framework needs adjustments
regarding some of the DB adapters. Your respective feedback is very valuable because we don't have the resources to test
all adapters on Hudson constantly. I'm currently at a conference but will focus on this whole issue with pressure
starting next week. Your cooperation with testing will be highly appreciated ;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Am 09.05.2013 12:53, schrieb Marc Gil:
> Hi,
>
> I'm having serious problems when running a CDO server using PostgreSQL or Oracle. Indeed, it only seems to work with
> MySQL without any problem, in 4.2M6 version.
>
> I put two bugzillas related with Oracle:
> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=407254
> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=407358
>
> And another one related with PostgreSQL:
> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=404582
>
> With the 4.2M5 version of CDO, MySQL, PostgreSQL works perfectly (not Oracle). But since 4.2M6 version, PostgreSQL
> don't work.
>
> Does anybody achieve to run a CDO server with PostgreSQL or Oracle with 4.2M6 version or later?
>
> Cheers,
> Marc

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057961 is a reply to message #1057855]

Fri, 10 May 2013 07:31

Per Sterner

Messages: 91
Registered: October 2011

Member

Hello,

we use PostgreSQL with the current trunk of CDO.

After the release of M5 there were a lot changes to the structure/initialization of the DB-Storages.

In the bugtracker ticket I have mentioned a 'patch'. Now it works like expected.

Regards,

Per Sterner

Report message to a moderator

Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057963 is a reply to message #1057961]

Fri, 10 May 2013 07:34

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Am 10.05.2013 09:31, schrieb Per Sterner:
> Hello,
>
> we use PostgreSQL with the current trunk of CDO.
>
> After the release of M5 there were a lot changes to the structure/initialization of the DB-Storages.
>
> In the bugtracker ticket I have mentioned a 'patch'. Now it works like expected.
Thank you, Per! I'll work through all the respective contributions next week and make sure that RC1 will be more
satisfying ;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057964 is a reply to message #1057961]

Fri, 10 May 2013 07:43

Marc Gil

Messages: 81
Registered: July 2009

Member

Hi Per,

Sorry, I can't test your patch. You mean that the exception I included in the ticket is solved by adding this line "statement.execute("commit");"?? It's a very good news Smile

But I have checked the suposing code to be released on CDO M7 (build drops_S20130507-1005) and it has not been included in the DBUtil class, so I think that in the next release PostgreSQL will not work.

I'll try to test it today or this weekend.

Thanks Per!
Marc

Report message to a moderator

Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057965 is a reply to message #1057964]

Fri, 10 May 2013 07:50

Marc Gil

Messages: 81
Registered: July 2009

Member

Hi Eike,

Thanks for your response. We tried to convince our customer to use MySQL, but they only want to use Oracle or PostgreSQL, as they are public administration, you know they are resistant to change it's infrastructure Smile

In CDO M5, Oracle 11g neither works. When trying to create the structure, it fails. The stacktraces are included in the two bugzillas. One is easy to solve, the other one I think it's a little bit difficult.

I'll pay attention to your work next week in order to test your commits on this way. We can keep in touch if you want in order to be more efficient.

Thanks Eike,
Marc

Report message to a moderator

Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1058102 is a reply to message #1057960]

Sat, 11 May 2013 10:08

Christophe Bouhier

Messages: 937
Registered: July 2009

Senior Member

On 10-05-13 09:27, Eike Stepper wrote:
> Hi Marc,
>
> CDO is supposed to work with these database systems and it used to do it
> properly. Then with M6 we came up with an almost completely new DB
> framework to address some tricky concurrency issues.
Hi Eike,
This statement triggers me to think, some relation perhaps with
https://bugs.eclipse.org/bugs/show_bug.cgi?id=396743
?
Which bugs specifically in M6 address the issue you refer to?
thanks Christophe

This new framework
> needs adjustments regarding some of the DB adapters. Your respective
> feedback is very valuable because we don't have the resources to test
> all adapters on Hudson constantly. I'm currently at a conference but
> will focus on this whole issue with pressure starting next week. Your
> cooperation with testing will be highly appreciated ;-)
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
> Am 09.05.2013 12:53, schrieb Marc Gil:
>> Hi,
>>
>> I'm having serious problems when running a CDO server using PostgreSQL
>> or Oracle. Indeed, it only seems to work with MySQL without any
>> problem, in 4.2M6 version.
>>
>> I put two bugzillas related with Oracle:
>> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=407254
>> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=407358
>>
>> And another one related with PostgreSQL:
>> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=404582
>>
>> With the 4.2M5 version of CDO, MySQL, PostgreSQL works perfectly (not
>> Oracle). But since 4.2M6 version, PostgreSQL don't work.
>>
>> Does anybody achieve to run a CDO server with PostgreSQL or Oracle
>> with 4.2M6 version or later?
>>
>> Cheers,
>> Marc
>

Report message to a moderator

Previous Topic:	[EMF] Choose internally used EList (sets which use '==' or 'equals')
Next Topic:	[EMF Compare] Using EMF Compare visual diff with files that have .xml extension

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 22:14:24 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter