Eclipse Community Forums: OSEE » Can not run OSEE on postgres

Help

Home

Home » Eclipse Projects » OSEE » Can not run OSEE on postgres

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

Can not run OSEE on postgres [message #1043862]

Thu, 18 April 2013 07:51

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>

Report message to a moderator