Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » CDO Server not running(CDO server not running using PostgreSQL as database)
CDO Server not running [message #1040279] Sat, 13 April 2013 09:46 Go to next message
Lakhveer Singh is currently offline Lakhveer Singh
Messages: 26
Registered: March 2013
Junior Member
hello friends,

i m working on eclipse application in which i m using CDO and EMF framework.
now i m stucked in running CDO Server.

i m using PostgreSQL as my database and trying to run CDO server for that, but its not working can any body help me here.
i get the following error while running the cdo server
[ERROR] org.postgresql.util.PSQLException: Protocol error. Session setup failed.
org.eclipse.net4j.db.DBException: org.postgresql.util.PSQLException: Protocol error. Session setup failed.

the following is the code of mine cdo-server.xml
<?xml version="1.0" encoding="UTF-8"?>
<cdoServer>

<acceptor type="tcp" listenAddr="0.0.0.0" port="2036" />

<repository name="demo">

<store type="db">
<mappingStrategy type="horizontal" />
<dbAdapter name="postgresql" />
<dataSource class="org.postgresql.ds.PGSimpleDataSource"
url="jdbc:postgresql://localhost:5433/postgres" databaseName="postgres"
user="postgres" password="admin" />
</store>
</repository>


</cdoServer>


please tell me, if i have went wrong any where!

[Updated on: Sat, 13 April 2013 09:53]

Report message to a moderator

Re: CDO Server not running [message #1041509 is a reply to message #1040279] Mon, 15 April 2013 07:27 Go to previous messageGo to next message
Christophe Bouhier is currently offline Christophe Bouhier
Messages: 919
Registered: July 2009
Senior Member
On 13-04-13 11:46, Lakhveer Singh wrote:
> hello friends,
> i m working on eclipse application in which i m using CDO and EMF
> framework.
> now i m stucked in running CDO Server.
I don't think many people will be inclined to respond to your question,
without a more elaborate description of what "stuck" means... I would
recommend, a problem description, steps taken, stack-traces, version
numbers etc.. You know the regular technical stuff one needs to actually
help out.
>
> i m using PostgreSQL as my database and trying to run CDO server for
> that, but its not working can any body help me here.
>
> the following is the code of mine cdo-server.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <cdoServer>
>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036" />
>
> <repository name="demo">
>
> <store type="db">
> <mappingStrategy type="horizontal" />
> <dbAdapter name="postgresql" />
> <dataSource class="org.postgresql.ds.PGSimpleDataSource"
> url="jdbc:postgresql://localhost:5433/postgres"
> databaseName="postgres"
> user="postgres" password="admin" />
> </store>
> </repository>
>
>
> </cdoServer>
>
> please tell me, if i have went wrong any where!
Re: CDO Server not running [message #1041613 is a reply to message #1040279] Mon, 15 April 2013 10:17 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Am 13.04.2013 11:46, schrieb Lakhveer Singh:
> hello friends,
> i m working on eclipse application in which i m using CDO and EMF framework.
> now i m stucked in running CDO Server.
>
> i m using PostgreSQL as my database and trying to run CDO server for that, but its not working
I agree with Christophe, "is not working" is not a problem description that invites others to help you.


> can any body help me here.
>
> the following is the code of mine cdo-server.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <cdoServer>
>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036" />
>
> <repository name="demo">
>
> <store type="db">
> <mappingStrategy type="horizontal" />
> <dbAdapter name="postgresql" />
> <dataSource class="org.postgresql.ds.PGSimpleDataSource"
> url="jdbc:postgresql://localhost:5433/postgres" databaseName="postgres"
> user="postgres" password="admin" />
I'm not a PostgreSQL expert but you could try this:

<dbAdapter name="postgresql"/>
<dataSource class="org.postgresql.ds.PGSimpleDataSource"
serverName="localhost"
portNumber="5432"
databaseName="postgres"
user="postgres"
password="admin"/>

Cheers
/Eike

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



> </store>
> </repository>
>
>
> </cdoServer>
>
> please tell me, if i have went wrong any where!
Re: CDO Server not running [message #1058547 is a reply to message #1041613] Tue, 14 May 2013 12:40 Go to previous messageGo to next message
Lakhveer Singh is currently offline Lakhveer Singh
Messages: 26
Registered: March 2013
Junior Member
thanks for replying,
sorry for replying late, i was working on other module for a time,
i made changes in cdo-server.xml as you said and it was running succesfully,

but when i run the cdo server second time it gives and exception
!MESSAGE org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
!STACK 0
org.eclipse.net4j.db.DBException: 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:94)
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:679)
at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:661)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:556)
at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.ObjectTypeTable.getMaxID(ObjectTypeTable.java:174)
... 23 more

