java - JSON data store in POSTGRES (EclipseLink) -


i deisgn database , model below eclipselink , postgres.

what best approach same? how ro store json data in postgres , retrieve?

my data model below.

names               surnames id name             id         json 1   test            100        {test:temp, test2:dfdf, test3:fsdf}  mapping namesid surnamesid  place        country  1       100        san jose      ca 

you can store json in character column (varchar, text). if want use json type may need use converter convert between , field type.

if want convert json data objects, can use jaxb eclipselink moxy this.

http://wiki.eclipse.org/eclipselink/examples/moxy#moxy.27s_json-binding

you write own converter this, or in eclipselink 2.6 dev stream there new json convert option.

see, http://wiki.eclipse.org/eclipselink/designdocs/406993


Comments

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -