I'm trying to create a Java application where I need to set up two databases: MongoDB and MySQL. My idea is to use Spring-Data with Hibernate for both banks, but I found only tutorials for setting up Cross-Store between the banks.
Is there an...
Hello,
I'm starting my study in SpringBoot, where I arrived in a part that I could not solve due to an exception, where I already saw in several topics how to solve, and none worked for me.
I created two Person and Cell entities and did th...
I'm trying to set up a sample project using Spring Data JPA with Hsqldb
I made the person class that would be model , the interface repository and a main class to run.
I did not create the database because I have a question if...
I have the following query:
SELECT tab1.nom_shopping,
tab1.nom_fantasia,
tab1.luc,
tab1.dat_vencimento,
tab1.num_boleto,
tab1.val_saldo_aberto,
tab2.num_cpfcnpj negativado,
tab2.id_pessoa_vinculo_loja [IdPessoa],...
I'm having problems in the oneToMany relationship of two entities using Jpa Hibernate.
I have two tables, one cancellation and another that has the orders that are part of the cancellation.
The cancellation table has a simple primary key (idc...
Searching on how to filter the records with the repository, I found the annotations:
@PreAuthorize
@PreFilter
@PostFilter
You have 2 Roles in the system: ROLE_ADMIN and ROLE_USER where ROLE_ADMIN can access all records, ROLE_USER can...
My query was built like this, but when it asks:
@Query(value = "SELECT CT.id FROM CursoTurno AS CT
LEFT JOIN Curso AS C ON C.id = CT.curso_id
INNER JOIN Turno AS T ON T.id = CT.turno_id
WHERE...
I need to call the following procedure below, so the company projects use JPA 2.0 and all the examples I encounter are for JPA 2.1 + .
prc_performance_vendas_obter(vdataini => :vdataini,
vdatafim => :vdatafi...
My application has a connection to a remote database (SQLServer), but I would like to perform a small duplication of certain less volatile data in a local and embedded (H2) database to gain in performance. My setup today is that of a single bank...
Good evening!
Can someone help me with the error in my code, I followed the steps of the teacher but presents error in mine and not in his example. I'm using the same dependencies. Here is the snippet of the method and the error.
public List&l...