Running SQL queries from liferay's groovy console

running-sql-queries.md

Running SQL queries:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.liferay.portal.kernel.dao.jdbc.DataAccess;

Connection con = null;
Statement st = null;
try {
	con = DataAccess.getUpgradeOptimizedConnection();
	st = con.createStatement();
	ResultSet rs = st.executeQuery("select count(1) from Address where uuid_ is null or uuid_ = ''");
	rs.next();
	println(rs.getInt(1));
}
finally {
	DataAccess.cleanUp(con, st);
}