Questions tagged as 'jdbc'

Tagged questions
1
answer

JDBC - Execute a query and use its return as a parameter to another query

I am learning to program in java, alone with the help of tutorials and I am trying to do a procedure where the result of a query will be a where clause for a second query. In the example below, I have a connection that performs a query...
asked by 14.02.2017 / 22:40
2
answers

Error in CRUD command UPDATE - java.sql.SQLException: No value specified for parameter 8

I'm building a Java system with MySQL database connection, but I stopped at some point because I can not find the error. My update method happens an error in JUnit, but I can not figure out what it is. Follows parts of the code: package com...
asked by 17.12.2016 / 20:36
1
answer

JLabel is not displayed

I created a label where it would contain the status of the connection process with the database, but it does not appear and I have no idea why this happens, since I have been looking at the code for three days and I do not know What happens, it...
asked by 28.11.2014 / 22:59
1
answer

How does the process of accessing a database work?

I started to study database and to access a certain database with JDBC you need a driver for each DBMS (MySQL, SQL Server, Oracle), and access is done on disk, but since this process is done? Does DBMS work constantly or only activated when a qu...
asked by 09.08.2017 / 00:57
1
answer

Requestmapping for a large URL

I wanted to know how I @RequestMapping to a large URL. In case I wanted to map the word authenticate. http://localhost:8080/DataIdea/autenticar?email=0fS3w9wOg6WkJB%2BBdvEmlKxQxYOhF8nqt2lPx801R5M%3D I'm trying to use the code below,...
asked by 11.02.2015 / 18:11
3
answers

Return DB data using List / ArrayList - Java

I'm having a problem, I set up a PivotTable in PostgreSQL and I need to print the lines of it, doing a Java method, the start of which is already established. That would be with a simple% w / o having as a parameter the start and end dates. H...
asked by 08.02.2018 / 19:02
1
answer

java.sql.SQLException: Can not issue data manipulation statements with executeQuery ()

My key insertion is not being done. And the error it gives in the console is: java.sql.SQLException: Can not issue data manipulation statements with executeQuery(). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.m...
asked by 18.04.2018 / 22:28
1
answer

"Error: Can not issue data manipulation statements with executeQuery ()" no Select

Doing the method to select all data from a table, however it is returning me error. console: Open bench. java.sql.SQLException: No value specified for parameter 1 No value specified for parameter 1 at com.mysql.jdbc.SQLError.createSQL...
asked by 23.09.2016 / 10:27
1
answer

Return Connection as Boolean?

Would it be possible to modify the class so that it returns the result of the connection as a boolean to jFrame? public class ConectarDB { private static Connection con = null; public static Connection getConexao() { // Driv...
asked by 04.12.2015 / 20:34
1
answer

Put RESTful WS project in production

I'm a beginner in Java and these .jar, .war, etc businesses are new to me. I made my first RESTful Webservice project and added 2 * .jars, Gson and JDBC.postgres. I want to put it into production (on a server that will be Tomcat ) to use it...
asked by 02.10.2014 / 13:28