Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » OSEE » Can not run OSEE on postgres
Can not run OSEE on postgres [message #1043862] Thu, 18 April 2013 03:51 Go to next message
riddhi shah is currently offline riddhi shah
Messages: 3
Registered: April 2013
Junior Member
Hello,

I am trying to run OSEE server with PostgreSQL. I followed all the instruction provided in http://wiki.eclipse.org/OSEE/Users_Guide/Getting_Started.

While running application server with following command:

java -Dosee.log.default=INFO -Dorg.osgi.service.http.port=8089 -Dosgi.compatibility.bootdelegation=true -Xmx512m -Dequinox.ds.debug=true -Dosee.connection.info.uri="C:\OSEE\org.eclipse.osee.x.server.runtime\connection.xml" -Dosee.db.connection.id=OSEE -jar plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar -console

it gives following error:

DbConnection: [jdbc:postgresql://localhost:5432/OSEE] - [2]

Thu Apr 18 12:20:29 IST 2013 org.eclipse.osee.framework.database.internal.c
ore.OseeDatabaseServiceImpl
SEVERE org.eclipse.osee.framework.database.internal.core.OseeDatabaseServiceIm
pl runBatchUpdate (143)
This is the nested exception
org.postgresql.util.PSQLException: ERROR: relation "osee_server_lookup" does not
exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:343)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc
2Statement.java:2668)
at org.eclipse.osee.framework.database.internal.core.OseeDatabaseService
Impl.runBatchUpdate(OseeDatabaseServiceImpl.java:136)
at org.eclipse.osee.framework.database.internal.core.OseeDatabaseService
Impl.runBatchUpdate(OseeDatabaseServiceImpl.java:157)
at org.eclipse.osee.framework.database.internal.core.OseeDatabaseService
Proxy.runBatchUpdate(OseeDatabaseServiceProxy.java:125)
at org.eclipse.osee.framework.core.server.internal.ApplicationServerData
Store.registerWithDb(ApplicationServerDataStore.java:108)
at org.eclipse.osee.framework.core.server.internal.InternalOseeServerInf
o.writeToDataStore(InternalOseeServerInfo.java:122)
at org.eclipse.osee.framework.core.server.internal.InternalOseeServerInf
o.updateRegistration(InternalOseeServerInfo.java:129)
at org.eclipse.osee.framework.core.server.internal.ApplicationServerMana
ger.executeLookupRegistration(ApplicationServerManager.java:121)
at org.eclipse.osee.framework.core.server.internal.ApplicationServerMana
ger$1.run(ApplicationServerManager.java:81)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)

12:20:29.746 [Timer-2] INFO o.eclipse.osee.framework.core.server - Server looku
p table is not initialized

My connection.xml is as below:

<DbConnection>

<DatabaseInfo id="postgresqlInfo">
<DatabaseHome key="#DBHOME#"/>
<DatabaseName key="#DBNAME#" value="OSEE" />
<DatabaseType key="#TYPE#" value="postgresql" />
<Prefix key="#PREFIX#" value="jdbc:postgresql" />
<UserName key="#USERNAME#" value="postgres" />
<Password key="#PASSWORD#" value="admin" />
<Host key="#HOST#" value="@AvailableDbServices.hostAddress" />
<Port key="#PORT#" value="@AvailableDbServices.port" />
</DatabaseInfo>

<ConnectionDescription id="postgresql" >
<Driver>org.postgresql.Driver</Driver>
<Url>#PREFIX#://#HOST#:#PORT#/#DBHOME##DBNAME#</Url>
</ConnectionDescription>

<AvailableDbServices>
<Server id="OSEE" dbInfo="postgresqlInfo"
hostAddress="localhost" port="5432"
connectsWith="postgresql" isProduction="false" />
</AvailableDbServices>
</DbConnection>
Re: Can not run OSEE on postgres [message #1047375 is a reply to message #1043862] Tue, 23 April 2013 01:53 Go to previous messageGo to next message
riddhi shah is currently offline riddhi shah
Messages: 3
Registered: April 2013
Junior Member
Is this forum active , or is there any other place where I can post my queries ?
Re: Can not run OSEE on postgres [message #1110925 is a reply to message #1047375] Tue, 17 September 2013 10:13 Go to previous message
Jagannatha Ramaiah is currently offline Jagannatha Ramaiah
Messages: 1
Registered: September 2013
Junior Member
I am also getting same error. Any help pls.
Previous Topic:OSEE installation - Unable to Connect to [http://localhost:8089/]
Next Topic:Retirement of HRID (Human Readable Id)
Goto Forum:
  


Current Time: Wed Jul 23 10:11:16 EDT 2014

Powered by FUDForum. Page generated in 0.01940 seconds