Examples with SqlUpdate com.liferay.portal.kernel.dao.jdbc.SqlUpdate used on opensource projects

Example 21 with SqlUpdate

use of com.liferay.portal.kernel.dao.jdbc.SqlUpdate in project liferay-ide by liferay.

the class RosterLocalServiceBaseImpl method runSQL.

/**
 * Performs a SQL query.
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = rosterPersistence.getDataSource();
        DB db = DBManagerUtil.getDB();
        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);
        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);
        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

Example 22 with SqlUpdate

use of com.liferay.portal.kernel.dao.jdbc.SqlUpdate in project liferay-ide by liferay.

the class RosterServiceBaseImpl method runSQL.

/**
 * Performs a SQL query.
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) {
    try {
        DataSource dataSource = rosterPersistence.getDataSource();
        DB db = DBManagerUtil.getDB();
        sql = db.buildSQL(sql);
        sql = PortalUtil.transformSQL(sql);
        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql);
        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

Example 23 with SqlUpdate

use of com.liferay.portal.kernel.dao.jdbc.SqlUpdate in project liferay-ide by liferay.

the class GadgetLocalServiceBaseImpl method runSQL.

/**
 * Performs an SQL query.
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) throws SystemException {
    try {
        DataSource dataSource = gadgetPersistence.getDataSource();
        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

Example 24 with SqlUpdate

use of com.liferay.portal.kernel.dao.jdbc.SqlUpdate in project liferay-ide by liferay.

the class GadgetServiceBaseImpl method runSQL.

/**
 * Performs an SQL query.
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) throws SystemException {
    try {
        DataSource dataSource = gadgetPersistence.getDataSource();
        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}

Example 25 with SqlUpdate

use of com.liferay.portal.kernel.dao.jdbc.SqlUpdate in project liferay-ide by liferay.

the class OAuthConsumerLocalServiceBaseImpl method runSQL.

/**
 * Performs an SQL query.
 *
 * @param sql the sql query
 */
protected void runSQL(String sql) throws SystemException {
    try {
        DataSource dataSource = oAuthConsumerPersistence.getDataSource();
        SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
        sqlUpdate.update();
    } catch (Exception e) {
        throw new SystemException(e);
    }
}