given i want to creat poc project like this 

### **Absolutely! Building a Proof of Concept (PoC) for a Synchronous Request-Response Communication Pattern Between Two Microservices Within an E-commerce Architecture**

Building a proof of concept (PoC) for a synchronous Request-Response communication pattern between two microservices within an e-commerce architecture is a great way to understand and implement cloud-native principles. Below is a comprehensive roadmap to guide you through this process using Spring Boot, Spring Cloud, GitHub Actions, and Docker.

### **Roadmap Overview**

1. **Define the Microservices and Their Responsibilities**
2. **Set Up the Development Environment**
3. **Create Individual Microservices**
    - Service A (Client)
    - Service B (Server)
4. **Implement Synchronous Request-Response Communication**
5. **Containerize Microservices with Docker**
6. **Set Up CI/CD Pipeline with GitHub Actions**
7. **Testing and Validation**
8. **Deployment and Monitoring**

**. Define the Microservices and Their Responsibilities**

Before diving into development, clearly define the two microservices and their respective business logic within an e-commerce context. For this PoC, let's consider:

**Service A: Order Service (Client)**

- **Responsibility**: Handles customer orders.
- **Business Logic**: When a new order is placed, it needs to verify product availability by communicating with the Inventory Service.

**Service B: Inventory Service (Server)**

- **Responsibility**: Manages product inventory.
- **Business Logic**: Provides product availability status when queried by the Order Service.

**Diagram:**

**Diagram:**

```
Order Service (Service A) <---- synchronous request-response ----> Inventory Service (Service B)

```

---

### **2. Set Up the Development Environment**

Ensure you have the necessary tools and environments set up:

- Java Development Kit (JDK) 17+
- Spring Boot and Spring Cloud
- Maven or Gradle
- Docker
- Git and GitHub Account
- Integrated Development Environment (IDE) like IntelliJ IDEA or VS Code
- Postman or cURL for API testing

### **3. Create Individual Microservices**

### **A. Service B: Inventory Service (Server)**

**Initialize Spring Boot Project:**
Use Spring Initializr with the following dependencies:

- Spring Web
- Spring Boot Actuator
- Spring Cloud Config Client (if using config server)
- Spring Data JPA (with H2 Database for simplicity)

like this 

```xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>3.3.5</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.amir</groupId>
	<artifactId>inventory-service</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>inventory-service</name>
	<description>Demo project for Inventory Service </description>
	<url/>
	<licenses>
		<license/>
	</licenses>
	<developers>
		<developer/>
	</developers>
	<scm>
		<connection/>
		<developerConnection/>
		<tag/>
		<url/>
	</scm>
	<properties>
		<java.version>17</java.version>
		<spring-cloud.version>2023.0.3</spring-cloud.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.cloud</groupId>
			<artifactId>spring-cloud-starter-config</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>com.h2database</groupId>
			<artifactId>h2</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>
	<dependencyManagement>
		<dependencies>
			<dependency>
				<groupId>org.springframework.cloud</groupId>
				<artifactId>spring-cloud-dependencies</artifactId>
				<version>${spring-cloud.version}</version>
				<type>pom</type>
				<scope>import</scope>
			</dependency>
		</dependencies>
	</dependencyManagement>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<excludes>
						<exclude>
							<groupId>org.projectlombok</groupId>
							<artifactId>lombok</artifactId>
						</exclude>
					</excludes>
				</configuration>
			</plugin>
		</plugins>
	</build>

</project>

```

```java
package com.amir.order.models;

import lombok.Data;
import lombok.AllArgsConstructor;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Order {

    private Long  orderId;
    private Long productId;
    private int quantity;
    private String status;
    
}
```

```java
package com.amir.inventory.repository;

import org.springframework.data.jpa.repository.JpaRepository;

import com.amir.inventory.models.Product;

public interface ProductRepository extends JpaRepository<Product, Long> {

}

```

```java
package com.amir.inventory.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.amir.inventory.repository.ProductRepository;

@Service
public class InventoryService {
    @Autowired
    private ProductRepository productRepository;

    public boolean isProductInStock(Long productId , int requestedQuantity){
        return productRepository.findById(productId)
        .map(product -> product.getQuantity() >= requestedQuantity)
        .orElse(false);
    }
    
}

```

