Storing entire JSON object in PostgreSQL DB

Question

I'm sending a JS object from my front-end to my Java backend, and I'm passing a object like so, which contains different types

wrapperObject = {
  JSONOBJ = {
      'key': 'value'
  },
  id: '123',
  date: 'exampledate'
}

My java backend then takes this wrapperObject and converts every field inside into a value inside of a hashmap Map. Whenever it reaches the JSONObject, however, it parses it and attempts to insert into the db and I reach a

bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: No hstore extension installed.

What can I do about this, and is there a better way of approaching this?

Andrelton · Accepted Answer · 2015-08-06 00:26:01Z

1

It sounds like it may be as simple as adding the hstore extension. The PostgreSQL documentation for installation looks pretty straightforward:

Let me know if I'm missing something, hope this helps!

answered Aug 6, 2015 at 0:26

Andrelton

1501 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Storing entire JSON object in PostgreSQL DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related