search

mohan-nishit / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 0 forks source link

jdbc postgresql Driver Definition #227

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Install Aggregate 1.0 beta per instructions
2. Start Tomcat

What is the expected output? What do you see instead?
Aggregate deploy

What version of the product are you using? On what operating system?
Aggregate 1.0 beta

Please provide any additional information below.
Aggregate Windows Installer sets wrong jdbc definition for postgres
jdbc:postgres:// instead of jdbc:postgresql://
resulting in this error: 
java.sql.SQLException: No suitable driver found for jdbc:postgres://

Original issue reported on code.google.com by yecarri...@gmail.com on 7 Jun 2011 at 9:41

GoogleCodeExporter commented 9 years ago 
I don't think we are supporting postgres yet. Try using mysql instead. This bug 
will remain open until postgres works. Please update this issue with any more 
information you find.

Original comment by wbrune...@gmail.com on 7 Jun 2011 at 9:47

GoogleCodeExporter commented 9 years ago 
In fact Postgresql works. I have an instace working with 1.0 alpha. The problem 
with beta is this postgres instead of postgresql thing. With alpha I knew how 
to change it,  but beta is couldn't find where correct it. 
Mitchell,  why did you suppose that postgresql isn't working?

Original comment by yecarri...@gmail.com on 8 Jun 2011 at 5:20

GoogleCodeExporter commented 9 years ago 
SOLVED
1. Uncompress ODKAggregate.war
2. Uncompress ODKAggregate\WEB-INF\lib\ODKAggregate-settings.jar
3. Edit  ODKAggregate\WEB-INF\lib\ODKAggregate-settings\jdbc.properties
   jdbc.url=jdbc:postgres://
   with
   jdbc.url=jdbc:postgresql://
4. Replace jdbc.properties in ODKAggregate-settings.jar
5. Replace ODKAggregate-settings.jar in ODKAggregate.war

Original comment by yecarri...@gmail.com on 8 Jun 2011 at 3:04

GoogleCodeExporter commented 9 years ago 
To clarify we did have postgres working with the alphas. However, to speed the 
release of the Beta we did not verify all the changes were consistent with 
postgres we only tested on appengine and mysql, leaving postgres for the final 
release. Sorry if I was unclear.

Original comment by wbrune...@gmail.com on 8 Jun 2011 at 8:26

GoogleCodeExporter commented 9 years ago 
According to Issue 230 even MySQL isn't working

Original comment by yecarri...@gmail.com on 9 Jun 2011 at 11:09

GoogleCodeExporter commented 9 years ago 
This is fixed in Aggregate 1.0 beta rev. 2

Original comment by mitchellsundt@gmail.com on 1 Jul 2011 at 8:44