Posts by lbtn • 38 points
7 posts
-
1
votes2
answers192
viewsA: How to make the findById method in spring-boot?
João, the method in the controller is returning void, when it should return an Optional Client. That adjustment should solve your problem.…
-
1
votes1
answer124
viewsA: How to run a select on Pentaho
1 - Insert a STEP Table Input As an example below: 2 - Edit STEP Table Input In this step we need to configure the database (it is also important to test connectivity). The configuration of the bank…
-
0
votes2
answers20
viewsA: How to recover object by URI by passing parameter and showing Request Status
Dayson, see if this format helps you: if (categoria == null) { return new ResponseEntity(HttpStatus.NOT_FOUND); } return new ResponseEntity(categoria, headers, HttpStatus.OK);…
-
-3
votes1
answer57
viewsA: where do I use left Join in this case? no msql
Diego, understanding that you need to perform a left Join between Artist A and Music M (which makes sense to me from the point of view of sets): select a.nome_artista, count(*) as numero_musicas…
-
-1
votes2
answers64
viewsA: Select returning null values in the database
Leonardo, try as below: SELECT S.ID_SALES, S.ID_CLIENT, C.FULL_NAME, S.SDATE, coalesce(S.billed, 'N') BILLED, P.product_description product, I.amount, I.unit_cost, I.unit_cost * I.amount SUBTOTAL,…
-
1
votes1
answer63
viewsA: What are the advantages and disadvantages of using Auto Increment Field in Firebird?
In Firebird >= 3 an identity field is a column associated with the internal sequence generator. The value is set automatically, provided that the column is omitted in the INSERT. That is, a lot…
-
0
votes1
answer42
viewsA: Postgresql - Foreign Key after import
I have worked with Firebird and Postgres for some time, and the basis of my work is to perform data extraction from Firebird databases, transform them and insert into Postgres bases. About your…