Hello Paul, While I cannot talk for all users, on this user group, you're probably breaking new grounds. I don't think that the FT_SEARCH "table" is really a table on the disk. To me, it looks like a table-valued function (just like FT_SEARCH_DATA) that maps to:
org.h2.fulltext.FullText.search(conn, text, limit, offset); org.h2.fulltext.FullText.searchData(conn, text, limit, offset); Both functions return a JDBC ResultSet, which is H2's way of returning tables (or rather, cursors) from a function. Taken from: http://www.h2database.com/html/tutorial.html#fulltext You can use this function with jOOQ - either by using DSL.unnest(), or DSL.table() on a generated function that returns a Result - or by using plain SQL http://www.jooq.org/doc/latest/manual/sql-building/plain-sql/ I'll put a reminder on the long-term roadmap. Maybe, there is some potential for jOOQ to provide a more intuitive integration for this feature: https://github.com/jOOQ/jOOQ/issues/3033 Cheers Lukas 2014-02-11 19:48 GMT+01:00 Paul Eden <[email protected]>: > Hi > > Has anyone done this yet that could shed light? > > After creating a native text index on a simple table (which creates the > FT_SEARCH table *somewhere*..) how do you use jOOQ to query the FT_SEARCH > table to get the query strings? > > From what I can see, the text search table does not get generated in > PUBLIC, or under FT nor under INFORMATION_SCHEMA (I am currently assuming I > would need to generate classes for the FT_SEARCH table?). > > Alternatively if there is a link explaining it.. even better, but there > were no related posts in here. > > many thanks > > paul > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
