I have a related question:
let's say I have an in-memory table with 2 columns (A and B) and 1 row:
| A | B |
| 1 | 2 |
I am able to get the result of SQL execution over H2 in-memory DB as JSON
resultset ( i.e. from stmt.getResultSet(), using gson ) as follows:
{
"metaData": [
"A",
"B"
],
"resultSet": [
[
"1",
"2"
]
],
"locator": {
"headerFromNum": {
"0": "A",
"1": "B"
},
"headerFromName": {
"a": 0,
"b": 1
},
"throwExceptions": true,
"NOT_IN_HEADER": -3467651
}
}
However, I'd like to get the result as a flat array like this:
[
{"A":"1", "B":"2"}
]
is there a simple way, say, to convert the H2 resultset to such an array?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/f06e3e2e-e15c-41c4-bd29-0c977b5f9df2o%40googlegroups.com.
