title: Query Specific Stored Proc / Schema with JTDS SqlServer Driver
body: <p>I am writing some Java code to query a stored procedure in a SQLServer database.  My connection string looks like:</p>
  
  <pre><code>jdbc:jtds:sqlserver://address:port;database=dbname
  </code></pre>
  
  <p>Now when I try to call a stored procedure with the connection:</p>
  
  <pre><code>  String sql = "{call xyz.StoreProcNamedFoo(?,?,?,?)}";
  </code></pre>
  
  <p>I receive this error:</p>
  
  <pre><code>java.sql.SQLException: Could not find stored procedure 'xyz.StoreProcNamedFoo'.
  at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
  at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2886)
  at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2328)
  at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
  at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573)
  at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:764)
  </code></pre>
  
  <p>A DBA suggested he change the default schema to xyz, instead of abc.  That worked great, but he had to change it right back, since the default schema has to be abc.  My question is, how do I call this stored proc?    </p>