Wiki Spaces
Documentation
Projects
Resources
Get Help from Others
Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack
<html><head><title></title></head><body>* Discuss plans for PIH to visit Indy on June 21-22 (if we haven't already)
- Discussed handling locations through taskpane within InfoPath
- Discuss Darius' concerns regarding getNextAvailableId()
- This is why sequences in oracle and postgres are better than autonumbers in mysql.
- This isn't thread-safe. I suppose it's unlikely that multiple concepts will be created simultaneously, but still...
- Why are we going to extra lengths to get unused concept_ids from from the middle of the number space?
- :
*: public Integer getNextAvailableId() { *: Session session = HibernateUtil.currentSession(); *: *: String sql = "select min(concept_id+1) as concept_id from concept where (concept_id+1) not in (select concept_id from concept)"; *: *: Query query = session.createSQLQuery(sql); *: *: BigInteger big = (BigInteger)query.uniqueResult(); *: *: return new Integer(big.intValue()); *: }
- Further discussion on issues with synchronizing disparate instances of OpenMRS — deferred for PIH's visit to Indy on June 21-22
Items for June 21-22
Moved to Technical Workshop 6-21-6-22-2006 Agenda
</body></html>
Overview
Content Tools
Feedback on this page? Questions?
Copyright © 2004-2016 OpenMRS Inc. By using this site, you agree to the OpenMRS Privacy Policy.
Text is available under the Creative Commons 4.0 International Attribution License (CC BY 4.0).
Software is available under the Mozilla Public License 2.0 with Healthcare Disclaimer (MPL 2.0 HD).
"OpenMRS" is a registered trademark and the OpenMRS graphic logo is a trademark of OpenMRS Inc.