Hello Folks, Quite ironically I have been trying to get OpenMRS running postgresql since yesterday(too lazy to install mysql :D ). I modified the pom to add the jdbc driver for postgres, and used the advanced setup to point to the postgres server. But because of the unsupported datatypes the liquibase fail;s to execute. And after having a look at the liquibase my impression is that we could get by just using the generic ANSI SQL types. But I guess the intention of using mysql specific types were to optimize for just mysql?
On Wed, Aug 10, 2011 at 10:46 PM, Saptarshi Purkayastha <[email protected]>wrote: > From what I've tried we will have to add: postgresql-9.0-801.jdbc4.jar to > the WEB-INF/lib for postgres > For other drivers similar connectors have to be added to the libraries. > > For the datatypes, liquibase 2.0.0 has automatic conversions > <http://forum.liquibase.org/topic/postgres-with-type-longtext-and-best-practice-for-supporting-multiple-database>for > common types between databases. > There are also extensions that can be written for our mods. > > --- > Regards, > Saptarshi PURKAYASTHA > > My Tech Blog: http://sunnytalkstech.blogspot.com > You Live by CHOICE, Not by CHANCE > > > On 10 August 2011 22:31, Friedman, Roger (CDC/CGH/DGHA) (CTR) < > [email protected]> wrote: > >> Seems like there shouldn't be a dependency at all, the code should just >> try to instantiate the appropriate driver. See >> openmrs-api/src/main/java/org/openmrs/util/DatabaseUtil.loadDatabaseDriver. >> This code is a TODO for >> openmrs-web/src/main/java/org/openmrs/web/filter/initialization/InitializationFilter.executeStatement. >> **** >> >> ** ** >> >> The MySQL driver is hard coded in >> openrs-webapp/src/main/webapp/META-INF/context.xml, and in >> openmrs/liquibase.build.xml. Seems like context could be set dynamically >> when the loadDatabaseDriver code is executed. Maybe liquibase could be >> edited at that time as well.**** >> >> ** ** >> >> *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Saptarshi >> Purkayastha >> *Sent:* Wednesday, August 10, 2011 12:03 PM >> >> *To:* [email protected] >> *Subject:* Re: [OPENMRS-DEV] Supporting 2 Million Patients**** >> >> ** ** >> >> Hi Roger,**** >> >> ** ** >> >> On 10 August 2011 19:18, Friedman, Roger (CDC/CGH/DGHA) (CTR) < >> [email protected]> wrote:**** >> >> So please don't take your frustrations with Tomcat out on >> blameless Postgressors.**** >> >> ** ** >> >> Definitely not frustrated about Tomcat or MySQL/Postgres. Wanted to see if >> we are fine to add those drivers, which are currently not in the >> dependencies. There are also issues which we will have to support and people >> will have different problems associated with those databases. If developers >> use MySQL and will not be able to solve issues with other databases, do we >> want to take that route?? I understand the reasons you mention and I'm very >> much supportive to the idea of using multiple databases and giving users >> that choice.**** >> >> ** ** >> >> With the issues I listed in the last email, I'm also of the opinion >> postgres has features that I would like to use and hence work on that >> ticket. But before I went out and fixed those, I wanted to understand if the >> patch will be accepted and we want to go ahead with the required changes. >> **** >> >> ** ** >> >> --- >> Regards, >> Saptarshi PURKAYASTHA >> >> My Tech Blog: http://sunnytalkstech.blogspot.com >> You Live by CHOICE, Not by CHANCE**** >> >> **** >> >> **** >> >> *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Saptarshi >> Purkayastha >> *Sent:* Wednesday, August 10, 2011 8:20 AM**** >> >> >> *To:* [email protected] >> *Subject:* Re: [OPENMRS-DEV] Supporting 2 Million Patients**** >> >> **** >> >> I was looking through this discussion and wanted to know how much of a >> priority is it for the community to run OpenMRS on Postgres or MSSQL?? Other >> than once-in-a-while mails on the dev list?? Is it our core motivation to >> have users choose what database they want OpenMRS to work on??**** >> >> It is some amount of work (upgrading liquibase is definitely required, >> adding database drivers and changing mysql-specific - tinyint to smallint, >> longtext etc.).**** >> >> **** >> >> Also among other things, I've yesterday had problems with simultaneous >> users (75+) using the system (16GB+ server) and getting out of memory and >> having to restart the system every 12-14hrs to release memory. The memory >> usage goes on increasing for Tomcat and restarting the server seems like the >> simple solution for the time being. I've heard Paul talk about a similar >> problem at AMPATH in one of the conf call recordings. Has there been a >> workaround at AMPATH or is restarting Tomcat the accepted solution?? I'm >> planning to host OpenMRS on Glassfish (with its better monitoring tools and >> VisualVM integration) and also write a performance monitoring module that >> uses javamelody <http://code.google.com/p/javamelody/>, but any >> suggestions in the meantime should be useful...**** >> >> >> --- >> Regards, >> Saptarshi PURKAYASTHA >> >> My Tech Blog: http://sunnytalkstech.blogspot.com >> You Live by CHOICE, Not by CHANCE**** >> >> On 27 July 2011 18:18, Ben Wolfe <[email protected]> wrote:**** >> >> I think this was the ticket I was thinking of: >> https://tickets.openmrs.org/browse/TRUNK-1925 >> >> That ticket should be edited to be more general about supporting all >> databases. The removal of the "not exists" from the wizard is just one part >> of that. >> >> The openmrs app does run on everything. And I'm pretty sure the update >> wizard / liquibase changesets run on everything. So a quick fix would be to >> install to mysql, then export the database tables and import those into >> postgresql. >> >> Ben**** >> >> On Wed, Jul 27, 2011 at 1:44 PM, Suranga Kasthurirathne < >> [email protected]> wrote:**** >> >> >> Hi,**** >> >> **** >> >> **** >> >> Looks like you could do with an Openmrs Id,**** >> >> **** >> >> go to https://wiki.openmrs.org/display/RES/OpenMRS+ID, and create your >> id, this will let you interact (and yes, create tickets) easily.**** >> >> once you create an id, you can use it to log in, and use JIRA.**** >> >> **** >> >> after signing in, go to https://tickets.openmrs.org/secure/Dashboard.jspa and >> click on 'create issue' (on the top right of screen).**** >> >> **** >> >> Hope this helps.**** >> >> **** >> >> **** >> >> **** >> >> **** >> >> On Wed, Jul 27, 2011 at 4:04 PM, Sokha RUM <[email protected]> wrote:**** >> >> I look for the existing ticket, and i found a ticket TRUNK-1922 which is >> about the supporting 6 types of database including also PostgreSQL. But >> that >> ticket is already in status "Fixed". >> >> One more thing i wanted to create a new ticket, but could not login. I do >> not know if i can use the account for joining community to access to >> ticket >> of OpenMRS.**** >> >> >> _________________________________________ >> >> To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to >> [email protected] with "SIGNOFF openmrs-devel-l" in the body >> (not the subject) of your e-mail. >> >> [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]**** >> >> >> >> **** >> >> -- >> Best Regards,**** >> >> **** >> >> Suranga**** >> >> **** >> ------------------------------ >> >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >> OpenMRS Developers' mailing list >> **** >> >> **** >> >> **** >> ------------------------------ >> >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >> OpenMRS Developers' mailing list >> **** >> >> ** ** >> ------------------------------ >> >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >> OpenMRS Developers' mailing list >> **** >> > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list > -- Thanks, Diptanu Choudhury +91 9686602153 http://www.linkedin.com/in/diptanu _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
