Questions tagged as 'jdbc'

Tagged questions
3
answers

SQL query with String data

Hello, I have a query SQL implemented in JAVA in which I need to insert the values MTILM, MVisual, MVerba, MAR, MTeorico whose data is of type String, here I leave an example connectionDB.executeInsertUpdate("INSERT INTO 'data_process...
asked by 01.06.2017 / 21:37
2
answers

problem when updating data from a java table after inserting, No operations allowed after connection closed.?

I have a class where I insert data in the db then I update the table but this error appears to me No operations allowed after connection closed. Here I leave the class connection and the class where I insert. //===============clase conexion===...
asked by 08.02.2017 / 22:59
1
answer

Java 7 connection to Sql Server 2014

I am trying to connect with java 7 to sql server 2014 and I get the following error:    The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete...
asked by 01.11.2016 / 16:52
1
answer

Do you not upload the data from my database to my jsp?

The database is locally I understand that it is placed the libraries are already placed from jdbc and the jar of mysql but does not pull the data     
asked by 14.12.2016 / 18:31
1
answer

Error between java - jdbc oralce, resultset null

Currently I have a code that executes a query to a database in oracle which returns about 200,000 results and then I run the resultset to build a csv. The problem I have is that sometimes, some values of a column of the resultset reach nul...
asked by 09.04.2018 / 17:28
1
answer

NoHostAvailableException in Cassandra

I need to make a presentation + connection to Cassandra for class. The fact is that it does not let me connect when I use the datastax drivers. I have gone a thousand times because apparently there are old versions that are incompatible and well...
asked by 17.11.2017 / 17:48
1
answer

No suitable driver found for jdbc: mysql

To which other drivers are referenced or that I am not loading as I am loaded correctly, since if I do it for a main function this loads correctly     
asked by 11.11.2017 / 01:39
2
answers

SQL statement to get the ID of a given entity a name

In SQL, I have a table called COMPANIAS with id_compania and nombre . Given the name, in a variable, I want to find the id_compania that has exactly that name. Method to obtain the ID: public int companiaNombre...
asked by 12.11.2017 / 00:24
1
answer

Where and how the error in this line of SQL and Java is corrected

PreparedStatement pps = cn.prepareStatement("UPDATE tb_producto SET cantidad='"+txtcantidad.getText()+"' WHERE nombre='"+txtbuscar.getText()+"'"); Where is the error and how to solve help please!     
asked by 23.10.2017 / 02:04
1
answer

Doubt with servlets of java and sql [closed]

In this small servlet I am entering the values in hard and I would like the hard values to have parameters so that the information can be stored since it would be on the client's side where this information is entered. protected void doGet(Htt...
asked by 16.08.2017 / 00:27