SpringDataJPA | A spring boot application | Application Framework library

I'm having problems executing an update query in springdatajpa. here is the code in the repository layer:

I am trying to create a simple SpringDataJPA application. I am using H2 database. After annotating the model class with @entity annotation the table is successfully created in H2 DB and the same can be viewed through the h2-console. however to initialise the table i am trying to insert the values from data.sql but while starting the application the error indicates that the table is not being found . Why is the table not being found when I am able to view the ?

POM.xml

Model Class

application.properties

data.sql

Console output

I'm using hibernate 5.3.11 with SpringDataJpa and PostgreSQL and I get "org.hibernate.id.IdentifierGenerationException: attempted to assign id from null one-to-one property [packagename.ClassB.classA]" when trying to update a complex entity ClassC.

• ClassC is @OneToMany with ClassA
• ClassA is @OneToOne with ClassB.
• All entities have links to each other before calling update method.
• ClassC is a parent entity and cascades to ClassA, which cascades to ClassB.
• The issue seems to be related only to A<->B relationship.
• show-sql tells me that ClassA persists fine, but seems like for some reason it looses link to ClassB somewhere in hibernate.
• Persisting entity for the first time works fine. The error only comes on update. And I don't even update existing entities of ClassB and ClassA, I replace them with new ones.

Relationship:

ClassB in SQL:

ClassA in SQL:

Java entities:

Can someone please help me? I am trying to use the spring data JPA with a soft delete using the where clause in an inherited class. However, it seems that is not considering the inheritance when Pageable class generates its query to count the number of rows.

ClassA class (Base class): <- the deleted column is here

I have updated some dependency in my project after that my hibernate configuration class showing Nullpointerexception.

I'm using spring data JPA repository with hibernate, it's been more than 24 hours still not found any appropriate solution regarding small problem.

Some Solution which I have already tried:-

1. Providing a bean name with @bean(name="entityManagerFactory")
2. Providing a ref like @EnableJpaRepositories(basePackages = "com.carportal.repository", entityManagerFactoryRef ="entityManagerFactory")
3. By changing dialect, By changing DriverClassName, by changing datasource manager

Issue That I'm Facing