Index: forgon-core/src/main/java/com/forgon/directory/service/OrgUnitManagerImpl.java
===================================================================
diff -u -r33880 -r33882
--- forgon-core/src/main/java/com/forgon/directory/service/OrgUnitManagerImpl.java	(.../OrgUnitManagerImpl.java)	(revision 33880)
+++ forgon-core/src/main/java/com/forgon/directory/service/OrgUnitManagerImpl.java	(.../OrgUnitManagerImpl.java)	(revision 33882)
@@ -2342,15 +2342,16 @@
 	}
 	@Override
 	public JSONObject getOrgUnitJsonByBarcode(String barcode) {
-		ResultSet result = objectDao.executeSql("select name,orgUnitCoding,status from "
-				+ OrgUnit.class.getSimpleName()
-				+ " ou join "
-				+ BarcodeDevice.class.getSimpleName()
-				+" bd on bd.id=ou.barcodeDevice_id where bd.barcode='"+
-				barcode
-				+"'");
+		ResultSet result = null;
 		JSONObject orgUnit = null;
 		try {
+			result = objectDao.executeSql("select name,orgUnitCoding,status from "
+					+ OrgUnit.class.getSimpleName()
+					+ " ou join "
+					+ BarcodeDevice.class.getSimpleName()
+					+" bd on bd.id=ou.barcodeDevice_id where bd.barcode='"+
+					barcode
+					+"'");
 			while(result.next()){
 				orgUnit = new JSONObject();
 				orgUnit.put("name", result.getString("name"));