Posts by Guilherme Oliveira • 332 points
19 posts
-
0
votes2
answers616
viewsA: Rollback() JPA + Hibernate
Use in function @Transactional(propagation = Propagation.REQUIRED, isolation = Isolation.READ_COMMITTED, rollbackFor = java.lang.Exception.class, timeout = DEFAUL_TIMEOUT) public void suaFuncao ()…
-
1
votes1
answer40
viewsA: Error while creating a file
Try to use, it’s a pattern I use when creating files; usar File.separator ex:File dir = new File(caminhoPastaTemp + File.separator + uuid); if(!dir.exists()){ dir.mkdirs(); } //arquivoParametro é o…
-
0
votes2
answers570
viewsA: Optimize Mysql table Insert - Java
By Batch and faster because you don’t keep calling run inside the for in each iteration, but preparedStatement.addBatch(); and after the for: preparedStatement = conn.prepareStatement(comandoSQL);…
-
0
votes1
answer31
viewsQ: back version of woocomerc plugin 3.7.0 for 3.6.5
Hello, Apparently the new version of the woocomerc n API accepts more image registration URL with "?" then my product registration api pro ERP for wordpress sites are not registering images of the…
-
0
votes1
answer1805
viewsQ: SELECT inside a FOR in declare SQL/ORACLE
I need to generate an excel of a table data but I need to do for each my company, so n have to run select changing the company id I thought to do with Procedure but the ones I have and just update…
-
0
votes1
answer1299
viewsA: Procedure in Mysql to clone products, Using CURSOR FOR SELECT
Solution: UPDATE EST_PROD_PRECO_CUSTO_EMPRESA p1 INNER JOIN (SELECT ID_PRODUTO, PRECO_CUSTO, PRECO_CUSTO_FINAL FROM EST_PROD_PRECO_CUSTO_EMPRESA where ID_EMPRESA = X and PRECO_CUSTO>0) x1 ON…
-
-1
votes1
answer1299
viewsQ: Procedure in Mysql to clone products, Using CURSOR FOR SELECT
I need to clone the data from an EST_PROD_PRECO_CUSTO_EMPRESA table of id x company for the same table but of the company with id y. in Pl/Sql I did so. DECLARE CURSOR v_precos IS SELECT ID_PRODUTO,…
-
1
votes2
answers1687
viewsA: PL/SQL Anonymous block | PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following:
HICCUP, see you all DECLARE v_idMax NUMBER(19,0); -- variavel para guardar o ultimo id do banco BEGIN EXECUTE IMMEDIATE 'select max(ID_PROD_PRECO_CUSTO_EMPRESA) from…
-
4
votes2
answers1687
viewsQ: PL/SQL Anonymous block | PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following:
I get the following error : [Err] ORA-06550: line 7, column 2: PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: 'Cause I’m using a create Quence inside my BEGIN with ;…
-
0
votes1
answer640
viewsA: SQL - IN inside a SUB SELECT with NOT IN - ORACLE
[CONCLUSION] Using PL/SQL random_uuid() and a Function of mine that generates UUID values. DECLARE FOR V_FUNC IN (SELECT prod.ID_PRODUTO FROM ERP.EST_PRODUTO prod INNER JOIN…
-
1
votes1
answer640
viewsQ: SQL - IN inside a SUB SELECT with NOT IN - ORACLE
I wanted to make my INSERT dynamic, I don’t need to change the ids manually. I have this script that returns all PRODUCTS that does not have 83 relationship with the EST_PROD_PRECO_CUSTO_EMPRESA…
-
2
votes3
answers100
viewsA: Deployment of GIT
recommend a branch for you to give checkout for each developer or per request.
-
2
votes0
answers362
viewsQ: Received fatal Alert: handshake_failure when class is run by Schedule - JDK7
I have a class that integrates with Woocommerce, when I run the class when I raise the project not httpCliente error ( 4.5.3) I get Httpresponse 200 ok, I have two registered api, 1°…
-
-1
votes1
answer2159
viewsA: Add items dynamically to a list using Thymeleaf
Looking at Hymeleaf’s documentation can do this.I will give the example of my project, This my Entity, I will create dynamic fields of the current listTurno. if all your Repospository, service and…
-
-1
votes1
answer742
viewsQ: How to implement Jasperreports and iReport( or Jaspersoft) in a reporting system?
I have a system with a good part of the ready functionalities registered and all do routes finalized. I will now create a report that the user will make the request of what he wants to generate and…
-
0
votes0
answers951
viewsQ: Use . POST or . DELETE method for request to delete data
I was using . delete but suddenly the method is not being recognized from the error in the console. 2017-04-12 09:51:34.022 WARN 5836 --- [nio-8080-exec-9] o.s.web.servlet.Pagenotfound: Request…
-
8
votes6
answers28831
viewsQ: How to limit an input of type Number to only 3 characters?
I have a problem with a variable of the type integer, for the maxlength="" only works with string and I need to stop, but it’s like Number. I think you need javascript, if anyone knows the solution…
-
0
votes1
answer178
viewsQ: load value in empty front form without starting with 0 [java] Thymeleaf + spring
my Entity is as integer and load n front with value 0, I think it is a simple thing but I do not understand much.…
-
0
votes0
answers175
viewsQ: Saving dynamic data in the same Java identity
I’m using Spring MVC, Thymeleaf and for me with all routes built he did automatic but not this working, Entity, Repository, controller and etc. I have a relation of N=N of course to Turn, of that…