```java
package com.amir.inventory.controller;

import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import com.amir.inventory.service.InventoryService;

@RestController
@RequestMapping("/inventory")
public class InventoryController {

    private InventoryService inventoryService;

    public ResponseEntity<Boolean> checkAvailability(
        @RequestParam Long productId,
        @RequestParam int quantity
    ){
        boolean available = inventoryService.isProductInStock(productId, quantity);
        return ResponseEntity.ok(available);}
    
}

```

[application.properties](http://application.properties) 

```
spring.application.name=inventory-service

```

and inside the resouces 

data.sql 

like this 

```sql
INSERT INTO product (id, name, quantity) VALUES (1, 'Laptop', 50);
INSERT INTO product (id, name, quantity) VALUES (2, 'Smartphone', 100);

```

Q- but it get this error 

sers\PCS\.vscode\extensions\redhat.java-1.36.0-win32-x64\jre\17.0.13-win32-x86_64\bin\java.exe' '@C:\Users\PCS\AppData\Local\Temp\cp_4t6r5z2me3fqqeqejvl38mttg.argfile' 'com.amir.inventory.InventoryServiceApplication'

---

Description:

No spring.config.import property has been defined

Action:

Add a spring.config.import=configserver: property to your configuration.
If configuration is not required add spring.config.import=optional:configserver: instead.
To disable this check, set spring.cloud.config.enabled=false or
spring.cloud.config.import-check.enabled=false.

Q- what is the error and how to fix it 

oki just  i add in the [application.properties](http://application.properties) to diable the config server oki

Q- now i reun it and get this error “

PS C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service>  c:; cd 'c:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service'; & 'C:\Users\PCS\.vscode\extensions\redhat.java-1.36.0-win32-x64\jre\17.0.13-win32-x86_64\bin\java.exe' '@C:\Users\PCS\AppData\Local\Temp\cp_4t6r5z2me3fqqeqejvl38mttg.argfile' 'com.amir.inventory.InventoryServiceApplication'

.   ____          _            __ _ _
/\\ / *' __ _ () __  __ _ \ \ \ \
( ( )\*__ | '_ | '*| | '* \/ *` | \ \ \ \
\\/  )| |)| | | | | || (| |  ) ) ) )
'  || .__|| |*|*| |*\**, | / / / /
=========|*|==============|***/=/*/*/_/

:: Spring Boot ::                (v3.3.5)

2024-11-13T19:57:10.975+01:00  INFO 8292 --- [inventory-service] [  restartedMain] c.a.i.InventoryServiceApplication        : Starting InventoryServiceApplication using Java 17.0.13 with PID 8292 (C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service\target\classes started by PCS in C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service)
2024-11-13T19:57:10.984+01:00  INFO 8292 --- [inventory-service] [  restartedMain] c.a.i.InventoryServiceApplication        : No active profile set, falling back to 1 default profile: "default"
2024-11-13T19:57:11.036+01:00  INFO 8292 --- [inventory-service] [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2024-11-13T19:57:11.036+01:00  INFO 8292 --- [inventory-service] [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the '[logging.level.web](http://logging.level.web/)' property to 'DEBUG'
2024-11-13T19:57:11.709+01:00  INFO 8292 --- [inventory-service] [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-11-13T19:57:11.766+01:00  INFO 8292 --- [inventory-service] [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 51 ms. Found 1 JPA repository interface.

2024-11-13T19:57:11.946+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.s.cloud.context.scope.GenericScope     : BeanFactory id=8b77e563-38a8-3371-89f6-0ff651483e3f
2024-11-13T19:57:12.488+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port 8080 (http)
2024-11-13T19:57:12.498+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2024-11-13T19:57:12.499+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.apache.catalina.core.StandardEngine    : Starting Servlet engine: [Apache Tomcat/10.1.31]
2024-11-13T19:57:12.553+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2024-11-13T19:57:12.555+01:00  INFO 8292 --- [inventory-service] [  restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1517 ms
2024-11-13T19:57:12.595+01:00  INFO 8292 --- [inventory-service] [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2024-11-13T19:57:12.797+01:00  INFO 8292 --- [inventory-service] [  restartedMain] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Added connection conn0: url=jdbc:h2:mem:f346128e-3d0a-4f89-a396-eb11e4ab53e7 user=SA
2024-11-13T19:57:12.799+01:00  INFO 8292 --- [inventory-service] [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2024-11-13T19:57:12.807+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration    : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:f346128e-3d0a-4f89-a396-eb11e4ab53e7'
2024-11-13T19:57:12.891+01:00  WARN 8292 --- [inventory-service] [  restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Failed to initialize dependency 'dataSourceScriptDatabaseInitializer' of LoadTimeWeaverAware bean 'entityManagerFactory': Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Failed to execute SQL script statement #1 of file [C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service\target\classes\data.sql]: INSERT INTO product (id, name, quantity) VALUES (1, 'Laptop', 50)
2024-11-13T19:57:12.892+01:00  INFO 8292 --- [inventory-service] [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2024-11-13T19:57:12.894+01:00  INFO 8292 --- [inventory-service] [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
2024-11-13T19:57:12.898+01:00  INFO 8292 --- [inventory-service] [  restartedMain] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2024-11-13T19:57:12.911+01:00  INFO 8292 --- [inventory-service] [  restartedMain] .s.b.a.l.ConditionEvaluationReportLogger :

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2024-11-13T19:57:12.935+01:00 ERROR 8292 --- [inventory-service] [  restartedMain] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Failed to initialize dependency 'dataSourceScriptDatabaseInitializer' of LoadTimeWeaverAware bean 'entityManagerFactory': Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Failed to execute SQL script statement #1 of file [C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service\target\classes\data.sql]: INSERT INTO product (id, name, quantity) VALUES (1, 'Laptop', 50)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:326) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:205) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:954) ~[spring-context-6.1.14.jar:6.1.14]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:625) ~[spring-context-6.1.14.jar:6.1.14]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:335) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352) ~[spring-boot-3.3.5.jar:3.3.5]
at com.amir.inventory.InventoryServiceApplication.main(InventoryServiceApplication.java:10) ~[classes/:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]

at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50) ~[spring-boot-devtools-3.3.5.jar:3.3.5]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Failed to execute SQL script statement #1 of file [C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service\target\classes\data.sql]: INSERT INTO product (id, name, quantity) VALUES (1, 'Laptop', 50)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1806) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:313) ~[spring-beans-6.1.14.jar:6.1.14]
... 15 common frames omitted
Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of file [C:\Users\PCS\Desktop\Github\Synchronous-Request-Response-Communication-Pattern\inventory-service\target\classes\data.sql]: INSERT INTO product (id, name, quantity) VALUES (1, 'Laptop', 50)

at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:282) ~[spring-jdbc-6.1.14.jar:6.1.14]
at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:254) ~[spring-jdbc-6.1.14.jar:6.1.14]
at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:54) ~[spring-jdbc-6.1.14.jar:6.1.14]
at org.springframework.boot.jdbc.init.DataSourceScriptDatabaseInitializer.runScripts(DataSourceScriptDatabaseInitializer.java:87) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.runScripts(AbstractScriptDatabaseInitializer.java:146) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyScripts(AbstractScriptDatabaseInitializer.java:108) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyDataScripts(AbstractScriptDatabaseInitializer.java:102) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initializeDatabase(AbstractScriptDatabaseInitializer.java:77) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.afterPropertiesSet(AbstractScriptDatabaseInitializer.java:66) ~[spring-boot-3.3.5.jar:3.3.5]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853) ~[spring-beans-6.1.14.jar:6.1.14]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1802) ~[spring-beans-6.1.14.jar:6.1.14]
... 22 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "PRODUCT" not found (this database is empty); SQL statement:
INSERT INTO product (id, name, quantity) VALUES (1, 'Laptop', 50) [42104-224]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:514) ~[h2-2.2.224.jar:2.2.224]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:489) ~[h2-2.2.224.jar:2.2.224]

at org.h2.message.DbException.get(DbException.java:223) ~[h2-2.2.224.jar:2.2.224]
at org.h2.message.DbException.get(DbException.java:199) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8051) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8035) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.readTableOrView(Parser.java:8024) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.readTableOrView(Parser.java:7990) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.parseInsert(Parser.java:1540) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.parsePrepared(Parser.java:719) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.parse(Parser.java:592) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.parse(Parser.java:564) ~[h2-2.2.224.jar:2.2.224]
at org.h2.command.Parser.prepareCommand(Parser.java:483) ~[h2-2.2.224.jar:2.2.224]
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:639) ~[h2-2.2.224.jar:2.2.224]
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:559) ~[h2-2.2.224.jar:2.2.224]

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1166) ~[h2-2.2.224.jar:2.2.224]

at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:245) ~[h2-2.2.224.jar:2.2.224]

at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:231) ~[h2-2.2.224.jar:2.2.224]
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-5.1.0.jar:na]

at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-5.1.0.jar:na]
at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:261) ~[spring-jdbc-6.1.14.jar:6.1.14]
... 32 common frames omitted

Q- how to fix it