This is probably an extremely basic ("dumb") question: I am trying to obtain the table names from several databases in a MSFT SQL Server, via the jtds driver. The hardcoded query works fine. I can't figure out how to parameterize the FROM part of the query, this is what I tried and it did not work:

(jdbc/execute! c ["select table_name from ? where TABLE_TYPE = 'BASE TABLE'" "AIRPORT.INFORMATION_SCHEMA.TABLES"])

I don't believe JDBC allows parameterization of the from clause.

OK, thx. For this simple case, I can just create the entire string myself, and hand it to execute!.

@dcj Take a look at HoneySQL for a nice way to programmatically build queries. You'd be able to do that query with the from as a parameter.

Cool, will do!