Lukas hi Thanks, helps to know I wasn't missing something - and adding the feature would be great.
Just to complete the linkage - in looking at this I also added the "issue" https://github.com/jOOQ/jOOQ/issues/5179 - that is for Unique indexes, but access to all indexes, non-unique also, would be very useful. On Friday, April 1, 2016 at 8:51:32 AM UTC+1, Lukas Eder wrote: > > Hello, > > Thank you very much for your feedback. > > There's currently no out of the box support for index meta information > queries in jOOQ. I have added a feature request for this. It certainly > makes sense to add such support to jOOQ: > https://github.com/jOOQ/jOOQ/issues/5181 > > In the meantime, you will have to resort to using JDBC's DatabaseMetaData. > You can easily fetch information via jOOQ as such: > > ctx.connection(connection -> { > > System.out.println(ctx.fetch(connection.getMetaData().getIndexInfo(...))); > }); > > > Hope this helps, > Lukas > > 2016-03-31 17:26 GMT+02:00 <[email protected] <javascript:>>: > >> >> I'm using JOOQ with H2. >> >> Within H2 Console I can see a list of Indexes >> >> >> <https://lh3.googleusercontent.com/-eV1icuH_98M/Vv07EPA0KJI/AAAAAAAAAAM/7JQbc2nKjW0fb0zDDxBMeO3d9pSXIrPaw/s1600/ProjectIndexes.jpg> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> And in H2 docs >> <https://javadocs.com/docs/com.h2database/h2/1.2.145/org/h2/table/MetaTable.java#getIndexes%28%29> >> >> how to getIndexes(), but is there a JOOQ interface which supports this? >> >> As far as I can see on Table reference >> <http://www.jooq.org/javadoc/latest/> I can only get Primary, Foreign or >> Unique Keys - none of these give access to the "INDEX_18" (GROUP_ID, NAME) >> event when it's marked Unique ?! >> >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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/d/optout.
