| [osee-dev] Can not run OSEE with Postgresql |
|
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 ? Regards, Riddhi Shah Sr. Technical Leader|Automotive & Engineering SBU KPIT Cummins Infosystems Ltd.|
www.kpitcummins.com Riddhi.Shah@xxxxxxxxxxxxxxx | Office: 020-6652-5000 Ext. 3446 | Mobile: +91-9765554157 This message contains information that may be privileged or confidential and is the property of the KPIT Cummins Infosystems Ltd. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. KPIT Cummins Infosystems Ltd. does not accept any liability for virus infected mails. |