title: Table Name Troubles With Hibernate Named Query
body: <p>I've got the following named query in Hibernate:</p>
  
  <pre><code>&lt;sql-query name="CreateLogTable"&gt;
    CREATE TABLE IF NOT EXISTS :tableName (
      `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
      `url` VARCHAR (750) NOT NULL, 
      `query` VARCHAR (500), 
      `ipaddress` VARCHAR (39), 
      `datetime` DATETIME NOT NULL, 
      `hits` MEDIUMINT UNSIGNED DEFAULT '0' NOT NULL, 
      `path_id` VARCHAR (8), 
      PRIMARY KEY(`id`),
      UNIQUE(`id`),
      INDEX(`id`,`query`,`datetime`,`path_id`)
    ) TYPE = MyISAM
  &lt;/sql-query&gt;
  </code></pre>
  
  <p>I am then trying to execute this line using the following line (constants point to correct items):</p>
  
  <pre><code>getSession().getNamedQuery(CREATE_SQL).setString(CREATE_SQL_TABLE_NAME_PARAM, "wibble").executeUpdate();
  </code></pre>
  
  <p>Now when I execute the code, I get an SQL error regarding the table name which is coming out surrounded by quotes:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS 'wibble' (
  </code></pre>
  
  <p>If I take the generated query and try it without the quotes around the table name, the query works fine.  It's just those quotes causing my issue.</p>
  
  <p>So my question is: What do I need to use instead of <code>setString</code> to make sure that my parameter isn't surrounded by quotes?  I've tried <code>setParameter</code> with no luck and I couldn't spot any better alternative from the API.</p>
  
  <p>Thanks for any input,
  Lee</p>