public int addClaim(Connection connection, String claimDialectURI, String claimURI, int tenantId) throws ClaimMetadataException { PreparedStatement prepStmt = null; ResultSet rs = null; int claimId = 0; String query = SQLConstants.ADD_CLAIM; try { String dbProductName = connection.getMetaData().getDatabaseProductName(); prepStmt = connection.prepareStatement(query, new String[]{DBUtils.getConvertedAutoGeneratedColumnName (dbProductName, SQLConstants.ID_COLUMN)}); prepStmt.setString(1, claimDialectURI); prepStmt.setInt(2, tenantId); prepStmt.setString(3, claimURI); prepStmt.setInt(4, tenantId); prepStmt.executeUpdate(); rs = prepStmt.getGeneratedKeys(); if (rs.next()) { claimId = rs.getInt(1); } } catch (SQLException e) { throw new ClaimMetadataException("Error while adding claim " + claimURI + " to dialect " + claimDialectURI, e); } finally { IdentityDatabaseUtil.closeResultSet(rs); IdentityDatabaseUtil.closeStatement(prepStmt); } return claimId; }
String dbProductName = conn.getMetaData().getDatabaseProductName(); prepStmt = conn.prepareStatement(sqlStmt, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")}); prepStmt.setInt(1, tenantId); prepStmt.setString(2, idpName);
String dbProductName = conn.getMetaData().getDatabaseProductName(); prepStmt = conn.prepareStatement(sqlStmt, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")}); prepStmt.setInt(1, tenantId); prepStmt.setString(2, idpName);
public int addClaim(Connection connection, String claimDialectURI, String claimURI, int tenantId) throws ClaimMetadataException { PreparedStatement prepStmt = null; ResultSet rs = null; int claimId = 0; String query = SQLConstants.ADD_CLAIM; try { String dbProductName = connection.getMetaData().getDatabaseProductName(); prepStmt = connection.prepareStatement(query, new String[]{DBUtils.getConvertedAutoGeneratedColumnName (dbProductName, SQLConstants.ID_COLUMN)}); prepStmt.setString(1, claimDialectURI); prepStmt.setInt(2, tenantId); prepStmt.setString(3, claimURI); prepStmt.setInt(4, tenantId); prepStmt.execute(); rs = prepStmt.getGeneratedKeys(); if (rs.next()) { claimId = rs.getInt(1); } } catch (SQLException e) { throw new ClaimMetadataException("Error while adding claim " + claimURI + " to dialect " + claimDialectURI, e); } finally { IdentityDatabaseUtil.closeResultSet(rs); IdentityDatabaseUtil.closeStatement(prepStmt); } return claimId; }
public int addClaim(Connection connection, String claimDialectURI, String claimURI, int tenantId) throws ClaimMetadataException { PreparedStatement prepStmt = null; ResultSet rs = null; int claimId = 0; String query = SQLConstants.ADD_CLAIM; try { String dbProductName = connection.getMetaData().getDatabaseProductName(); prepStmt = connection.prepareStatement(query, new String[]{DBUtils.getConvertedAutoGeneratedColumnName (dbProductName, SQLConstants.ID_COLUMN)}); prepStmt.setString(1, claimDialectURI); prepStmt.setInt(2, tenantId); prepStmt.setString(3, claimURI); prepStmt.setInt(4, tenantId); prepStmt.executeUpdate(); rs = prepStmt.getGeneratedKeys(); if (rs.next()) { claimId = rs.getInt(1); } } catch (SQLException e) { throw new ClaimMetadataException("Error while adding claim " + claimURI + " to dialect " + claimDialectURI, e); } finally { IdentityDatabaseUtil.closeResultSet(rs); IdentityDatabaseUtil.closeStatement(prepStmt); } return claimId; }
String dbProductName = conn.getMetaData().getDatabaseProductName(); try (PreparedStatement ps = conn.prepareStatement(SQLQueries.ADD_SCOPE, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, Oauth2ScopeConstants.SCOPE_ID)})) { ps.setString(1, scope.getName()); ps.setString(2, scope.getDisplayName());
String dbProductName = conn.getMetaData().getDatabaseProductName(); try (PreparedStatement ps = conn.prepareStatement(SQLQueries.ADD_SCOPE, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, Oauth2ScopeConstants.SCOPE_ID)})) { ps.setString(1, scope.getName()); ps.setString(2, scope.getDisplayName());
String dbProductName = connection.getMetaData().getDatabaseProductName(); prepStmt = connection.prepareStatement(sqlStmt, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, ID)}); prepStmt.setString(1, consumerKey); prepStmt.setString(2, sessionDataKey);
String dbProductName = connection.getMetaData().getDatabaseProductName(); prepStmt = connection.prepareStatement(sqlStmt, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, ID)}); for (List<RequestedClaim> list : claims) { if (CollectionUtils.isNotEmpty(list)) {
statementToAddCertificate = connection.prepareStatement( ApplicationMgtDBQueries.ADD_CERTIFICATE, new String[]{DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")});
storeAppPrepStmt = connection.prepareStatement( ApplicationMgtDBQueries.STORE_BASIC_APPINFO, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")});
String dbProductName = dbConnection.getMetaData().getDatabaseProductName(); prepBaseStmt = dbConnection.prepareStatement(sqlBaseStmt, new String[]{DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")});
storeAppPrepStmt = connection.prepareStatement( ApplicationMgtDBQueries.STORE_BASIC_APPINFO, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")});
if (OAuth2ServiceComponentHolder.isPkceEnabled()) { try (PreparedStatement prepStmt = connection.prepareStatement(SQLQueries.OAuthAppDAOSQLQueries .ADD_OAUTH_APP_WITH_PKCE, new String[]{DBUtils.getConvertedAutoGeneratedColumnName (dbProductName, "ID")})) { prepStmt.setString(1, processedClientId); .ADD_OAUTH_APP, new String[]{DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")})) { prepStmt.setString(1, processedClientId);
storeStepPrepStmtz = connection.prepareStatement( ApplicationMgtDBQueries.STORE_STEP_INFO, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")});
storeStepPrepStmtz = connection.prepareStatement( ApplicationMgtDBQueries.STORE_STEP_INFO, new String[]{ DBUtils.getConvertedAutoGeneratedColumnName(dbProductName, "ID")});