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.
Comments
Post a Comment