It works! Making a custom pluggable table was the right way. Thanks Noel!

El miércoles, 8 de abril de 2015, 13:13:20 (UTC+2), Pablo Beltran escribió:
>
> Hi,
>
> Depending on the connection url, *function as tables* should return a 
> resultset with a different number of columns.
>
> Example: A table "T" with four columns (a,b,c,d).
>
> When it is invoked with jdbc:default:connection then it should return the 
> four columns (a,b,c,d). However, if a user runs:
>
> select a,d from T
>
> then it should return a resultset with two columns only (a,d) as user 
> would do:
>
> rs.getString(1) --> a
> rs.getString(2) --> d
>
> Hence, the requested columns (a,d) should be known when the resultset is 
> created. I've debugged the Connection param but I was unable to find the 
> original (or the parsed) SQL query. 
>
> How could it be retrieved?
>
> Thanks!
> Pablo.
>
>

-- 
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to