Dynamically building JSON with database results in Java

Question

I'm trying to build a JSON object based on the ResultSet(s) returned by our RDBMS. Each row in the ResultSet represents one object that we want to add to an array as part of the JSON. We've got the JSON schema defined in another file and I'm trying to figure out how to build the JSON based on the predefined schema.

I'm not sure if this is the best approach, to be honest. When first looking into how to approach this I was looking at JsonObjectBuilder, but with the number of fields involved it would get pretty messy.

I'm thinking my best bet might be to create a POJO to hold the data from the ResultSet and then use Jackson ObjectMapper to convert it into the desired JSON format.

In short:

How would I dynamically create a JSON object based on a schema and populated with the results of a database query?
If that's not feasible or efficient, what would be a better/the best way to dynamically create a JSON object populated with the results of a database query and adhering to a specific format?

What exactly do you need JSON for? If I understand the question correctly, a serializable POJO would work — OneCricketeer
– OneCricketeer, Commented May 2, 2016 at 16:14
The JSON will be POSTed to another endpoint for processing/insertion into a different database. That's why it has to adhere to a specific format. — dxh3707
– dxh3707, Commented May 2, 2016 at 16:19
And I'm guessing you have to stick with an RDBMS? If so, then DB->POJO->JSON is the best option you have. — OneCricketeer
– OneCricketeer, Commented May 2, 2016 at 16:25

DwB · Accepted Answer · 2016-05-02 16:46:49Z

1

Consider getting out of the JDBC game. MyBatis and Hibernate (probably other libs as well) do a much better job than you will ever do with a roll-your-own solution. I suggest MyBatis for simple stuff and Hibernate if you need features that are not in MyBatis.

With that in mind. create a POJO for the results of a MyBatis query then use Jackson (or gson or some other JSON library) to create the JSON.

answered May 2, 2016 at 16:46

DwB

38.6k11 gold badges62 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

Dynamically building JSON with database results in Java

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