Thanks Kasper, this was exactly what I needed. I understand not all sources will support this.
*William Bowen* Senior Software Engineer, Zoomdata Mobile: <+1+718+300-4574>+1 <+1+718+300-4574>571-308-6361 Email: <bur...@zoomdata.com>william.bo...@zoomdata.com Website: www.zoomdata.com <http://www.zoomdata.com/> <http://www.facebook.com/Zoomdata> <http://www.linkedin.com/company/zoomdata> <http://twitter.com/Zoomdata> On Mon, Jul 31, 2017 at 7:00 PM, Kasper Sørensen < i.am.kasper.soren...@gmail.com> wrote: > Hi William, > > Yes, as long as you're just aware that what you're doing is then not > agnostic to datastore. It is definately only going to work with > JdbcDataContext and possibly (depending on the statement) only going to > work with your specific DB. > > Here's a snippet I've used some times to do ALTER TABLE (another type of > statement that isn't supported by MM): > > public void sqlUpdate(DataContext dataContext, String sql) { > final JdbcDataContext jdbcDataContext = (JdbcDataContext) > dataContext; > final Connection connection = jdbcDataContext.getConnection(); > try { > final Statement statement = connection.createStatement(); > final int sqlResult = statement.executeUpdate(sql); > statement.close(); > > logger.info("SQL update returned {}: {}", sqlResult, sql); > } catch (SQLException e) { > throw new IllegalStateException("SQL update failed: " + > sql, e); > } finally { > jdbcDataContext.close(connection); > } > } > > 2017-07-31 2:23 GMT-07:00 William Bowen <william.bo...@zoomdata.com>: > >> I have a need when creating a table to specify an index on a column. I >> can't see anything in TableCreationBuilder or ColumnCreationBuilder that >> would do the trick. >> >> My fallback plan was to try to just build and execute the CREATE INDEX >> statement myself, but the query parser complains that my query doesn't >> start with SELECT. >> >> Is there a way I can create this index? Or gain access to run underlying >> SQL to create it myself? >> >> Thanks, >> >> *William Bowen* Senior Software Engineer, Zoomdata >> Mobile: <+1+718+300-4574>+1 <+1+718+300-4574>571-308-6361 >> <(571)%20308-6361> >> Email: <bur...@zoomdata.com>william.bo...@zoomdata.com >> Website: www.zoomdata.com <http://www.zoomdata.com/> >> <http://www.facebook.com/Zoomdata> >> <http://www.linkedin.com/company/zoomdata> <http://twitter.com/Zoomdata> >> > >