String insertTableSQL = "INSERT INTO sensor(id, deviceId, tmStmp, name, val) values(nextval( 'hibernate_sequence'),"
		                            + sensor.getDeviceId()
			                        + ",  NOW()" 
			                        + ", " + "'" + sensor.getName() + "'"
			                        + ", " + sensor.getVal() +")";

			System.out.println("*** run statement: " + insertTableSQL);
			Statement statement = dbConnection.createStatement();
			// execute insert SQL statement
			
			statement.executeUpdate(insertTableSQL, Statement.RETURN_GENERATED_KEYS);
			
			// set id 
			try (ResultSet generatedKeys = statement.getGeneratedKeys()) {
	            if (generatedKeys.next()) {
	                sensor.setId(generatedKeys.getLong(1));
	            }
	            else {
	                throw new SQLException("Creating sensor failed, no ID obtained.");
	            }
	        }