How to use

SrvOrmPostgresql

in

org.beigesoft.orm.service

/**
 * <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>();
}