title: How can I specify the current schema for sql server in a jboss data source url?
body: <p>I've got some SQL queries like this</p>
  
  <pre><code>select user_id from 
  table_user where lower(email_address)=? and password=?
  </code></pre>
  
  <p>The schema for the application was recently updated but I don't really want to update every SQL query in the application. Is there a way to specify the current Schema from the JBOSS connection end?</p>
  
  <p>Old connection: <code>jdbc:sqlserver://myserver:1433;DatabaseName=db</code>
  Tried: <code>jdbc:sqlserver://myserver:1433;DatabaseName=db;currentSchema=abc</code></p>
  
  <p>I tried using <code>currentSchema</code> but that didn't help, I get a missing object exception when I run the queries (since I assume these are looking under dbo). Is there any way around updating the queries since I know that all the queries will run on schema <code>abc</code>?</p>