title: Java Spring JDBC SPRING_SESSION table doesn't exist
body: <p>I am developing a simple RESTfull service in Java Spring and using JDBCTemplate. </p>
  
  <p>However, I am getting a run time error, which I don't understand. It complains about SPRING_SESSION table not existing, however I think Spring should be able to create necessary tables as needed. </p>
  
  <p>application.properties: </p>
  
  <pre><code>spring.jpa.hibernate.ddl-auto=create
  spring.datasource.url=jdbc:mysql://localhost:3306/getfit?useSSL=false
  spring.datasource.username=root
  spring.datasource.password=***
  </code></pre>
  
  <p>Exception: </p>
  
  <pre><code>org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM SPRING_SESSION WHERE EXPIRY_TIME &lt; ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'getfit.SPRING_SESSION' doesn't exist
  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235) ~[spring-jdbc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  </code></pre>
  
  <p>Exception is triggered by some process attempting to delete record from table which doesn't exist. </p>
  
  <p>Manually creating the table leads to more errors (not existing columns). Setting </p>
  
  <pre><code>hibernate.ddl-auto=update
  </code></pre>
  
  <p>also doesn't help. </p>
  
  <p>Additionally, I have 
  modified MySQL configuration to allow upper case characters and this also did not help. </p>
  
  <p>Interestingly enough, this issue happened after I formatted my OS and cloned project from github. Before everything was working fine.</p>
  
  <p>Do you have any ideas what could go wrong? Let me know if you need me to show you some code.</p>
  
  <p>Thanks for looking in to this :) </p>