title: Make schema created by Spring JDBC the default schema
body: <p>I'm using Spring Boot and JDBC for my database connection. I placed schema.sql at the classpath to initialize a schema and tables. </p>
  
  <p>Because the schema doesn't exist yet while connecting to the datasource, I have to configure the datasource in application.properties like so:</p>
  
  <pre><code>spring.datasource.url=jdbc:mysql://localhost:3306/
  </code></pre>
  
  <p>schema.sql:</p>
  
  <pre><code>CREATE DATABASE IF NOT EXISTS &lt;schema_name&gt;
  USE &lt;schema.name&gt;;
  
  CREATE TABLE...
  </code></pre>
  
  <p>So I select the schema after creating it. This obviously doesn't persist for too long.</p>
  
  <p>How do I configure this properly? Is there a way to select a default schema after the create script or maybe change the datasource url?</p>