!ENTRY org.eclipse.equinox.app 4 0 2013-05-14 17:39:53.791
!MESSAGE org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
!STACK 0
org.eclipse.net4j.db.DBException: 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:94)
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:679)
at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:661)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:556)
at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.ObjectTypeTable.getMaxID(ObjectTypeTable.java:174)
... 23 more
[ERROR] org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.eclipse.net4j.db.DBException: 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:94)
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:679)
at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:661)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:556)
at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.ObjectTypeTable.getMaxID(ObjectTypeTable.java:174)
... 23 mo
re


can u help me here..!
Re: CDO Server not running [message #1059542 is a reply to message #1058547] Mon, 20 May 2013 11:36 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Am 14.05.2013 14:40, schrieb Lakhveer Singh:
> thanks for replying,
> sorry for replying late, i was working on other module for a time, i made changes in cdo-server.xml as you said and it
> was running succesfully,
>
> but when i run the cdo server second time it gives and exception !MESSAGE org.postgresql.util.PSQLException: ERROR:
> current transaction is aborted, commands ignored until end of transaction block
> !STACK 0
> org.eclipse.net4j.db.DBException: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands
> ignored until end of transaction block
We've applied some fixes to the PostgreSQLAdapter. Please try again with tomorrows RC-build.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: CDO Server not running [message #1063747 is a reply to message #1059542] Fri, 14 June 2013 05:48 Go to previous messageGo to next message
Lakhveer Singh is currently offline Lakhveer Singh
Messages: 26
Registered: March 2013
Junior Member
thanks for the suggestion, but can u provide me the link for the rc build.
i m not getting it in google.

Re: CDO Server not running [message #1063755 is a reply to message #1063747] Fri, 14 June 2013 06:40 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Am 14.06.2013 07:48, schrieb Lakhveer Singh:
> thanks for the suggestion, but can u provide me the link for the rc build.
> i m not getting it in google.
The latest RC is available via http://download.eclipse.org/modeling/emf/cdo/drops/S20130613-1441

Please also have a look at our general downloads page and its composite update sites: http://www.eclipse.org/cdo/downloads

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: CDO Server not running [message #1063794 is a reply to message #1063755] Fri, 14 June 2013 09:27 Go to previous messageGo to next message
Lakhveer Singh is currently offline Lakhveer Singh
Messages: 26
Registered: March 2013
Junior Member
thanks for forwarding me the link, but its still not working.

its still giving the same exception.
and one more problem is there that cdo server for postgre is not creating the database if database is not existing.
Re: CDO Server not running [message #1065771 is a reply to message #1063794] Thu, 27 June 2013 12:48 Go to previous message
Lakhveer Singh is currently offline Lakhveer Singh
Messages: 26
Registered: March 2013
Junior Member
thanks guys it worked.
thank you so much to everyone.
Previous Topic:[EMF] Resolving references in programmatic loading of meta-models
Next Topic:What is the purpose of GENMODEL's "generate model/edit/test code" ?
Goto Forum:
  


Current Time: Sat Sep 20 10:02:05 GMT 2014

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

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