java.sql.sqlexception column not found

Question

I am trying to find max no from tr_id (primary key) in transaction table.
Here is the table and it's layout.
enter image description here

enter image description here

Here is my cord.

             try {
                ResultSet rs = db.getData("SELECT MAX(tr_id) FROM transaction");
                ResultSetMetaData meta = rs.getMetaData();
                for (int index = 1; index <= meta.getColumnCount(); index++) {
                    System.out.println("Column " + index + " is named " +    meta.getColumnName(index));
                }
                if (rs.first()) {
                    int tr_id = rs.getInt("tr_id");
               }

I'm using JDBC connection. When I'm running this cord I'm getting this error.

        Column 1 is named MAX(tr_id)
        java.sql.SQLException: Column 'tr_id' not found.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
    at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:955)
    at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2570)
    at Controler.InvoiceFinalising.saveInvoice(InvoiceFinalising.java:57)
  etc..

The thing is when I'm searching out as "tr_id" column name goes to Max(tr_id)

Sanjeev · Accepted Answer · 2014-02-06 07:52:01Z

4

This is because the column name in your sql query is max(tr_id). You can write it as

ResultSet rs = db.getData("SELECT MAX(tr_id) as tr_id FROM transaction");

now you will be able to get it.

answered Feb 6, 2014 at 7:52

Sanjeev

9,9762 gold badges24 silver badges33 bronze badges

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

1 Comment

Dilini Over a year ago

is that like this? db.putData("INSERT INTO invoice (inid,itid, cuid, itname, qty, sprice, total, isdate, redate,tr_id) VALUES ('" + txtInvoiceID.getText() + "','" + itemid + "', '" + txtCuID.getText() + "', '" + name + "','" + qty + "', '" + up + "', '" + total + "', '" + date1.trim() + "', '" + date2.trim() + "', '" + rs.getInt("tr_id") + "') "); now I'm getting tr_id not found error again. :(

Collectives™ on Stack Overflow

java.sql.sqlexception column not found

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related