Questions tagged as 'jdbc'

Tagged questions
1
answer

Webservice delete error [closed]

I have a problem with my webservice. You are giving this error:    RequestFailed RequestFailed - > Status: (405) The code I'm using: @DELETE @Produces("text/plain") @Path("ExcluirLista/{usuario}") public boolean excluirTodos(@PathPar...
asked by 27.09.2017 / 15:52
1
answer

Error to popular jtable with database

I have to make a client registration application in JAVA, I'm using eclipse. The problem is in the listarCli() method, because when I comment on this method the error does not appear. The error is: "java.lang.NullPointerException" Acco...
asked by 15.09.2017 / 18:31
2
answers

Find out which column would be truncated (data would be truncated)

Good evening! When I try to insert a record in SQLServer through my application I am getting a truncated data message. The problem is that there are many columns that this screen fills and I have no idea which one is being truncated. Is there an...
asked by 02.05.2017 / 23:13
1
answer

Error with Mysql insert with JDBC

I'm running this code: /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package br.com.caelum.jdbc; import...
asked by 12.04.2017 / 21:20
1
answer

After the validation method is true, how to cancel the sending of the data to the bank?

I have the application already done. The class Produto , ProdutoDAO and a validaProdutoPorDescricao() method JButton btnCadastrarProduto = new JButton("Cadastrar"); btnCadastrarProduto.addActionListener(new ActionLi...
asked by 14.03.2017 / 01:29
1
answer

Select count Java

I want to make a select with the count function and bring all the records of a table, but when displaying the amount in the textfield, it displays a different result. I'll put the code for you to analyze: Error Displayed MycodepublicvoidT...
asked by 15.04.2017 / 03:46
1
answer

How to limit a JDBC connection to only doing "select" queries?

I would like my JDBC connection to not make queries that can make changes to the tables (insert, delete, update, drop). Is there any way to do this?     
asked by 17.02.2017 / 19:56
1
answer

Improving Login Logic - JDBC - JavaWeb

I'm developing the login method of an application, but I've been noticing that the query I'm running to check if a user is registered to the system and if his password hits the bank's data is very slow. I'm using Select * FROM cadastrados...
asked by 02.12.2016 / 03:27
1
answer

Problem with inserting TIMER into MySQL table using JDBC

Speak up! I have the following problem and I'm looking for the best possible solution. The following code when running a time is saved in the CurrentTime (current time) and sent to the database for the time column. This current time is update...
asked by 15.08.2016 / 01:21
1
answer

JDBC connection to the AZURE server with SSL encryption

I'm having trouble connecting via JDBC to AZURE's SQLServer database using encryption. My connection string is as follows: jdbc:sqlserver://servidor.database.windows.net:1433; Database=BASE_DE_DADOS; User=Usuario@servidor; password=senha; T...
asked by 01.07.2016 / 20:50