Java - Unknown column in 'field list' jdbc error

Question

I've got this error from my jdbc driver. I don't know why, tho.

Here's the corresponding code:

try {
    String colNames = " ";
    for (int i=0; i<cols.size(); i++) {
        if (i == cols.size()-1) {
            colNames += cols.get(i);
        } else if (i<cols.size()) {
            colNames += cols.get(i)+", ";
        }               
    }       
    String colValues = " ";
    for (int i=0; i<values.size(); i++) {
        if (i == values.size()-1) {
            colValues += values.get(i);
        } else if (i<values.size()) {
            colValues += values.get(i) + ", ";
        }       
    }
    System.out.println(
        "INSERT INTO `" + tableName + "` (" + colNames + ") VALUES (" + colValues + ") "
    );
    //System.out.println(kerdojel);

    PreparedStatement pst = connHandler.conn.prepareStatement
        ("INSERT INTO `" + tableName + "` (" + colNames + ") VALUES (" + colValues + ") ");
    pst.executeUpdate();
    pst.close();
}

"values" and "cols" are ArrayLists that contains the data from the JTable. cols are the Column names and values are the cell values.

The output for the Sysout:

INSERT INTO `TableOne` ( nev, kor, lakhely) VALUES ( asd, 1, asd)

The error:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'asd' in 'field list'

use single inverted commas for values. On a side note use setString() etc methods to set the values — singhakash
– singhakash, Commented Mar 26, 2016 at 18:06

Titus · Accepted Answer · 2016-03-26 18:26:07Z

2

That is not how the PreaparedStatement was intended to be used. When you use a PreparedStatement, you can specify the values by using one of the "set" methods.

Here is an example:

String colNames = " ";
String colValues = " ";
for (int i=0; i<cols.size(); i++) {
    if(i!=0){
       colNames += ", ";
       colValues += ", ";
    }
    colNames += cols.get(i);
    colValues += "?";              
}       

try (PreparedStatement pst = connHandler.conn.prepareStatement("INSERT INTO `" + tableName + "` (" + colNames + ") VALUES (" + colValues + ") ");){

    for (int i = 0; i < values.size(); i++) {
        pst.setString(i+1,values.get(i));       
    }

    pst.executeUpdate();
}

You should use the appropriate "set" method based on the column's data type (setInt(...), setDate(...), etc.). You can find more details here

edited Mar 26, 2016 at 18:26

answered Mar 26, 2016 at 18:20

Titus

22.6k1 gold badge26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vrqq · Accepted Answer · 2021-05-21 16:22:15Z

0

Try to use command like these one to check problem existed.

PREPARE mycmd FROM 'INSERT INTO TableOne(nev,kor) VALUES (?, ?)'

edited May 21, 2021 at 16:22

answered May 21, 2021 at 11:12

vrqq

5763 silver badges8 bronze badges

Collectives™ on Stack Overflow

Java - Unknown column in 'field list' jdbc error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related