Posts by alexjosesilva • 3,119 points
279 posts
-
1
votes1
answer881
viewsA: Set auto-increment in Dbeaver
I chose to create Quence for the colunda INSERT into pagamentocielo values (nextval('idpagamentocielo_seq'),'txtxtxt'); You solved my problem
-
-1
votes1
answer881
viewsQ: Set auto-increment in Dbeaver
After creating the column idpagamentoCielo as a primary key, I could not add property auto-increment to the column. How can I assign the property auto-increment to the column idpagamentoCielo? Note:…
-
-2
votes1
answer585
viewsQ: Accent error in Python 2.7
During coding (below) there is an error regarding the accentuation of some words: Note: I am using Notepad++ and running python 2.7 on windows cmd Code: # encoding: utf-8 import os, sys print…
-
-2
votes1
answer735
viewsQ: Selenium Webdriver error accentuation
I am using Selenium Webdriver to realign test with python when running this line: mov.find_elements_by_xpath("td")[3].text.encode('utf-8') I have as answer: {'descricao': 'PROTOCOLIZADA…
-
-4
votes1
answer2376
viewsQ: Selenium.common.exceptions.Nosuchelementexception: Message: Unable to locate element: {"method":"id","selector":"//input[contains(@id,
When using the code: self.browser.find_element_by_id("//input[contains(@id,'seq')]") I get the error message: selenium.common.exceptions.NoSuchElementException: Message: Unable to locate element:…
-
0
votes1
answer337
viewsQ: How to submit via java post?
In a system all data is exposed via URL due to the sending method GET. I need to send via POST. Code: <!DOCTYPE html> <html> <head> <meta charset="ISO-8859-1">…
-
0
votes1
answer50
viewsA: Error while running Servlet
Missing to generate web.xml. <?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee"…
-
-2
votes1
answer50
viewsQ: Error while running Servlet
While running my project. I received an error message. Tomcant is running and I have a contact class and a contact server. Code contact package com.dev; import java.util.Date; public class Contato {…
-
0
votes1
answer221
viewsA: Error: package not imported in eclipse
Corrected tapeworm: import javax.ws.rs.GET; //import from jersey library import javax.ws.rs.Path; //import from jersey library import javax.ws.rs.Produces; //import from jersey library…
-
1
votes1
answer179
viewsA: Cielo Api: Error creating a purchase
The error is in the sending type Can’t be Text has to set Json…
-
-4
votes1
answer179
viewsQ: Cielo Api: Error creating a purchase
When I send a request simulating a purchase: URL https://apisandbox.cieloecommerce.cielo.com.br/1/sales Json { "MerchantOrderId":"2014111703", "Customer":{ "Name":"Comprador crédito simples" },…
-
0
votes1
answer118
viewsQ: Type Mismatch: cannot Convert from Unmarshaller to Pool.Unmarshaller
I’m getting this eclipse error message in a Rest project java client code. package cliente; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; import…
-
-1
votes1
answer221
viewsQ: Error: package not imported in eclipse
I’m creating a Rest app in eclipse but am getting an error message when importing classes from jersey. Code import javax.WebServices.rs.GET; //import da biblioteca jersey import…
-
-3
votes1
answer151
viewsQ: Error testing Cielo sandbox
When accessing the urls https://apiquerysandbox.cieloecommerce.cielo.com.br/1/sales/{Paymentid} when replacing Paymentid with a value: 1 (random value) I get this message: "Message": "The requested…
-
0
votes1
answer542
viewsQ: I’m doing an integration with Cielo’s api but I get an error message:
I’m doing an integration with api-Cielo 3.0 but I’m getting an error message: application code package cieloecommerce.sdk.ecommerce; import java.io.IOException; import cieloecommerce.sdk.Merchant;…
-
0
votes1
answer133
viewsA: Error updating package in Gradle project
Be able to configure the build-Radle correctly. Below the configuration that downloaded the correct spring-boot { repositories { mavenCentral() } dependencies {…
-
-2
votes1
answer133
viewsQ: Error updating package in Gradle project
In a Gradle project, there was a need to update build.grade to another format which caused an error: build.Gradle /* * This build file was generated by the Gradle 'init' task. * * This generated…
-
-1
votes2
answers790
viewsQ: Null return for List<String> method
I have a method with return type List<String>, when a query is made I can return a value or nothing: public class Repositorio { @PersistenceContext private EntityManager em; public…
-
0
votes1
answer1014
viewsA: Error when adding FOREIGN KEY in already created table
The solution developed together with the help of @Rovannlinhalis Backup tables to be changed product manufactures for product fabrica_bk Delete data from tables product manufactures run the sql…
-
-2
votes1
answer1014
viewsQ: Error when adding FOREIGN KEY in already created table
I have a table that I need to change to have a foreign key ALTER TABLE bancocliente.product ADD CONSTRAINT fk_fabPro FOREIGN KEY (cod_fab) REFERENCES bancocliente.fabrica (code); I get the error…
-
-1
votes2
answers22
viewsQ: New procedure is not displayed in SQLSERVER
Follow the steps in doc in microsoft: https://docs.microsoft.com/pt-br/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-2017#SSMSProcedure I changed the…
-
0
votes1
answer51
viewsQ: Error creating Diagrams in Sqlserver Studio 2014
This week I had a problem creating diagrams in my database ( SQL Server 2014), it returned me an error message: Database Diagram support Objects cannot be installed because this database does not…
-
1
votes1
answer3357
viewsQ: What is the number of decimal places of type NUMBER(12,2)?
How to know the number of decimals for type NUMBER(12, 2) in an Oracle database ? V_FATURA NUMBER(12, 2)
-
0
votes1
answer61
viewsA: How to pass schema by paramentro in PLSQL?
I managed to pass the schema using an artificial inside the PLSQL. create or replace FUNCTION hospitalTeste124(MatriculaMedico in number, nomeSchema in varchar2 ) return varchar is retorno…
-
2
votes1
answer61
viewsQ: How to pass schema by paramentro in PLSQL?
I have a function that receives a varchar2 value with the Schema name to save the data in the database but in the schema. create or replace FUNCTION hospitalTeste123(MatriculaMedico in number,…
-
0
votes1
answer436
viewsQ: PLSQL shows error: PLS-00487: Invalid reference to Variabel
I have a PLSQL code: in which I receive two values one numerical and another varchar. Code: create or replace FUNCTION hospitalTeste123(MatriculaMedico in number, nomeSchema in varchar2 ) return…
-
0
votes1
answer156
viewsA: How to create a Registry vector in PLSQL
After reading the oracle PLSQL documentation: TYPE TcAtendimento IS VARRAY(10) OF trec;
-
0
votes1
answer156
viewsQ: How to create a Registry vector in PLSQL
I have a record of TYPE trec IS RECORD ( cd_multi_empresa NUMBER(8,2), tp_atendimento CHAR(2) ); vcAtendimento trec; I need a registry vector, I used this and command: TYPE TcAtendimento IS…
-
0
votes1
answer1184
viewsQ: PLSQL resume error while retrieving data from Database
I try to extract data from the database and insert it into a record and then show it in the cmd, But when I get a higher registration number the procedure requires an error message. Code: SET…
-
0
votes1
answer1331
viewsA: Spoon.bat does not work with windows 7 and java 1.8
Being able to solve this problem in ketller by creating a PENTAHO_JAVA_HOME variable in the system path and pointing to the JRE. After this simple setup can make the Kettler run.
-
0
votes2
answers2434
viewsQ: How can I kill a process as a windows admin user?
I’ve got the 8080 door being used for a mysterious process. I used the command taskkill -f -im 2412 And I get the message: ERROR: process with PID 2412 could not be finished. Reason: Access denied.…
cmdasked alexjosesilva 3,119 -
0
votes1
answer252
viewsQ: SQL returning error when selecting non-existent field
It has a system that several companies use, but changes in bank tables are not informed. You could create a select that does not return an error by not finding a field recently removed from a table?…
-
2
votes1
answer43
viewsA: Error accessing RDS database with Heidsql
The answer I got in this post: https://stackoverflow.com/questions/37212945/aws-cant-connect-to-rds-database-from-my-machine I will translate here: 1 - Go to EC2 Dashboard 2 - Click on Security…
-
0
votes1
answer43
viewsQ: Error accessing RDS database with Heidsql
I get an error message when entering the Amazon RDS database: The access data is correct and the seat is spinning. Is there any procedure to be done to access the RSD database in Heidsql ??…
-
-2
votes1
answer1331
viewsQ: Spoon.bat does not work with windows 7 and java 1.8
After unzipping the Pentaho PDI. I try to run Spoon.bat and get this message below and do not open the IDE I’m using java 1.8 and windows 7 64bit Error message: DEBUG: Using JAVA_HOME DEBUG:…
-
0
votes0
answers25
viewsQ: Error while modelling XSD
From this XML code, I have the XSD block: Code <?xml version="1.0" encoding="UTF-8"?> <schema xmlns="http://www.w3.org/2001/XMLSchema"…
-
1
votes0
answers508
viewsQ: How to mount an XSD from the wsdl query?
Objective: to assemble the XSD in blocks in the eclipse of the consultation to the webservice below: https://valadares.sigiss.com.br/valadares/ws/sigiss_ws.php?wsdl XML is generated: <definitions…
-
2
votes1
answer32
viewsQ: How to convert XSLT to XSD?
There are two files one xslt and I need an xsd. it is possible to convert/transform xslt to xsd ?
-
1
votes1
answer121
viewsQ: Heroku login error on Windows cmd
I try to access the services of Heroku by cmd, but I receive this message: C:\Users\xxx.xxx.xxx λ heroku login ! EPERM: EPERM: operation not permitted, open 'C:\Program Files (x86)\GNU\SSH\_netrc'…
-
0
votes0
answers116
viewsQ: Invalid credentials provided
When creating an app on Heroku, I received this message C:\Users\alex.jose.silva\Documents\demo2 (master -> origin) λ heroku create appSpring1 Creating ⬢ appSpring1... ! ! Invalid credentials…
-
0
votes2
answers100
viewsQ: Error missing commit in git
I made a mistake typing a command into git: **git commit -m startup* I got that message, but I don’t know what it means. C:\Users\alex.jose.silva\Documents\demo2 (master -> origin) λ git commit…
-
0
votes2
answers9821
viewsQ: Select to display the column name of a table?
Tables col1| col2| col3| ...| coln 1 | 2 | 3 | ...| n Display the name : col1 col2 col3 ... coln…
-
0
votes1
answer211
viewsA: Check whether a string is null or empty in XSLT
Problem solving: <CNPJ> <xsl:if test="cnpjContratado != NULL"> <xsl:value-of select="cnpjContratado"/> </xsl:if> </CNPJ> <CPF> <xsl:if test="cpfContratado !=…
-
0
votes1
answer211
viewsQ: Check whether a string is null or empty in XSLT
I have this snippet of XML code and I need to check this blank: <CNPJ> <xsl:if "cnpjContratado"!=NULL> <xsl:value-of select="cnpjContratado"/> </xsl:if> </CNPJ>…
-
0
votes1
answer407
viewsA: Error generating PLSQL file on oracle!
The solution to the problem was line code: Cursor cur_arq is Select f.NOME linha from tfuncionario f
-
0
votes1
answer407
viewsQ: Error generating PLSQL file on oracle!
Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME from tfuncionario f; BEGIN -- Diretorio do Arquivo Dir_Arq…
-
1
votes2
answers358
viewsA: Trigger to Retrieve Last Record Inserted in PL-SQL Table
I managed to run Rigger with this code snippet: CREATE OR REPLACE TRIGGER INSERTFUNCIONARIO BEFORE INSERT ON tfuncionario FOR EACH ROW BEGIN INSERT INTO tPlanoSaude…
-
0
votes2
answers358
viewsQ: Trigger to Retrieve Last Record Inserted in PL-SQL Table
I have a Rigger that after being inserted a new user in the table tFunctioning I must fill another table tPlanoSaude with the data of the employee. employee table table Health Plan Code of the…
-
0
votes3
answers381
viewsA: How to select the year in PLSQL?
can count the years, but I could not limit to one year the date to be displayed: SELECT trunc((months_between(sysdate, to_date(f.ANOADMISSAO,'dd/mm/yy')))/12) AS idade FROM tfuncionario f The query…
-
0
votes3
answers381
viewsQ: How to select the year in PLSQL?
I have a chart of company employees. Must show who completed a year of work at the company. The data type for the field Information: DATE (dd/mm/YY)…