Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Does actually work with PostgreSQL or Oracle?
[CDO] Does actually work with PostgreSQL or Oracle? [message #1057855] Thu, 09 May 2013 10:53 Go to next message
Marc Gil is currently offline Marc GilFriend
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
Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057960 is a reply to message #1057855] Fri, 10 May 2013 07:27 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 5590
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
Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057961 is a reply to message #1057855] Fri, 10 May 2013 07:31 Go to previous messageGo to next message
Per Sterner is currently offline Per SternerFriend
Messages: 77
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
Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057963 is a reply to message #1057961] Fri, 10 May 2013 07:34 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 5590
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
Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057964 is a reply to message #1057961] Fri, 10 May 2013 07:43 Go to previous messageGo to next message
Marc Gil is currently offline Marc GilFriend
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
Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1057965 is a reply to message #1057964] Fri, 10 May 2013 07:50 Go to previous messageGo to next message
Marc Gil is currently offline Marc GilFriend
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
Re: [CDO] Does actually work with PostgreSQL or Oracle? [message #1058102 is a reply to message #1057960] Sat, 11 May 2013 10:08 Go to previous message
Christophe Bouhier is currently offline Christophe BouhierFriend
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
>
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:
  


Current Time: Mon Dec 22 16:41:02 GMT 2014

Powered by FUDForum. Page generated in 0.02910 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software