title: My In-memory DB fails to initalize and application fails to start on Java
body: <p>Please pardon me, if my question is not complete. I am quite new to the Java world and just starting. I have been trying to learn about microservices and was creating the age-old currency exchange and currency conversion microservices application.
  I am at a point, wherein the currencyexchange is to have an In-memory DB created. However, the initialization fails and the tables are not created. I did dig around for the error, however, Im unable to spot on the exact issue.
  My pom.xml is:</p>
  <pre class="lang-xml prettyprint-override"><code>    &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
      &lt;project xmlns=&quot;http://maven.apache.org/POM/4.0.0&quot; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;
          xsi:schemaLocation=&quot;http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd&quot;&gt;
          &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
          &lt;parent&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt;
              &lt;version&gt;2.6.3&lt;/version&gt;
              &lt;relativePath/&gt; &lt;!-- lookup parent from repository --&gt;
          &lt;/parent&gt;
          &lt;groupId&gt;com.infratute.currency.exchange&lt;/groupId&gt;
          &lt;artifactId&gt;currency-exchange&lt;/artifactId&gt;
          &lt;version&gt;0.0.1-SNAPSHOT&lt;/version&gt;
          &lt;packaging&gt;jar&lt;/packaging&gt;
          &lt;name&gt;currency-exchange&lt;/name&gt;
          &lt;description&gt;Demo Project for Dockerizing Microservices&lt;/description&gt;
          &lt;properties&gt;
              &lt;java.version&gt;11&lt;/java.version&gt;
              &lt;spring-cloud.version&gt;2021.0.0&lt;/spring-cloud.version&gt;
          &lt;/properties&gt;
          &lt;dependencies&gt;
              &lt;dependency&gt;
                  &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-boot-starter-actuator&lt;/artifactId&gt;
              &lt;/dependency&gt;
              &lt;dependency&gt;
                  &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;
              &lt;/dependency&gt;
              &lt;dependency&gt;
                  &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
              &lt;/dependency&gt;
              &lt;dependency&gt;
                  &lt;groupId&gt;org.springframework.cloud&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-cloud-starter-config&lt;/artifactId&gt;
              &lt;/dependency&gt;
      
              &lt;dependency&gt;
                  &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-boot-devtools&lt;/artifactId&gt;
                  &lt;scope&gt;runtime&lt;/scope&gt;
                  &lt;optional&gt;true&lt;/optional&gt;
              &lt;/dependency&gt;
              &lt;dependency&gt;
                  &lt;groupId&gt;com.h2database&lt;/groupId&gt;
                  &lt;artifactId&gt;h2&lt;/artifactId&gt;
                  &lt;scope&gt;runtime&lt;/scope&gt;
              &lt;/dependency&gt;
              &lt;dependency&gt;
                  &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                  &lt;artifactId&gt;spring-boot-starter-test&lt;/artifactId&gt;
                  &lt;scope&gt;test&lt;/scope&gt;
              &lt;/dependency&gt;
          &lt;/dependencies&gt;
          &lt;dependencyManagement&gt;
              &lt;dependencies&gt;
                  &lt;dependency&gt;
                      &lt;groupId&gt;org.springframework.cloud&lt;/groupId&gt;
                      &lt;artifactId&gt;spring-cloud-dependencies&lt;/artifactId&gt;
                      &lt;version&gt;${spring-cloud.version}&lt;/version&gt;
                      &lt;type&gt;pom&lt;/type&gt;
                      &lt;scope&gt;import&lt;/scope&gt;
                  &lt;/dependency&gt;
              &lt;/dependencies&gt;
          &lt;/dependencyManagement&gt;
      
          &lt;build&gt;
              &lt;plugins&gt;
                  &lt;plugin&gt;
                      &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
                      &lt;artifactId&gt;spring-boot-maven-plugin&lt;/artifactId&gt;
                  &lt;/plugin&gt;
              &lt;/plugins&gt;
          &lt;/build&gt;
      
      &lt;/project&gt;
  </code></pre>
  <p>My <code>CurrencyExchangeRate.java</code> is:</p>
  <pre class="lang-java prettyprint-override"><code>    package com.infratute.currency.exchange.currencyexchange.controller.entity;
      import java.math.BigDecimal;
      
      import javax.persistence.Column;
      import javax.persistence.Entity;
      import javax.persistence.Id;
      
      
      @Entity
      public class CurrencyExchangeRate {
          
          @Id
          private int id;
          
          @Column(name=&quot;exchange_from&quot;)
          private String from;
          
          @Column(name=&quot;exchange_to&quot;)
          private String to;
          
          private BigDecimal exchangeRate;
          
          private int port;
          
          protected CurrencyExchangeRate() {
              
          }
          public CurrencyExchangeRate(int id, String from, String to, BigDecimal exchangeRate) {
              super();
              this.id = id;
              this.from = from;
              this.to = to;
              this.exchangeRate = exchangeRate;
          }
          public int getId() {
              return id;
          }
          public void setId(int id) {
              this.id = id;
          }
          public String getFrom() {
              return from;
          }
          public void setFrom(String from) {
              this.from = from;
          }
          public String getTo() {
              return to;
          }
          public void setTo(String to) {
              this.to = to;
          }
          public BigDecimal getExchangeRate() {
              return exchangeRate;
          }
          public void setExchangeRate(BigDecimal exchangeRate) {
              this.exchangeRate = exchangeRate;
          }
          public int getPort() {
              return port;
          }
          public void setPort(int port) {
              this.port = port;
          }
          
      }
  </code></pre>
  <p>My Controller is <code>Currencyexchangecontroller.java</code>:</p>
  <pre class="lang-java prettyprint-override"><code>    package com.infratute.currency.exchange.currencyexchange.controller;
      
      import java.math.BigDecimal;
      
      import org.springframework.beans.factory.annotation.Autowired;
      import org.springframework.core.env.Environment;
      import org.springframework.web.bind.annotation.GetMapping;
      import org.springframework.web.bind.annotation.PathVariable;
      import org.springframework.web.bind.annotation.RestController;
      
      import com.infratute.currency.exchange.currencyexchange.controller.entity.CurrencyExchangeRate;
      
      @RestController
      public class Currencyexchangecontroller {
          
          
          @Autowired
          Environment environment;
          
          @GetMapping(&quot;/currency-service/from/{from}/to/{to}&quot;)
          public CurrencyExchangeRate getCurrencyExchangeRate(@PathVariable String from, @PathVariable String to) {
              
              CurrencyExchangeRate currencyExchangeRate = new CurrencyExchangeRate(1001, &quot;USD&quot;, &quot;INR&quot;, BigDecimal.valueOf(74));
              currencyExchangeRate.setPort(Integer.parseInt(environment.getProperty(&quot;local.server.port&quot;)));
              return currencyExchangeRate;
              
          }
          
      }
  </code></pre>
  <p>My <code>application.properties</code> are :</p>
  <pre><code>    spring.application.name = exchange-service
       spring.config.import=optional:configserver:
       server.port = 8001
       spring.jpa.show-sql=true
       spring.h2.console.enabled=true
       spring.h2.console.settings.web-allow-others=true
  </code></pre>
  <p>My <code>data.sql</code> file is as below:</p>
  <pre class="lang-sql prettyprint-override"><code>    INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
      VALUES(1001, 'USD, 'INR', 75, 0 );
      
      INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
      VALUES(1001, 'EUR, 'INR', 85, 0 );
      
      INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
      VALUES(1001, 'GBP, 'INR', 102, 0 );
      
      INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
      VALUES(1001, 'CAD, 'INR', 59, 0 );
      
      INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
      VALUES(1001, 'AUD, 'INR', 54, 0 );
  </code></pre>
  <p>With this configuration, when I start the application, it fails as below:</p>
  <pre><code>07:04:06.641 [Thread-0] DEBUG org.springframework.boot.devtools.restart.classloader.RestartClassLoader - Created RestartClassLoader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@7d528c7b
  
    .   ____          _            __ _ _
   /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
  ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
   \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
    '  |____| .__|_| |_|_| |_\__, | / / / /
   =========|_|==============|___/=/_/_/_/
   :: Spring Boot ::                (v2.6.3)
  
  2022-02-16 07:04:07.993  INFO 69941 --- [  restartedMain] c.i.c.e.c.CurrencyExchangeApplication    : Starting CurrencyExchangeApplication using Java 11.0.13 on localhost.localdomain with PID 69941 (/home/vroot1/docker/projects/cu-ex-se/currency-exchange/target/classes started by vroot1 in /home/vroot1/docker/projects/cu-ex-se/currency-exchange)
  2022-02-16 07:04:07.994  INFO 69941 --- [  restartedMain] c.i.c.e.c.CurrencyExchangeApplication    : No active profile set, falling back to default profiles: default
  2022-02-16 07:04:08.095  INFO 69941 --- [  restartedMain] o.s.b.context.config.ConfigDataLoader    : Fetching config from server at : http://localhost:8888
  2022-02-16 07:04:08.095  INFO 69941 --- [  restartedMain] o.s.b.context.config.ConfigDataLoader    : Connect Timeout Exception on Url - http://localhost:8888. Will be trying the next url if available
  2022-02-16 07:04:08.096  WARN 69941 --- [  restartedMain] o.s.b.context.config.ConfigDataLoader    : Could not locate PropertySource ([ConfigServerConfigDataResource@59fa3b92 uris = array&lt;String&gt;['http://localhost:8888'], optional = true, profiles = list['default']]): I/O error on GET request for &quot;http://localhost:8888/exchange-service/default&quot;: Connection refused (Connection refused); nested exception is java.net.ConnectException: Connection refused (Connection refused)
  2022-02-16 07:04:08.106  INFO 69941 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
  2022-02-16 07:04:08.106  INFO 69941 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
  2022-02-16 07:04:09.751  INFO 69941 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
  2022-02-16 07:04:09.771  INFO 69941 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 8 ms. Found 0 JPA repository interfaces.
  2022-02-16 07:04:10.077  INFO 69941 --- [  restartedMain] o.s.cloud.context.scope.GenericScope     : BeanFactory id=304ec315-dfdf-38f2-a007-59b03a83758a
  2022-02-16 07:04:11.325  INFO 69941 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8001 (http)
  2022-02-16 07:04:11.343  INFO 69941 --- [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
  2022-02-16 07:04:11.343  INFO 69941 --- [  restartedMain] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.56]
  2022-02-16 07:04:11.552  INFO 69941 --- [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
  2022-02-16 07:04:11.553  INFO 69941 --- [  restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3446 ms
  2022-02-16 07:04:11.786  INFO 69941 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
  2022-02-16 07:04:12.120  INFO 69941 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
  2022-02-16 07:04:12.153  INFO 69941 --- [  restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration    : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:a2ae51d8-784f-489e-9abc-e1c0a32added'
  2022-02-16 07:04:12.414  WARN 69941 --- [  restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of URL [file:/home/vroot1/docker/projects/cu-ex-se/currency-exchange/target/classes/data.sql]: INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table &quot;CURRENCY_EXCHANGE_RATE&quot; not found; SQL statement:
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ) [42102-200]
  2022-02-16 07:04:12.415  INFO 69941 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
  2022-02-16 07:04:12.429  INFO 69941 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
  2022-02-16 07:04:12.440  INFO 69941 --- [  restartedMain] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
  2022-02-16 07:04:12.555  INFO 69941 --- [  restartedMain] ConditionEvaluationReportLoggingListener : 
  
  Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
  2022-02-16 07:04:12.603 ERROR 69941 --- [  restartedMain] o.s.boot.SpringApplication               : Application run failed
  
  org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of URL [file:/home/vroot1/docker/projects/cu-ex-se/currency-exchange/target/classes/data.sql]: INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table &quot;CURRENCY_EXCHANGE_RATE&quot; not found; SQL statement:
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ) [42102-200]
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[spring-context-5.3.15.jar:5.3.15]
      at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908) ~[spring-context-5.3.15.jar:5.3.15]
      at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.15.jar:5.3.15]
      at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:732) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:414) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.SpringApplication.run(SpringApplication.java:302) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) ~[spring-boot-2.6.3.jar:2.6.3]
      at com.infratute.currency.exchange.currencyexchange.CurrencyExchangeApplication.main(CurrencyExchangeApplication.java:10) ~[classes/:na]
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
      at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
      at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.6.3.jar:2.6.3]
  Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of URL [file:/home/vroot1/docker/projects/cu-ex-se/currency-exchange/target/classes/data.sql]: INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table &quot;CURRENCY_EXCHANGE_RATE&quot; not found; SQL statement:
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ) [42102-200]
      at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:282) ~[spring-jdbc-5.3.15.jar:5.3.15]
      at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:254) ~[spring-jdbc-5.3.15.jar:5.3.15]
      at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:54) ~[spring-jdbc-5.3.15.jar:5.3.15]
      at org.springframework.boot.jdbc.init.DataSourceScriptDatabaseInitializer.runScripts(DataSourceScriptDatabaseInitializer.java:90) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.runScripts(AbstractScriptDatabaseInitializer.java:145) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyScripts(AbstractScriptDatabaseInitializer.java:107) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyDataScripts(AbstractScriptDatabaseInitializer.java:101) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initializeDatabase(AbstractScriptDatabaseInitializer.java:76) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.afterPropertiesSet(AbstractScriptDatabaseInitializer.java:65) ~[spring-boot-2.6.3.jar:2.6.3]
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.15.jar:5.3.15]
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.15.jar:5.3.15]
      ... 23 common frames omitted
  Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table &quot;CURRENCY_EXCHANGE_RATE&quot; not found; SQL statement:
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT) VALUES(1001, 'USD, 'INR', 75, 0 );
  
  INSERT INTO currency_exchange_Rate(ID, exchange_from, exchange_to, exchangeRate, PORT)
  VALUES(1001, 'EUR, 'INR', 85, 0 ) [42102-200]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.readTableOrView(Parser.java:7628) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.readTableOrView(Parser.java:7599) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.parseInsert(Parser.java:1747) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.parsePrepared(Parser.java:954) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.parse(Parser.java:843) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.parse(Parser.java:815) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.command.Parser.prepareCommand(Parser.java:738) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.engine.Session.prepareLocal(Session.java:657) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.engine.Session.prepareCommand(Session.java:595) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:212) ~[h2-1.4.200.jar:1.4.200]
      at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201) ~[h2-1.4.200.jar:1.4.200]
      at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na]
      at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na]
      at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:261) ~[spring-jdbc-5.3.15.jar:5.3.15]
      ... 33 common frames omitted
  </code></pre>
  <p>I can understand that the <code>exchangeRate</code> needs to be changed on the <code>data.sql</code> file, however, I am quite unsure the cause of the error, as to why the init of the app fails.
  Any assistance is much appreciated.</p>
  <p>Thanks in Advance.</p>