Re: [h2] Do not return table name in result set

2018-05-10 Thread Kerry Sainsbury
It will be a discrepancy between what Oracle return in ResultSetMetaData vs H2. I'd guess it's using 'getColumnLabel', which is a bit more loosely defined. On 10 May 2018 at 12:18, Ben Frey wrote:

Re: [h2] Do not return table name in result set

2018-05-09 Thread Ben Frey
That's what I would expect, but then why is the response from Oracle different than from H2? I can't imagine that ReadyAPI is doing anything to differentiate. In any case, we found a workaround by aliasing each column name in our queries. On Wednesday, May 9, 2018 at 1:35:58 PM UTC-5, Noel

Re: [h2] Do not return table name in result set

2018-05-09 Thread Noel Grandin
Um, that's some kind of ReadyAPI problem, we have nothing to do with returning XML result sets ​ -- 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

[h2] Do not return table name in result set

2018-05-09 Thread Ben Frey
I'm using H2 as a development in-memory database. I have some ReadyAPI tests that query either the in-memory DB or a test DB as part of their test steps, depending on the environment in which they run. When ReadyAPI hits the H2 DB, it returns XML like this: value