TransactionManagement | J2EE - Company Transaction Management | Object-Relational Mapping library

I am implementing a backend with two database connections. One to a MS Access DB and another one to a MySQL DB. I've setup two configuration classes and the application is running without any error message, but does not create the tables for my entities in mysql db.

Project structure:

I'm trying to insert some data into H2 database using HibernateTemplate but I don't know why hibernate doesn't auto increment id of entity { Country }. (the project contains all dependencies required for runing the application , spring dependencies , hibernate dependencies , ...)

error message:

I was setting up a basic CRUD web app with JPA in plain Spring (no Spring Boot or Spring Data JPA) for educational purposes and faced a strange problem: Spring doesn't translate exceptions for my repository. According to the Spring documentation (here and here), it is sufficient to mark the repository with the @Repository annotation and Spring will automatically enable exception translation for this repository.

However, when I did so and triggered a UNIQUE constraint violation, I still was getting a JPA PersistenceException (with a Hibernate ConstraintViolationException inside) instead of the Spring DataIntegrityViolationException.

I used pure Java Spring configuration and it took me quite some time to realize that I should compare it with the XML configuration in the documentation. Compared to the pure Java configuration, the XML configuration adds a PersistenceExceptionTranslationPostProcessor into the context. When I added it manually with @Bean, it worked, but now I have a question.

Have I misconfigured something? The Spring documentation doesn't require registering that post-processor manually for pure Java configuration. Maybe there is another way to register it, say an @EnableXXX annotation?

Here is the summary of my configuration.

Hello I'm new to Java and Spring itself. Now I'm studying JPA, in general, the question is this: Why does Hibernate look for the last_name column in BaseEntity when I have this column in my drivers?

All this happens when I try to call findAll and create a query with the concept of dateTable

Progect in Git Hub: https://github.com/Slizzardd/nix_10/tree/master/hw_9_web_jpa

Error:

As part of learning r2DBC i have come across an issue facing with Enum conversion. I am using PostgreSQL here. When reading data for Film where rating is PG-13 and NC-17( anything with dash ) i am facing issues.

Below is my schema for table

I have checked many examples but they are generally about marking the classes with @Repository or @Service etc...For example here it is about the packages to scan and I am not sure where and in which method I should make scan.

I have a simple application and a User model, UserRepository extending JPA repository and a service. When I try to connect db it is ok by default settings but whenever I want to use custom configuration then the program cannot find the UserRepository class even if I mark it as @Repository. The program still needs repository class configuration bean.

Here is my service method:

We have several systems, using same core libraries and same Oracle DB. But just one system get some error every day, below is a stacktrace.

The error is: ORA-04042: procedure, function, package, or package body does not exist. The difference between this system and others is, that this system uses several datasources, below you can see the Hikari config, part of build.gradle and stacktrace. All other system uses one datasource.

This is Oracle version info:

I would like to have a spring cloud stream listener handling a fulle transaction regarding all messages sent in it. Or, all message sent manually with StreamBridge in the function are commited even if there is an exception after.

This is my lib versions :

In my code the service method savePerson is annotated with @Transactional. Inside this method a Person entity is persisted and inmediately a Runtime exception is intentionally throwed. I suposse the transaction should not be commited but the Person entity is persisted in database....rollback is not working and I dont know why.

This is my Hibernate Configuration: