/** * <p>Instantiate ORM service.</p> * @return SrvOrmPostgresql - ORM service */ @Override public final synchronized SrvOrmPostgresql<ResultSet> instantiateSrvOrm() { return new SrvOrmPostgresql<ResultSet>(); }
public final <T> void insertEntity( final T pEntity) throws Exception { ColumnsValues columnsValues = evalColumnsValuesAndFillNewVersion(pEntity); String idName = columnsValues.getIdName(); if (idName != null) { // if non-complex PK Field fieldId = getUtlReflection() .retrieveField(pEntity.getClass(), idName); String query = getHlpInsertUpdate().evalSqlInsert( pEntity.getClass().getSimpleName().toUpperCase(), columnsValues); recordSet = getSrvDatabase().retrieveRecords(query + " returning " + idName.toUpperCase() + ";\n"); recordSet.moveToFirst(); if (fieldId.getType() == Long.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), idName)); } else if (fieldId.getType() == Integer.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), idName)); } else { long result = getSrvDatabase().executeInsert( pEntity.getClass().getSimpleName().toUpperCase(), columnsValues); if (result != 1) { String query = getHlpInsertUpdate().evalSqlInsert(pEntity.getClass() .getSimpleName().toUpperCase(), columnsValues); throw new ExceptionWithCode(ISrvDatabase.ERROR_INSERT_UPDATE,
public final <T> void insertEntity(final Map<String, Object> pAddParam, final T pEntity) throws Exception { ColumnsValues columnsValues = evalColumnsValues(pAddParam, pEntity); String[] idName = columnsValues.getIdColumnsNames(); if (idName.length == 1) { // if non-composite PK Field fieldId = getUtlReflection() .retrieveField(pEntity.getClass(), idName[0]); fieldId.setAccessible(true); String query = getHlpInsertUpdate().evalSqlInsert( pEntity.getClass().getSimpleName().toUpperCase(), columnsValues); recordSet = getSrvDatabase().retrieveRecords(query + " returning " + idName[0].toUpperCase() + ";\n"); recordSet.moveToFirst(); long result = getSrvDatabase().executeInsert( pEntity.getClass().getSimpleName().toUpperCase(), columnsValues); if (result != 1) { String query = getHlpInsertUpdate().evalSqlInsert(pEntity.getClass() .getSimpleName().toUpperCase(), columnsValues); throw new ExceptionWithCode(ISrvDatabase.ERROR_INSERT_UPDATE,
/** * <p>Instantiate ORM service.</p> * @return SrvOrmPostgresql - ORM service */ @Override public final synchronized SrvOrmPostgresql<ResultSet> instantiateSrvOrm() { return new SrvOrmPostgresql<ResultSet>(); }