Home » Modeling » EMF » [CDO] Support to Postgresql 9.0
|
Re: [CDO] Support to Postgresql 9.0 [message #1009558 is a reply to message #1009531] |
Fri, 15 February 2013 10:05 |
Christophe Bouhier Messages: 937 Registered: July 2009 |
Senior Member |
|
|
Hi Marc,
I have some experience with running postgress.
I created a plugin containing the postgress JDBC driver.
Make sure the plugin version matches the net4j.progress version
requirement and export the packages. (I notice now the export has
version for some packages, I can't recall why this is, the driver is a
higher version).
Manifest-Version: 1.0
Bundle-ManifestVersion: 2
Bundle-Name: Postgresql
Bundle-SymbolicName: org.postgresql
Bundle-Version: 9.0.0.801
Bundle-ClassPath: postgresql-9.0-801.jdbc4.jar
Bundle-Vendor: postgresql.org
Export-Package: org.postgresql;version="8.9.9",
org.postgresql.copy,
org.postgresql.core,
org.postgresql.core.types,
org.postgresql.core.v2,
org.postgresql.core.v3,
org.postgresql.ds;version="8.9.9",
org.postgresql.ds.common,
org.postgresql.ds.jdbc23,
org.postgresql.ds.jdbc4,
org.postgresql.fastpath,
org.postgresql.geometric,
org.postgresql.gss,
org.postgresql.jdbc2,
org.postgresql.jdbc2.optional,
org.postgresql.jdbc3,
org.postgresql.jdbc3g,
org.postgresql.jdbc4,
org.postgresql.largeobject,
org.postgresql.ssl,
org.postgresql.translation,
org.postgresql.util,
org.postgresql.xa
Bundle-RequiredExecutionEnvironment: J2SE-1.5
Cheers Christophe
On 15-02-13 10:29, Marc Gil wrote:
> Hi,
>
> I'm trying to install CDO plugins and I realized that the plugin
> "org.eclipse.net4j.db.postgresql" is never loaded by Eclipse. I tried
> with the 4.0.SR2, 4.0.SR3, 4.1.SR1 CDO versions, and doesn't work.
>
> I realized that this plugin needs a packages named "org.postgresql" and
> "org.postgresql.ds" between 8.3.0 (inclusive) and 9.0.0 (exclusive)
> version.
>
> I needed to create a plugin with the 8.3 or 8.4 versions of postgres and
> compile it.
>
> Any help to use postgresql 9.0 plugin version?
>
> Thanks,
> Marc
|
|
| |
Re: [CDO] Support to Postgresql 9.0 [message #1009573 is a reply to message #1009558] |
Fri, 15 February 2013 10:32 |
|
Am 15.02.2013 11:05, schrieb Christophe Bouhier:
> Hi Marc,
>
> I have some experience with running postgress.
> I created a plugin containing the postgress JDBC driver.
>
> Make sure the plugin version matches the net4j.progress version requirement and export the packages. (I notice now the
> export has version for some packages, I can't recall why this is, the driver is a higher version).
>
> Manifest-Version: 1.0
> Bundle-ManifestVersion: 2
> Bundle-Name: Postgresql
> Bundle-SymbolicName: org.postgresql
> Bundle-Version: 9.0.0.801
> Bundle-ClassPath: postgresql-9.0-801.jdbc4.jar
> Bundle-Vendor: postgresql.org
> Export-Package: org.postgresql;version="8.9.9",
I think it's a NO GO to pretend lower package versions than they actually are!
The problem really must be addressed in /org.eclipse.net4j.db.postgresql/META-INF/MANIFEST.MF, which it is in CDO 4.2.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
> org.postgresql.copy,
> org.postgresql.core,
> org.postgresql.core.types,
> org.postgresql.core.v2,
> org.postgresql.core.v3,
> org.postgresql.ds;version="8.9.9",
> org.postgresql.ds.common,
> org.postgresql.ds.jdbc23,
> org.postgresql.ds.jdbc4,
> org.postgresql.fastpath,
> org.postgresql.geometric,
> org.postgresql.gss,
> org.postgresql.jdbc2,
> org.postgresql.jdbc2.optional,
> org.postgresql.jdbc3,
> org.postgresql.jdbc3g,
> org.postgresql.jdbc4,
> org.postgresql.largeobject,
> org.postgresql.ssl,
> org.postgresql.translation,
> org.postgresql.util,
> org.postgresql.xa
> Bundle-RequiredExecutionEnvironment: J2SE-1.5
>
> Cheers Christophe
>
>
> On 15-02-13 10:29, Marc Gil wrote:
>> Hi,
>>
>> I'm trying to install CDO plugins and I realized that the plugin
>> "org.eclipse.net4j.db.postgresql" is never loaded by Eclipse. I tried
>> with the 4.0.SR2, 4.0.SR3, 4.1.SR1 CDO versions, and doesn't work.
>>
>> I realized that this plugin needs a packages named "org.postgresql" and
>> "org.postgresql.ds" between 8.3.0 (inclusive) and 9.0.0 (exclusive)
>> version.
>>
>> I needed to create a plugin with the 8.3 or 8.4 versions of postgres and
>> compile it.
>>
>> Any help to use postgresql 9.0 plugin version?
>>
>> Thanks,
>> Marc
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Re: [CDO] Support to Postgresql 9.0 [message #1009597 is a reply to message #1009571] |
Fri, 15 February 2013 11:10 |
Marc Gil Messages: 81 Registered: July 2009 |
Member |
|
|
Eike,
I don't know if I can use CDO 4.2, cause I'm developing under Eclipse 3.7.2... Could you confirm me if I can use it, please?
Anyway, as I told before, I just made a couple of jar to be able to use postgresql 8.3 and 8.4. And then I try to create a CDO server and all worked fine. But not always are working... First time I executed the CDO server (with the DB created) it works and fills the DB with some info. Then I stop the server, and if I try to start it again, I get the following exception:
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.ObjectTypeTable.getMaxID(ObjectTypeTable.java:185)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.DelegatingObjectTypeMapper.getMaxID(DelegatingObjectTypeMapper.java:85)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalMappingStrategy.repairAfterCrash(AbstractHorizontalMappingStrategy.java:88)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.HorizontalMappingStrategy.repairAfterCrash(HorizontalMappingStrategy.java:204)
at org.eclipse.emf.cdo.server.internal.db.DBStore.repairAfterCrash(DBStore.java:654)
at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:638)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:548)
...
Any idea about what's happening??
Thanks,
Marc
|
|
| |
Re: [CDO] Support to Postgresql 9.0 [message #1009602 is a reply to message #1009597] |
Fri, 15 February 2013 11:16 |
Christophe Bouhier Messages: 937 Registered: July 2009 |
Senior Member |
|
|
On 15-02-13 12:10, Marc Gil wrote:
> Eike,
>
> I don't know if I can use CDO 4.2, cause I'm developing under Eclipse
> 3.7.2... Could you confirm me if I can use it, please?
>
> Anyway, as I told before, I just made a couple of jar to be able to use
> postgresql 8.3 and 8.4. And then I try to create a CDO server and all
> worked fine. But not always are working... First time I executed the CDO
> server (with the DB created) it works and fills the DB with some info.
> Then I stop the server, and if I try to start it again, I get the
> following exception:
>
> org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> at
Yep, seen this one.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=365602
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.ObjectTypeTable.getMaxID(ObjectTypeTable.java:185)
>
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.DelegatingObjectTypeMapper.getMaxID(DelegatingObjectTypeMapper.java:85)
>
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalMappingStrategy.repairAfterCrash(AbstractHorizontalMappingStrategy.java:88)
>
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.HorizontalMappingStrategy.repairAfterCrash(HorizontalMappingStrategy.java:204)
>
> at
> org.eclipse.emf.cdo.server.internal.db.DBStore.repairAfterCrash(DBStore.java:654)
>
> at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:638)
> at
> org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:548)
> ..
>
> Any idea about what's happening??
>
> Thanks,
> Marc
|
|
|
Re: [CDO] Support to Postgresql 9.0 [message #1009603 is a reply to message #1009597] |
Fri, 15 February 2013 11:16 |
|
Am 15.02.2013 12:10, schrieb Marc Gil:
> Eike,
>
> I don't know if I can use CDO 4.2, cause I'm developing under Eclipse 3.7.2... Could you confirm me if I can use it,
> please?
It *should* work. But we don't test it!
> Anyway, as I told before, I just made a couple of jar to be able to use postgresql 8.3 and 8.4. And then I try to
> create a CDO server and all worked fine. But not always are working... First time I executed the CDO server (with the
> DB created) it works and fills the DB with some info. Then I stop the server, and if I try to start it again, I get
> the following exception:
>
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
> at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.ObjectTypeTable.getMaxID(ObjectTypeTable.java:185)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.DelegatingObjectTypeMapper.getMaxID(DelegatingObjectTypeMapper.java:85)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalMappingStrategy.repairAfterCrash(AbstractHorizontalMappingStrategy.java:88)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.HorizontalMappingStrategy.repairAfterCrash(HorizontalMappingStrategy.java:204)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.repairAfterCrash(DBStore.java:654)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:638)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:548)
> ..
>
> Any idea about what's happening??
There were a couple similar problems with Postgres in particular, e.g.,
https://bugs.eclipse.org/bugs/show_bug.cgi?id=364809 , which have all been fixed in CDO 4.2.
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
|
|
| | |
Re: [CDO] Support to Postgresql 9.0 [message #1009635 is a reply to message #1009625] |
Fri, 15 February 2013 12:26 |
|
Am 15.02.2013 12:57, schrieb Marc Gil:
> Eike,
>
> Does the cdo-server.xml file contents change from 4.0 to 4.2 version?
Almost certainly.
> Cause I installed 4.2 under Eclipse 3.7.2 and all the plugins has been loaded correctly, but when launch the server an
> exception is thrown saying the following:
>
> java.lang.NoClassDefFoundError: org/eclipse/emf/cdo/server/IStore$CanHandleClientAssignedIDs
> at java.lang.ClassLoader.defineClass1(Native Method)
> at java.lang.ClassLoader.defineClassCond(Unknown Source)
> at java.lang.ClassLoader.defineClass(Unknown Source)
> at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.defineClass(DefaultClassLoader.java:188)
> at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.defineClassHoldingLock(ClasspathManager.java:626)
> at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.defineClass(ClasspathManager.java:608)
> at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findClassImpl(ClasspathManager.java:562)
> at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClassImpl(ClasspathManager.java:486)
> at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:459)
> at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
> at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:400)
> at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:476)
> at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:429)
> at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:417)
> at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at org.eclipse.emf.cdo.server.internal.db.DBStoreFactory.getMappingStrategy(DBStoreFactory.java:78)
> at org.eclipse.emf.cdo.server.internal.db.DBStoreFactory.createStore(DBStoreFactory.java:51)
>
> The class IStore.CanHandleClientAssignedIDs doesn't exists in the org.eclipse.emf.cdo.server plugin
What's the version of this bundle?
>
> My cdo-server.xml file contents:
> <?xml version="1.0" encoding="UTF-8"?>
> <cdoServer>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036" />
> <repository name="reqCDORepo">
> <property name="overrideUUID" value="" />
> <property name="supportingAudits" value="false" />
> <property name="supportingBranches" value="false" />
> <property name="supportingEcore" value="false" />
> <property name="serializeCommits" value="false" />
> <property name="ensureReferentialIntegrity" value="false" />
> <property name="allowInterruptRunningQueries" value="true" />
> <property name="idGenerationLocation" value="STORE" />
>
> <store type="db">
> <property name="connectionKeepAlivePeriod" value="60" />
> <property name="readerPoolCapacity" value="15" />
> <property name="writerPoolCapacity" value="15" />
> <mappingStrategy type="horizontal">
> <property name="toManyReferences" value="ONE_TABLE_PER_REFERENCE" />
> <property name="toOneReferences" value="LIKE_ATTRIBUTES" />
> </mappingStrategy>
> <dbAdapter name="postgresql" />
> <dataSource class="org.postgresql.ds.PGSimpleDataSource"
> url="jdbc:postgresql://127.0.0.1:5432/cdo_req" databaseName="cdo_req"
> user="***" password="***" />
> </store>
> </repository>
> </cdoServer>
>
> Don't know if I'm using the correct data source class, cause it exists PGConnectionPoolDS, PGPoolingDS and PGSimpleDS,
> and I don't know the main differences between them.
Me neither ;-(
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
|
|
| | |
Re: [CDO] Support to Postgresql 9.0 [message #1009654 is a reply to message #1009637] |
Fri, 15 February 2013 13:06 |
Marc Gil Messages: 81 Registered: July 2009 |
Member |
|
|
Eike,
It's impossible to install CDO 4.2 on Eclipse 3.7.2. I'm trying it for a couple of hours, and there are a dependency to EMF Compare minimum version 2.0.0, and it could not be installed under Eclipse 3.7.2 So my problem come back to the start, where using postgresql and closing unproperty the server, throws this exception... I think no solution exists for CDO 4.0 for that problem. Maybe, the best (or the only) solution is to change the database and use, for instance, MySQL, isn't it?
Thanks
Marc
[Updated on: Fri, 15 February 2013 13:07] Report message to a moderator
|
|
|
Re: [CDO] Support to Postgresql 9.0 [message #1009678 is a reply to message #1009654] |
Fri, 15 February 2013 14:04 |
|
Am 15.02.2013 14:06, schrieb Marc Gil:
> Eike,
>
> It's impossible to install CDO 4.2 on Eclipse 3.7.2. I'm trying it for a couple of hours, and there are a dependency
> to EMF Compare minimum version 2.0.0, and it could not be installed under Eclipse 3.7.2 :(
Oh, I forgot about that one! The bundles that depend on EMF Compare are optional. Please submit a bugzilla, so that I
can see how to factor these dependencies out of org.eclipse.emf.cdo.ui.team and move the Compare stuff into a separate,
optional feature.
> So my problem come back to the start, where using postgresql and closing unproperty the server, throws this
> exception... I think no solution exists for CDO 4.0
CDO 4.0 is out of maintenance.
> for that problem.
No, not even in 4.1.
> Maybe, the best solution is to change the database and use, for instance, MySQL, isn't it?
Hard to judge for me whether that's an option for you ;-)
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
|
|
| | |
Re: [CDO] Support to Postgresql 9.0 [message #1009739 is a reply to message #1009716] |
Fri, 15 February 2013 16:03 |
|
Le 15/02/2013 16:22, Eike Stepper a écrit :
> Am 15.02.2013 15:25, schrieb Marc Gil:
>> Thanks a lot for your quick answers Eike...
> You're welcome.
>
>>
>> Here is the bugzilla:
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=400926
>> I indicated the component cdo.core, I hope it's the right component :)
> I'll see...
>
>> Please, can you tell me aproximatelly when will be built the new
>> version of CDO 4.2 in order to try it with Eclipse 3.7.2 modeling
>> distribution?
Marc, it seems strange to me that EMF Compare 2.x can not be installed
on 3.7.2. Do you already have EMF Compare 1.x installed on your Eclipse?
If EMF Compare 1.x is installed as part of the bundle (which is the case
for the Eclipse Modeling Package I believe), then it can not be updated
to 2.x, and both versions (1.x and 2.x) can not be installed at the same
time.
If this is indeed the problem (conflict between Compare 1.x and 2.x),
you can still test CDO 4.2 on Eclipse 3.7.2 starting from a plain
Eclipse SDK.
Pierre-Charles David - Obeo
Need training or professional services for Sirius?
http://www.obeodesigner.com/sirius
|
|
|
Re: [CDO] Support to Postgresql 9.0 [message #1009839 is a reply to message #1009739] |
Fri, 15 February 2013 20:37 |
Marc Gil Messages: 81 Registered: July 2009 |
Member |
|
|
Hi David,
yes I'm using Eclipse 3.7.2 Modeling Package, and yes, EMF Compare 1.x is installes, and yes, when try to install 2.x it fails and Eclipse says that as 1.x is part of the bundle, 2.x cannot be installed...
The "problem" es that we developed our software from the modeling package, and we only added some features not included in this package. Trying to install the main environment from a plain Eclipse SDK, should be the last option for us at this moment. I hope that Eike could separate the plugins that depends on EMF Compare and build again CDO 4.2. If not, we will take other ways to try to use it
Thanks!
Marc
|
|
| |
Goto Forum:
Current Time: Tue Sep 24 00:36:55 GMT 2024
Powered by FUDForum. Page generated in 0.05538 seconds
|