Questions tagged as 'jdbc'

1
answer

You doubt with a PreparedStatement that executes an UPDATE

I have this PreparedStatement , I would like to know if it is correct, I would also like to know if you have to create a method to do EXECUTE , or in the same method of PreparedStatement of UPDATE . public void Modify(...
asked by 15.08.2017 / 22:33
1
answer

select count (*) from java executeQuery

How can I store the number that returns the select count (*) in a variable? public int contar_num_personajes() throws SQLException{ Connection dbConnection = null ; Statement stm = null; int n= 0; String co...
asked by 16.07.2017 / 23:22
1
answer

Consultation sql java

I'm programming with Java. I am new in this language. What happens is that I insert a table in MySQL, but it appears:    SQLException: Unknown column 'jose' in 'field list' In fact, I printed the SQL and executed it in the PhpAdmin and it...
asked by 31.12.2016 / 04:28
2
answers

I have a problem in java when executing an sql query to show records in a jtable

This problem occurs to me with this method to show data from a bd in java, because it tells me that the query did not generate any results when I saved in my form and I need to save and that immediately I show the record, this code shows it but...
asked by 20.12.2016 / 01:10
1
answer

How to create a JDBC pool connection in glassfish?

Greetings to all, I'm trying to create a jdbc pool connection mysql from glassfish, but at the time of creating it, it sends me the following error I do not know what to do to solve it, I hope you help me     
asked by 10.10.2016 / 03:52
0
answers

Error creating JDBC connection pool (sqlserver microsoft) payara shows error: java.lang.NoSuchFieldError: isEC

I am trying to create connection pool with sqlserver in payara 5 load the driver of sqlserver version 7 in the path \glassfish\domains\domain1\lib\ext but it shows the following error, when creating the datasource by the graphical inter...
asked by 26.12.2018 / 20:14
1
answer

Error must declare the scalar variable @ p3where, in JAVA, when trying to update data from the database using a button

Hello everyone I hope you can support me, I start in this JAVA and make connections with SQL and I am little by little with learning, I hope you can help me I explain I'm doing practice and I started with an agenda, which everything was worki...
asked by 21.12.2018 / 01:50
0
answers

error jdbc mysql driver in dropwizard

This exception is being thrown at me and I do not know what the cause is Could not clean up [statement:"select * from shop_item limit 1;", located:"select * from shop_item limit 1;", rewritten:"/* ShopItemDAO.getItemById */ select * from s...
asked by 04.12.2018 / 20:48
0
answers

ERROR: java.sql.SQLException: Column count does not match value count at row 1

Help! This is my code I need to enter data in Netbeans and that the information entered appears in SQLyog     
asked by 30.11.2018 / 00:53
1
answer

Exception in thread "main" java.lang.NoClassDefFoundError: javax / xml / bind / DatatypeConverter

I'm doing an application on a computer, we're 4 and everyone uses Windows except me (Mac). This application uses a database with MySQL . At the beginning I had JDK 10 , now I have the 1.8 (8) . I have two versions of NetBean...
asked by 13.11.2018 / 19:12