Eclipse Community Forums: OSEE » Can not run OSEE with Postgresql

Help

Home

Home » Eclipse Projects » OSEE » Can not run OSEE with Postgresql

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

Can not run OSEE with Postgresql [message #1044016]

Thu, 18 April 2013 07:50

riddhi shah
Messages: 3
Registered: April 2013

Junior Member

Hello,

I followed http://wiki.eclipse.org/OSEE/Users_Guide/Getting_Started instruction to setup OSEE Server with Postgres database. On startup of application using runPostgresqlLocal.bat (java -Xmx1024m -Dorg.osgi.service.http.port=8089 -Dosee.db.connection.id=postgresqlLocalhost -Dorg.eclipse.equinox.http.jetty.context.sessioninactiveinterval=3600 -jar plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar -console -consoleLog clean) it shows following error:

=================================================================
Vaadin is running in DEBUG MODE.
Add productionMode=true to web.xml to disable debug features.
To show debug window, add ?debug to your application URL.
=================================================================
Thu Apr 18 16:12:45 IST 2013 org.eclipse.osee.framework.database.internal.U
riDbConnectionInfo
INFO org.eclipse.osee.framework.database.internal.UriDbConnectionInfo getDbI
nformation (31)
Loading connection info from: [C:\OSEE\org.eclipse.osee.x.server.runtime\connect
ion.xml]

16:12:45.853 [Timer-2] INFO o.eclipse.osee.framework.core.server - Server looku
p table is not initialized
16:12:45.853 [Timer-2] INFO o.eclipse.osee.framework.core.server - Server looku
p table is not initialized
16:12:45.853 [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="osee" />
<Password key="#PASSWORD#" value="osee" />
<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>

--------------------------------------------------------------------------------------------------------------------------------------------------------

If I run application server using

java -Xmx1024m -Dorg.osgi.service.http.port=8089 -Dosee.db.connection.id=postgresqlLocalhost -Dorg.eclipse.equinox.http.jetty.context.sessioninactiveinterval=3600 -jar plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar -console -consoleLog clean

It gives following error,
org.eclipse.osee.framework.core.exception.OseeDataStoreException: DB connection
information was not found for: [postgresqlLocalhost]
Available connection ids are: [[]]

at org.eclipse.osee.framework.database.internal.DatabaseInfoRegistryImpl
.findDatabaseInfo(DatabaseInfoRegistryImpl.java:80) ~[na:na]
at org.eclipse.osee.framework.database.internal.DatabaseInfoRegistryImpl
.getSelectedDatabaseInfo(DatabaseInfoRegistryImpl.java:57) ~[na:na]

I need urgent assistance on how to setup OSEE with postgres database ?

--Riddhi

Report message to a moderator

Previous Topic:	OSEE installation - Unable to Connect to [http://localhost:8089/]
Next Topic:	Can not run OSEE on postgres

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 07 21:48:55 EDT 2013