could not read a hi value - you need to populate the table hibernate_sequence

5,759 views
Skip to first unread message

Mohammad Jafari

unread,
Sep 29, 2015, 8:10:37 PM9/29/15
to HAPI FHIR
I got this error when building a new server with an empty database. I solved it by running the following in SQL but it will be nice if this can be included in the code.

INSERT INTO hibernate_sequence(next_val) VALUES (0);

James Agnew

unread,
Sep 29, 2015, 8:15:08 PM9/29/15
to Mohammad Jafari, HAPI FHIR
Hi Mohammad,

Which database platform are you seeing this on?

This issue seems to be caused by the upgrade from Hibernate 4.2 to Hibernate 5. I saw something similar for Derby and reported it to Hibernate here: https://hibernate.atlassian.net/browse/HHH-10110

The syntax you suggest doesn't look like Derby though, so maybe this is more widespread.

Cheers,
James

On Tue, Sep 29, 2015 at 8:10 PM, Mohammad Jafari <jaf...@gmail.com> wrote:
I got this error when building a new server with an empty database. I solved it by running the following in SQL but it will be nice if this can be included in the code.

INSERT INTO hibernate_sequence(next_val) VALUES (0);

--
You received this message because you are subscribed to the Google Groups "HAPI FHIR" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hapi-fhir+...@googlegroups.com.
To post to this group, send email to hapi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hapi-fhir/6c3b6ce7-c223-4cc8-be08-bfab66cbac77%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Chetan Harod

unread,
Mar 26, 2023, 1:37:46 PM3/26/23
to HAPI FHIR
Thank you bro this Query solved my error also.
Reply all
Reply to author
Forward
0 new messages