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

[Mohammad Jafari]

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]

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]

Thank you bro this Query solved my error also.