/** * <p>Instantiate ORM service.</p> * @return SrvOrmH2 - ORM service */ @Override public final synchronized SrvOrmH2<ResultSet> instantiateSrvOrm() { return new SrvOrmH2<ResultSet>(); }
public final <T> void insertEntity( final T pEntity) throws Exception { ColumnsValues columnsValues = evalColumnsValuesAndFillNewVersion(pEntity); 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, Field fieldId = getUtlReflection() .retrieveField(pEntity.getClass(), idName); fieldId.setAccessible(true); try { String insertedIdName = "INSERTEDID"; recordSet = getSrvDatabase().retrieveRecords( "select SCOPE_IDENTITY() as " + insertedIdName + ";"); recordSet.moveToFirst(); if (fieldId.getType() == Long.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), insertedIdName)); } else if (fieldId.getType() == Integer.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), insertedIdName)); } else {
public final <T> void insertEntity(final Map<String, Object> pAddParam, final T pEntity) throws Exception { ColumnsValues columnsValues = evalColumnsValues(pAddParam, pEntity); 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, Field fieldId = getUtlReflection() .retrieveField(pEntity.getClass(), idName[0]); fieldId.setAccessible(true); try { String insertedIdName = "INSERTEDID"; recordSet = getSrvDatabase().retrieveRecords( "select SCOPE_IDENTITY() as " + insertedIdName + ";"); recordSet.moveToFirst();
/** * <p>Instantiate ORM service.</p> * @return SrvOrmH2 - ORM service */ @Override public final synchronized SrvOrmH2<ResultSet> instantiateSrvOrm() { return new SrvOrmH2<ResultSet>(); }