public static int serDiccGroupByToWriter(
ResultSet rs,
Writer writer,
int maxRows,
String idPor,
String[] idAcumulados,
String campoAcumuladoNombre) {
int rowsCount = 0;
try {
ArrayList<String> acumulado = null;
String idActual = null;
StringBuilder reg = null;
reg = new StringBuilder();
String value = "";
if (rs != null) {
ResultSetMetaData rsm = rs.getMetaData();
int countCol = rsm.getColumnCount();
String name = "";
for (int i = 1; i <= countCol; i++) {
name = rsm.getColumnName(i);
reg.append(name.toLowerCase()).append("\t");
}
reg.append(campoAcumuladoNombre);
writer.write(reg.toString() + EOL);
while (rs.next()) {
if (idActual == null) {
reg = new StringBuilder();
acumulado = new ArrayList<String>();
idActual = rs.getString(idPor);
for (int i = 1; i <= countCol; i++) {
reg.append(rs.getString(i)).append("\t");
}
for (String id : idAcumulados) {
value = rs.getString(id);
if (!rs.wasNull()) {
acumulado.add(rs.getString(id));
}
}
} else {
if (idActual.equals(rs.getString(idPor))) {
for (String id : idAcumulados) {
value = rs.getString(id);
if (!rs.wasNull()) {
acumulado.add(rs.getString(id));
}
}
} else {
if (acumulado.size() > 0) {
for (String str : acumulado) {
reg.append(str).append(",");
}
reg.deleteCharAt(reg.length() - 1);
}
reg.append(EOL);
writer.write(reg.toString());
rowsCount++;
if (maxRows == rowsCount) {
break;
}
idActual = rs.getString(idPor);
reg = new StringBuilder();
acumulado = new ArrayList<String>();
for (int i = 1; i <= countCol; i++) {
reg.append(rs.getString(i)).append("\t");
}
for (String id : idAcumulados) {
value = rs.getString(id);
if (!rs.wasNull()) {
acumulado.add(rs.getString(id));
}
}
}
}
}
if (acumulado.size() > 0) {
for (String str : acumulado) {
reg.append(str).append(",");
}
reg.deleteCharAt(reg.length() - 1);
}
reg.append(EOL);
writer.write(reg.toString());
rowsCount++;
}
} catch (SQLException e) {
logm("ERR", 1, "Error al escribir registros", e);
} catch (IOException e) {
logm("ERR", 1, "Error al escribir registros", e);
}
return rowsCount;
}
protected CFSecurityTSecGroupBuff unpackTSecGroupResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackTSecGroupResultSetToBuff";
int idxcol = 1;
CFSecurityTSecGroupBuff buff = schema.getFactoryTSecGroup().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredTSecGroupId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFAccFeeDetailBuff unpackFeeDetailResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackFeeDetailResultSetToBuff";
int idxcol = 1;
CFAccFeeDetailBuff buff = schema.getFactoryFeeDetail().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFAccSybaseSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFAccSybaseSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredFeeId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredFeeDetailId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredAmountCharged(resultSet.getBigDecimal(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFInternetURLProtocolBuff unpackURLProtocolResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackURLProtocolResultSetToBuff";
int idxcol = 1;
CFInternetURLProtocolBuff buff = schema.getFactoryURLProtocol().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFDbTestPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFDbTestPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredURLProtocolId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredIsSecure(resultSet.getBoolean(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecuritySecFormBuff unpackSecFormResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackSecFormResultSetToBuff";
int idxcol = 1;
CFSecuritySecFormBuff buff = schema.getFactorySecForm().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFCrmDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFCrmDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredClusterId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredSecFormId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredSecAppId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredJEEServletMapName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecurityHostNodeBuff unpackHostNodeResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackHostNodeResultSetToBuff";
int idxcol = 1;
CFSecurityHostNodeBuff buff = schema.getFactoryHostNode().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecurityPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecurityPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredClusterId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredHostNodeId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredHostName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecurityISOCountryLanguageBuff unpackISOCountryLanguageResultSetToBuff(
ResultSet resultSet) throws SQLException {
final String S_ProcName = "unpackISOCountryLanguageResultSetToBuff";
int idxcol = 1;
CFSecurityISOCountryLanguageBuff buff = schema.getFactoryISOCountryLanguage().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFCrmMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFCrmMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
buff.setRequiredISOCountryId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredISOLanguageId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFCrmMemoDataBuff unpackMemoDataResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackMemoDataResultSetToBuff";
int idxcol = 1;
CFCrmMemoDataBuff buff = schema.getFactoryMemoData().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFCrmMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFCrmMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredMemoId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredContactId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredMemo(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
private Operator fromResultSet(ResultSet rs) throws SQLException {
long id = rs.getLong(1);
if (rs.wasNull()) id = -1;
String name = rs.getString(2);
if (rs.wasNull()) name = "";
int binding = rs.getInt(3);
if (rs.wasNull()) binding = -1;
String notation = rs.getString(4);
if (rs.wasNull()) notation = "";
String symbol = rs.getString(5);
if (rs.wasNull()) symbol = "";
String symbol_intern = rs.getString(6);
if (rs.wasNull()) symbol_intern = "";
int arity = rs.getInt(7);
if (rs.wasNull()) arity = -1;
String description = rs.getString(8);
if (rs.wasNull()) description = "";
String comment = rs.getString(9);
if (rs.wasNull()) comment = "";
Operator operator =
new Operator(
id, name, binding, notation, symbol, symbol_intern, arity, description, comment);
return operator;
}
public CacheItemHolder mapRow(ResultSet rs, Connection connection) throws SQLException {
URI uri = URI.create(rs.getString("uri"));
Vary vary = convertToVary(rs.getString("vary"));
Blob blob = rs.getBlob("payload");
Payload payload = null;
if (blob != null && !rs.wasNull()) {
payload =
new InputStreamPayload(
new ResultSetInputStream(rs, connection, blob.getBinaryStream()),
MIMEType.valueOf(rs.getString("mimetype")));
}
Status status = Status.valueOf(rs.getInt("status"));
Headers headers = convertToHeaders(rs.getString("headers"));
DateTime cacheTime = new DateTime(rs.getTimestamp("cachetime").getTime());
HTTPResponse response = new HTTPResponse(payload, status, headers);
return new CacheItemHolder(uri, vary, new CacheItem(rewriteResponse(response), cacheTime));
}
/**
* Method declaration
*
* @param r
*/
void formatResultSet(ResultSet r) {
if (r == null) {
String g[] = new String[1];
g[0] = "Result";
gResult.setHead(g);
g[0] = "(empty)";
gResult.addRow(g);
return;
}
try {
ResultSetMetaData m = r.getMetaData();
int col = m.getColumnCount();
String h[] = new String[col];
for (int i = 1; i <= col; i++) {
h[i - 1] = m.getColumnLabel(i);
}
gResult.setHead(h);
while (r.next()) {
for (int i = 1; i <= col; i++) {
h[i - 1] = r.getString(i);
if (r.wasNull()) {
h[i - 1] = "(null)";
}
}
gResult.addRow(h);
}
r.close();
} catch (SQLException e) {
}
}
protected CFSecurityISOCurrencyBuff unpackISOCurrencyResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackISOCurrencyResultSetToBuff";
int idxcol = 1;
CFSecurityISOCurrencyBuff buff = schema.getFactoryISOCurrency().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFInternetMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFInternetMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredISOCurrencyId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredISOCode(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
{
String colVal = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setOptionalUnitSymbol(null);
} else {
buff.setOptionalUnitSymbol(colVal);
}
}
idxcol++;
buff.setRequiredPrecis(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecurityISOTimezoneBuff unpackISOTimezoneResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackISOTimezoneResultSetToBuff";
int idxcol = 1;
CFSecurityISOTimezoneBuff buff = schema.getFactoryISOTimezone().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFDbTestPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFDbTestPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredISOTimezoneId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredIso8601(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredTZName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredTZHourOffset(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredTZMinOffset(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredVisible(resultSet.getBoolean(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFInternetTopDomainBuff unpackTopDomainResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackTopDomainResultSetToBuff";
int idxcol = 1;
String classCode = resultSet.getString(idxcol);
idxcol++;
CFInternetTopDomainBuff buff;
if (classCode.equals("TDOM")) {
buff = schema.getFactoryTopDomain().newBuff();
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Unrecognized class code \"" + classCode + "\"");
}
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFDbTestDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFDbTestDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredId(resultSet.getLong(idxcol));
idxcol++;
{
String colVal = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setOptionalDescription(null);
} else {
buff.setOptionalDescription(colVal);
}
}
idxcol++;
buff.setRequiredTldId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecuritySecDeviceBuff unpackSecDeviceResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackSecDeviceResultSetToBuff";
int idxcol = 1;
CFSecuritySecDeviceBuff buff = schema.getFactorySecDevice().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
buff.setRequiredSecUserId(CFSecurityMySqlSchema.convertUuidString(resultSet.getString(idxcol)));
idxcol++;
buff.setRequiredDevName(resultSet.getString(idxcol));
idxcol++;
{
String colVal = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setOptionalPubKey(null);
} else {
buff.setOptionalPubKey(colVal);
}
}
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
public void go(SystemEnvironment sysEnv) throws SDMSException {
Long sgId = null;
Long ZERO = new Long(0);
if (!sysEnv.cEnv.gid().contains(SDMSObject.adminGId)) {
SDMSPrivilege p = new SDMSPrivilege();
Vector v = SDMSMemberTable.idx_uId.getVector(sysEnv, sysEnv.cEnv.uid());
for (int i = 0; i < v.size(); i++) {
SDMSMember m = (SDMSMember) v.get(i);
try {
SDMSGrant gr =
SDMSGrantTable.idx_objectId_gId_getUnique(
sysEnv, new SDMSKey(ZERO, m.getGId(sysEnv)));
p.addPriv(sysEnv, gr.getPrivs(sysEnv).longValue());
} catch (NotFoundException nfe) {
}
}
try {
if (sysEnv.selectGroup != null) {
SDMSGroup sg = SDMSGroupTable.idx_name_getUnique(sysEnv, sysEnv.selectGroup);
sgId = sg.getId(sysEnv);
}
} catch (NotFoundException nfe) {
}
if (!(p.can(SDMSPrivilege.MANAGE_SEL) || (sgId != null && sysEnv.cEnv.gid().contains(sgId))))
throw new AccessViolationException(
new SDMSMessage(sysEnv, "03003081235", "Insufficient Privileges"));
}
int read = 0;
SDMSOutputContainer d_container = null;
if (cl_size > 0) {
clist = new int[cl_size];
ctype = new int[cl_size];
}
try {
Statement stmt = sysEnv.dbConnection.createStatement();
ResultSet rset = stmt.executeQuery(selectCmd);
ResultSetMetaData mdset = rset.getMetaData();
Vector desc = collist(mdset);
d_container = new SDMSOutputContainer(sysEnv, "Selected Values", desc);
while (rset.next()) {
Vector data = new Vector();
int j = 0;
for (int i = 1; i <= desc.size(); i++) {
Object o = rset.getObject(i);
if (cl_size > 0 && j < cl_size && i == clist[j]) {
o = convert(sysEnv, o, j);
j++;
}
data.addElement((rset.wasNull() ? null : o));
}
d_container.addData(sysEnv, data);
read++;
}
stmt.close();
sysEnv.dbConnection.commit();
} catch (SQLException sqle) {
try {
sysEnv.dbConnection.rollback();
} catch (SQLException sqle2) {
throw new RecoverableException(new SDMSMessage(sysEnv, "03310281524", "Connection lost"));
}
throw new CommonErrorException(
new SDMSMessage(sysEnv, "03204170024", "SQL Error : $1", sqle.toString()));
}
if (sv != null && sv.size() > 0) {
int sca[] = new int[sv.size()];
for (int i = 0; i < sv.size(); i++) {
sca[i] = ((Integer) sv.get(i)).intValue();
if (sca[i] >= d_container.columns)
throw new CommonErrorException(
new SDMSMessage(
sysEnv,
"03003081227",
"The sort column specified ($1) exceeds the number of columns in the output",
new Integer(sca[i])));
}
Collections.sort(d_container.dataset, d_container.getComparator(sysEnv, sca));
}
result.setOutputContainer(d_container);
result.setFeedback(
new SDMSMessage(sysEnv, "03204112153", "$1 Row(s) selected", new Integer(read)));
}