=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataelement/DefaultDataElementCategoryService.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataelement/DefaultDataElementCategoryService.java 2011-11-03 01:02:13 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataelement/DefaultDataElementCategoryService.java 2011-11-04 09:28:14 +0000 @@ -37,7 +37,6 @@ import org.hisp.dhis.common.GenericIdentifiableObjectStore; import org.hisp.dhis.system.util.Filter; import org.hisp.dhis.system.util.FilterUtils; -import org.hisp.dhis.system.util.UUIdUtils; import org.springframework.transaction.annotation.Transactional; /** === modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/organisationunit/hibernate/HibernateOrganisationUnitStore.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/organisationunit/hibernate/HibernateOrganisationUnitStore.java 2011-11-03 14:27:18 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/organisationunit/hibernate/HibernateOrganisationUnitStore.java 2011-11-04 09:28:14 +0000 @@ -53,7 +53,6 @@ import org.hisp.dhis.organisationunit.OrganisationUnitService; import org.hisp.dhis.organisationunit.OrganisationUnitStore; import org.hisp.dhis.system.objectmapper.OrganisationUnitRelationshipRowMapper; -import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; /** @@ -219,7 +218,7 @@ public OrganisationUnitHierarchy getOrganisationUnitHierarchy() { - final String sql = "SELECT organisationunitid, parentid FROM organisationunit"; + final String sql = "select organisationunitid, parentid from organisationunit"; return new OrganisationUnitHierarchy( jdbcTemplate.query( sql, new OrganisationUnitRelationshipRowMapper() ) ); } @@ -230,8 +229,8 @@ StatementHolder holder = statementManager.getHolder(); - final String sql = "UPDATE organisationunit " + "SET parentid='" + parentId + "', SET lastUpdated='" - + now + "' " + "WHERE organisationunitid='" + organisationUnitId + "'"; + final String sql = "update organisationunit " + "set parentid=" + parentId + ", lastupdated='" + + now + "' " + "where organisationunitid=" + organisationUnitId; holder.executeUpdate( sql ); }