commit transaction about sqlite-dialect HOT 9 OPEN

<jpa:repositories base-package="com.accenture.moparva.datalayer.repos"
		entity-manager-factory-ref="emf" transaction-manager-ref="transactionManager" />

	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName">
			<value>${jdbc.driverClassName}</value>
		</property>
		<property name="url">
			<value>${jdbc.databaseurl}</value>
		</property>
		<property name="username">
			<value>${jdbc.username}</value>
		</property>
		<property name="password">
			<value>${jdbc.password}</value>
		</property>
	</bean>

	<bean id="emf"
		class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="packagesToScan" value="com.accenture.moparva.datalayer.models" />
		<property name="jpaVendorAdapter">
			<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" />
		</property>
		<property name="jpaProperties">
			<props>

				<prop key="hibernate.dialect">${jdbc.dialect}</prop>
				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
				<prop key="hibernate.connection.release_mode">auto</prop>
				<prop key="hibernate.transaction.auto_close_session">true</prop>
				<prop key="maxActive">1</prop>
				<prop key="org.hibernate.flushMode">COMMIT</prop>
				<prop key="spring.jpa.hibernate.ddl-auto">update</prop>
			</props>
		</property>

	</bean>

	<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="emf" />
	</bean>
	<tx:annotation-driven />

	<bean id="persistenceExceptionTranslationPostProcessor"
		class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />

	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<constructor-arg>
			<ref bean="dataSource" />
		</constructor-arg>
	</bean>

<prop key="hibernate.connection.release_mode">auto</prop>
<prop key="hibernate.transaction.auto_close_session">true</prop>
<prop key="org.hibernate.flushMode">COMMIT</prop>

<dependency>
				<groupId>org.xerial</groupId>
				<artifactId>sqlite-jdbc</artifactId>
				<version>3.8.11.2</version>
			</dependency>

@Entity
@Table(name = "AdminConfig")
public class AdminConfig {
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private Integer id;
	private String key;
	private String value;
	private Date createdAt;

	private Date updatedAt;


	

	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public Date getCreatedAt() {
		return createdAt;
	}
	public void setCreatedAt(Date createdAt) {
		this.createdAt = createdAt;
	}
	public Date getUpdatedAt() {
		return updatedAt;
	}
	public void setUpdatedAt(Date updatedAt) {
		this.updatedAt = updatedAt;
	}
	public String getKey() {
		return key;
	}
	public void setKey(String key) {
		this.key = key;
	}
	public String getValue() {
		return value;
	}
	public void setValue(String value) {
		this.value = value;
	}
}
public interface AdminConfigREPO extends JpaRepository<AdminConfig, Integer> {

	public List<AdminConfig> findByKey(String key);
	
}

And on the controller
@Controller
@RequestMapping("settings/")

public class ConfigApiController {

	@Autowired
	private AdminConfigREPO mAdminConfigREPO;

@RequestMapping(value = "/config", method = { RequestMethod.POST })
	public @ResponseBody List<AdminConfig> postOtfMessage(@RequestBody AdminConfig adminConfigs, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		
		
		mAdminConfigREPO.deleteAll();
		mAdminConfigREPO.saveAndFlush(adminConfigs);
		
	
			return adminConfigs;
		
	}
	}

<prop key="hibernate.dialect">${jdbc.dialect}</prop>
				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
				<prop key="hibernate.connection.release_mode">after_transaction</prop>
				<prop key="maxActive">1</prop>
				<prop key="spring.jpa.hibernate.ddl-auto">update</prop>

BEGIN (0 ns)
2017-12-01 23:02:11,530 [main] INFO  org.springframework.test.context.transaction.TransactionalTestExecutionListener - Began transaction (1): transaction manager [org.springframework.orm.jpa.JpaTransactionManager@4cfa83f9]; rollback [true]
Hibernate: delete from client
delete from client (1000000 ns)
Hibernate: insert into client (accounting_code, name, version) values (?, ?, ?)
insert into client (accounting_code, name, version) values (?, ?, ?) (0 ns)
select last_insert_rowid() (2000000 ns)
ROLLBACK; (0 ns)
BEGIN (0 ns)
COMMIT (0 ns)
2017-12-01 23:02:11,877 [main] INFO  org.springframework.test.context.transaction.TransactionalTestExecutionListener - Rolled back transaction after test execution for test context [TestContext@61a2aeb7 testClass = ClientServiceTest, testInstance = com.ossia.cra.service.ClientServiceTest@64b70f41, testMethod = testReplaceAll@ClientServiceTest, testException = [null], mergedContextConfiguration = [MergedContextConfiguration@5f8d9767 testClass = ClientServiceTest, locations = '{classpath:/META-INF/spring/applicationContext*.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader', parent = [null]]]

Hibernate: select next_val as id_val from hibernate_sequence
Hibernate: update hibernate_sequence set next_val= ? where next_val=?
2022-02-25 17:55:36.715  WARN 23624 --- [nio-8080-exec-1] o.h.e.j.s.SqlExceptionHelper             : SQL Error: 5, SQLState: null

spring.datasource.driver-class-name=org.sqlite.JDBC
spring.jpa.properties.hibernate.dialect=org.sqlite.hibernate.dialect.SQLiteDialect
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

spring.jpa.properties.hibernate.connection.release_mode =auto
spring.jpa.properties.hibernate.transaction.auto_close_session=true
spring.jpa.properties.org.hibernate.flushMode=COMMIT