← Back to team overview

dhis2-devs team mailing list archive

Re: Last hibernate sequence value

 

I assume you are talking about entering Metadata, correct? Like data
elements or orgunits?

What is the interface you are proposing to give them? Will you have a form
with some kinds of restrictions?  Are you thinking to link Postgres into
Access via ODBC?

Will there be multiple simultaneous users of this, or is this for setting
up  a new database offline?

On Fri, Jan 16, 2015 at 9:20 AM, Greg Rowles <greg.rowles@xxxxxxxxx> wrote:

> Thanks Bob, Jason & Others
>
> I agree and understand but we have a DHIS2 implementors who prefer to work
> directly inside the DBMS who are still new to this complex environment. If
> they need to insert records directly into tables this gives them the
> opportunity to do the work they're used to (coming from version 1.4)...
>
> Regards,
> Greg
>
>
> On Fri, Jan 16, 2015 at 11:17 AM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
> wrote:
>
>> Jason is right.  You should only need the hibernate sequence number if
>> you are dealing with the database through sql. And if you are, then the
>> only safe way to use it is to get the sequence during the execution of the
>> statement.
>>
>> Getting the next sequence number and storing it to some variable with the
>> aim of using it at some time in the future is inherently fragile.
>>
>> On 16 January 2015 at 09:10, Jason Pickering <jason.p.pickering@xxxxxxxxx
>> > wrote:
>>
>>> Hi Greg,
>>> I would tend to agree with Lars that this should really not ever be
>>> required, but it would be good to know what the use case actually is.
>>>
>>> The easiest way to do this would be to create an SQL view in DHIS2 as
>>>
>>> SELECT currval('hibernate_sequence')
>>>
>>>
>>> In a multi-user database environment, this value is of course volatile,
>>> so you can never be sure what the actual current value is.
>>>
>>> If you really need to inject SQL into your database, then using
>>> something like 'nextval('hibernate_sequence'::regclass)'in your SQL,
>>> which will provide the next value of the sequence.
>>>
>>> Regards,
>>> Jason
>>>
>>> On Fri, Jan 16, 2015 at 9:49 AM, Lars Helge Øverland <
>>> larshelge@xxxxxxxxx> wrote:
>>>
>>>> Hi Greg,
>>>>
>>>> that would be easy to implement, but the idea is that it should never
>>>> be necessary to expose database details and instead work with the API. Do
>>>> you think you could elaborate a bit on the use-case?
>>>>
>>>> Lars
>>>>
>>>>
>>>> On Fri, Jan 16, 2015 at 8:35 AM, Greg Rowles <greg.rowles@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hi Devs
>>>>>
>>>>> Is there an easy way to expose the last hibernate sequence value
>>>>> through the web API?
>>>>>
>>>>> Greg
>>>>>
>>>>> --
>>>>> *Health Information Systems Program - South Africa*
>>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- -
>>>>> - - - *
>>>>> Mobile  :    073 246 2992
>>>>> Landline:   021 554 3130
>>>>> Fax:          086 733 8432
>>>>> Skype:      gregory_rowles
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> tel:+46764147049
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> *Health Information Systems Program - South Africa*
> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - -
> - *
> Mobile  :    073 246 2992
> Landline:   021 554 3130
> Fax:          086 733 8432
> Skype:      gregory_rowles
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Liberia: +231 770 496 123 or +231 886 146 381
Norway: +4791880522
Skype: knutstar
http://dhis2.org

References