Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » OSEE » Can not run OSEE with Postgresql
Can not run OSEE with Postgresql [message #1044016] Thu, 18 April 2013 11:50 Go to next message
riddhi shah is currently offline riddhi shahFriend
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
Re: Can not run OSEE with Postgresql [message #1383926 is a reply to message #1044016] Tue, 27 May 2014 08:47 Go to previous message
Jan lafette is currently offline Jan lafetteFriend
Messages: 2
Registered: May 2014
Junior Member
Hello,

I´m having the same problem since few days, would you please kindly indicate to me how did you get through this error,

Loading connection info from: [C:\OSEE\org.eclipse.osee.x.server.runtime\connect
ion.xml]

thank you in advance.
Previous Topic:OSEE Tips and Tricks
Next Topic:Connect OSEE to Postgresql DB
Goto Forum:
  


Current Time: Sun Nov 23 03:55:00 GMT 2014

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

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