incubator-empire-db-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frank Lupo <frank_l...@email.it>
Subject Re: postgresql AUTO_INC
Date Tue, 31 Mar 2009 09:50:50 GMT
Ok
I implementig the emulate sequence table in DBDatabaseDriver
rename default getNextSequenceValue in getNextSequenceValueImpl
=====================================
    private boolean emulateSequenceTable = false;
    private String emulateSequenceTableName = "Sequences";

    public boolean isEmulateSequenceTable() {
        return emulateSequenceTable;
    }

    public void setEmulateSequenceTable(boolean emulateSequenceTable) {
        this.emulateSequenceTable = emulateSequenceTable;
    }

    public String getEmulateSequenceTableName() {
        return emulateSequenceTableName;
    }

    public void setEmulateSequenceTableName(String 
emulateSequenceTableName) {
        this.emulateSequenceTableName = emulateSequenceTableName;
    }

    public Object getNextSequenceValue(DBDatabase db,String seqName, int 
minValue, Connection conn){
        //check if emulated
        if (emulateSequenceTable)
        {  
            // Use a sequence Table to generate Sequences
            DBSeqTable table = 
(DBSeqTable)db.getTable(emulateSequenceTableName);
            if (table == null) {
                table = new DBSeqTable(emulateSequenceTableName, db);
            }
           
            return table.getNextValue(seqName, minValue, conn);
        }else {
            return getNextSequenceValueImpl(db, seqName, minValue, conn);
        }
    }
================================


Francis De Brabandere ha scritto:
> Rainer, what do you think about these ideas?
>
> Frank, could you create an issue for the second question (non-pk auto inc)?
>
> On Fri, Mar 27, 2009 at 11:32 AM, Frank Lupo <frank_lupo@email.it> wrote:
>   
>> The (DataType.AUTOINC) sequence has emulated using getRecordDefaultValue in
>> DBTableColumn is a good idea.
>> If using serial the value are insert in automatic mode on postgresql.
>> My idea is create a new dataType DataType.AUTOINC_NATIVE.
>>
>> Second question...
>> I have create a column "version" DataType.AUTOINC no primarykey column.
>> If update record AUTOINC is not update.
>> In my opinion if column is not a primarykey the AUTOINC column must be
>> updated.
>>
>>
>> Francis De Brabandere ha scritto:
>>     
>>> I'll have a look at all these issues this weekend, but if you have it
>>> all fixed locally can you post a patch on jira?
>>>
>>> 2009/3/27 Frank Lupo <frank_lupo@email.it>:
>>>
>>>       
>>>> Hi,
>>>> current datatype auto_inc in postgresql definition create a separate
>>>> sequence.
>>>> Why is not used serial type in postgresql?
>>>>
>>>> Best regards
>>>>
>>>>
>>>> --
>>>> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
>>>> autenticato? GRATIS solo con Email.it http://www.email.it/f
>>>>
>>>> Sponsor:
>>>> Con Poker Club anche a Marzo il montepremi č garantito: ogni lunedě,
>>>> giovedě
>>>> e domenica vinci fino a 25.000 !
>>>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8806&d=27-3
>>>>
>>>>
>>>>         
>>>
>>>  ------------------------------------------------------------------------
>>>
>>>
>>> Nessun virus nel messaggio in arrivo.
>>> Controllato da AVG - www.avg.com Versione: 8.0.238 / Database dei virus:
>>> 270.11.29/2024 -  Data di rilascio: 03/26/09 07:12:00
>>>
>>>
>>>       
>>
>>
>> --
>> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
>> autenticato? GRATIS solo con Email.it http://www.email.it/f
>>
>> Sponsor:
>> Gioca con Poker Club! Scegli il torneo che fa per te, ogni settimana puoi
>> vincere oltre 240.000 EURO!
>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8805&d=27-3
>>
>>     
>
>
>
>   
> ------------------------------------------------------------------------
>
>
> Nessun virus nel messaggio in arrivo.
> Controllato da AVG - www.avg.com 
> Versione: 8.0.238 / Database dei virus: 270.11.30/2026 -  Data di rilascio: 03/27/09
07:13:00
>
>   


 
 
 --
 Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS
solo con Email.it http://www.email.it/f
 
 Sponsor:
 Apre VideoAnnunciLavoro.net: dove domanda ed offerta di lavoro hanno una marcia in piů.
Se credi in te stesso fatti vedere! č gratuito
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8863&d=31-3

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message