private final static String dbFilePath = "c:/tmp/";
	private final static Properties hibernateProperties = new Properties();
	static {
		hibernateProperties.setProperty(Environment.DRIVER, "org.hsqldb.jdbcDriver");
		hibernateProperties.setProperty(Environment.USER, "sa");
		hibernateProperties.setProperty(Environment.URL, "jdbc:hsqldb:file:"+dbFilePath+"hsqldb");
		hibernateProperties.setProperty(Environment.PASS, "");
		hibernateProperties.setProperty(Environment.DIALECT, org.hibernate.dialect.HSQLDialect.class.getName());
		hibernateProperties.setProperty(PersistenceOptions.CASCADE_POLICY_ON_NON_CONTAINMENT, "CREATE,REFRESH,PERSIST,MERGE");
		hibernateProperties.setProperty(PersistenceOptions.INHERITANCE_MAPPING, "JOINED");
	}

	@Before
	public void setup() {
		cleanUp();
		String dataStoreName = "LocationStore";

		adapterFactory = new ComposedAdapterFactory();
		domain = new AdapterFactoryEditingDomain(
				adapterFactory, new BasicCommandStack());
		
		hbDataStore = HbHelper.INSTANCE.createRegisterDataStore(dataStoreName);
		hbDataStore.setDataStoreProperties(hibernateProperties);
		hbDataStore.setEPackages(new EPackage[] {LocationPackage.eINSTANCE});
		hbDataStore.initialize();
		getLogger().debug(hbDataStore.getMappingXML());		
		
		sc = new SessionController();
		sc.setHbDataStore(hbDataStore);		 
		SessionController.registerSessionController("testsc", sc);

		String uriStr = "hibernate://?" + HibernateResource.SESSION_CONTROLLER_PARAM + "=" + "testsc";
		resource = domain.getResourceSet().createResource(URI.createURI(uriStr));
		
		locationStore = getLocationStore();
		
		createDefault();
	}
	
	@After
	public void tearDown() {
		resource.unload();
		resource = null;
		hbDataStore.close();
		
		SessionController.deRegisterSessionController("testsc");
		sc.getSessionWrapper().close();
		sc = null;
		
		HbHelper.INSTANCE.closeAll();
		HbHelper.INSTANCE.deRegisterDataStore(hbDataStore);
		hbDataStore = null;
		
		try {
			Thread.sleep(5000);
		} catch (InterruptedException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void cleanUp() {
		try {
			FileUtils.deleteDirectory(new File(dbFilePath));
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public void shutDown() {
		if(resource != null) {
			resource.unload();
			resource = null;
		}

		if(sessionController != null) {
			SessionController.deRegisterSessionController(SESSIONCONTROLLER_NAME);
			sessionController.getSessionWrapper().close();
			sessionController = null;
		}

		if(hbDataStore != null) {
			hbDataStore.close();
			HbHelper.INSTANCE.closeAll();
			HbHelper.INSTANCE.deRegisterDataStore(hbDataStore);
			hbDataStore = null;
		}
	}

org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): 
...