@SuppressWarnings("unused")
    private String getKeyboardID(String keyboardLayout) throws SQLException{
	    
	    String keyboardID = null;
	    String query = String.format("SELECT kid FROM keyboard_layout where '%s' = boardlayout;",keyboardLayout);
	        
        ResultSet rs = this.dbConnection.execute(query);
        rs.next();
        if(rs.isLast()){
            keyboardID = rs.getString("kid");
        }else{
            rs.close();
            throw new SQLException("Non-unique keyboard layout. Contact a DBA to investigate this issue.");
        } 
        rs.close();
        
	    return keyboardID;
	}