private Connection getDBConnection() throws SQLException, UserStoreException { Connection dbConnection = IdentityDatabaseUtil.getUserDBConnection(); if (dbConnection == null) { throw new UserStoreException("Could not create a database connection to User database"); } dbConnection.setAutoCommit(false); dbConnection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); return dbConnection; } }
/** * Delete role permission mapping for a given permission id * * @param id Permission id * @throws SQLException */ private void deleteRolePermissionMapping(int id) throws SQLException { PreparedStatement deleteRolePermissionPrepStmt = null; Connection connection = null; try { connection = IdentityDatabaseUtil.getUserDBConnection(); deleteRolePermissionPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.REMOVE_UM_ROLE_PERMISSION); deleteRolePermissionPrepStmt.setInt(1, id); deleteRolePermissionPrepStmt.executeUpdate(); } finally { IdentityApplicationManagementUtil.closeStatement(deleteRolePermissionPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } }
/** * Update the permission path for a given id * * @param id Id * @param newPermission New permission path value * @throws SQLException */ private void updatePermissionPath(String id, String newPermission) throws SQLException { PreparedStatement updatePermissionPrepStmt = null; Connection connection = null; try { connection = IdentityDatabaseUtil.getUserDBConnection(); updatePermissionPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.UPDATE_SP_PERMISSIONS); updatePermissionPrepStmt.setString(1, newPermission); updatePermissionPrepStmt.setString(2, id); updatePermissionPrepStmt.executeUpdate(); } finally { IdentityDatabaseUtil.closeStatement(updatePermissionPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } }
/** * Delete permission entry for a given id * * @param entry_id Entry id * @throws SQLException */ private void deletePermission(int entry_id) throws SQLException { PreparedStatement deletePermissionPrepStmt = null; Connection connection = null; try { connection = IdentityDatabaseUtil.getUserDBConnection(); deletePermissionPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.REMOVE_UM_PERMISSIONS); deletePermissionPrepStmt.setInt(1, entry_id); deletePermissionPrepStmt.executeUpdate(); } finally { IdentityApplicationManagementUtil.closeStatement(deletePermissionPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } }
/** * Delete role permission mapping for a given permission id * * @param id Permission id * @throws SQLException */ private void deleteRolePermissionMapping(int id) throws SQLException { PreparedStatement deleteRolePermissionPrepStmt = null; Connection connection = null; try { connection = IdentityDatabaseUtil.getUserDBConnection(); deleteRolePermissionPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.REMOVE_UM_ROLE_PERMISSION); deleteRolePermissionPrepStmt.setInt(1, id); deleteRolePermissionPrepStmt.executeUpdate(); } finally { IdentityApplicationManagementUtil.closeStatement(deleteRolePermissionPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } }
/** * Delete permission entry for a given id * * @param entry_id Entry id * @throws SQLException */ private void deletePermission(int entry_id) throws SQLException { PreparedStatement deletePermissionPrepStmt = null; Connection connection = null; try { connection = IdentityDatabaseUtil.getUserDBConnection(); deletePermissionPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.REMOVE_UM_PERMISSIONS); deletePermissionPrepStmt.setInt(1, entry_id); deletePermissionPrepStmt.executeUpdate(); } finally { IdentityApplicationManagementUtil.closeStatement(deletePermissionPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } }
/** * Update the permission path for a given id * * @param id Id * @param newPermission New permission path value * @throws SQLException */ private void updatePermissionPath(String id, String newPermission) throws SQLException { PreparedStatement updatePermissionPrepStmt = null; Connection connection = null; try { connection = IdentityDatabaseUtil.getUserDBConnection(); updatePermissionPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.UPDATE_SP_PERMISSIONS); updatePermissionPrepStmt.setString(1, newPermission); updatePermissionPrepStmt.setString(2, id); updatePermissionPrepStmt.executeUpdate(); } finally { IdentityDatabaseUtil.closeStatement(updatePermissionPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } }
/** * Get permission id for a given permission path * * @param permission Permission path * @return Permission id * @throws SQLException */ private int getPermissionId(String permission) throws SQLException { PreparedStatement loadPermissionsPrepStmt = null; ResultSet resultSet = null; Connection connection = null; int id = -1; try { connection = IdentityDatabaseUtil.getUserDBConnection(); loadPermissionsPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.LOAD_UM_PERMISSIONS_W); loadPermissionsPrepStmt.setString(1, permission.toLowerCase()); resultSet = loadPermissionsPrepStmt.executeQuery(); if (resultSet.next()) { id = resultSet.getInt(1); } } finally { IdentityDatabaseUtil.closeResultSet(resultSet); IdentityDatabaseUtil.closeStatement(loadPermissionsPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } return id; }
/** * Get permission id for a given permission path * * @param permission Permission path * @return Permission id * @throws SQLException */ private int getPermissionId(String permission) throws SQLException { PreparedStatement loadPermissionsPrepStmt = null; ResultSet resultSet = null; Connection connection = null; int id = -1; try { connection = IdentityDatabaseUtil.getUserDBConnection(); loadPermissionsPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.LOAD_UM_PERMISSIONS_W); loadPermissionsPrepStmt.setString(1, permission.toLowerCase()); resultSet = loadPermissionsPrepStmt.executeQuery(); if (resultSet.next()) { id = resultSet.getInt(1); } } finally { IdentityDatabaseUtil.closeResultSet(resultSet); IdentityDatabaseUtil.closeStatement(loadPermissionsPrepStmt); IdentityDatabaseUtil.closeConnection(connection); } return id; }
try { connection = IdentityDatabaseUtil.getUserDBConnection(); readPermissionsPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.LOAD_UM_PERMISSIONS); readPermissionsPrepStmt.setString(1, "%" + ApplicationMgtUtil.getApplicationPermissionPath() + "%");
try { connection = IdentityDatabaseUtil.getUserDBConnection(); readPermissionsPrepStmt = connection.prepareStatement(ApplicationMgtDBQueries.LOAD_UM_PERMISSIONS); readPermissionsPrepStmt.setString(1, "%" + ApplicationMgtUtil.getApplicationPermissionPath() + "%");
private Connection getDBConnection(RealmConfiguration realmConfiguration) throws SQLException, UserStoreException { Connection dbConnection = null; DataSource dataSource = DatabaseUtil.createUserStoreDataSource(realmConfiguration); if (dataSource != null) { dbConnection = DatabaseUtil.getDBConnection(dataSource); } //if primary user store, DB connection can be same as realm data source. if (dbConnection == null && realmConfiguration.isPrimary()) { dbConnection = IdentityDatabaseUtil.getUserDBConnection(); } else if (dbConnection == null) { throw new UserStoreException("Could not create a database connection to " + realmConfiguration.getUserStoreProperty(UserCoreConstants.RealmConfig.PROPERTY_DOMAIN_NAME)); } else { // db connection is present } dbConnection.setAutoCommit(false); dbConnection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); return dbConnection; }
private Connection getDBConnection(RealmConfiguration realmConfiguration) throws SQLException, UserStoreException { Connection dbConnection = null; DataSource dataSource = DatabaseUtil.createUserStoreDataSource(realmConfiguration); if (dataSource != null) { dbConnection = DatabaseUtil.getDBConnection(dataSource); } //if primary user store, DB connection can be same as realm data source. if (dbConnection == null && realmConfiguration.isPrimary()) { dbConnection = IdentityDatabaseUtil.getUserDBConnection(); } else if (dbConnection == null) { throw new UserStoreException("Could not create a database connection to " + realmConfiguration .getUserStoreProperty(UserCoreConstants.RealmConfig.PROPERTY_DOMAIN_NAME)); } else { // db connection is present } dbConnection.setAutoCommit(false); dbConnection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); return dbConnection; } }