Not valid column name

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Im using SQL server and Netbeans and it gave me this error:

com.microsoft.sqlserver.jdbc.SQLServerException: The column name Max(CarNumber) is not valid.

from :

Java

Statement s = con.createStatement();
           
      ResultSet rs = s.executeQuery("select Max(CarNumber) from CarRegistration");
            rs.next();
            rs.getString("Max(CarNumber)");

            if (rs.getString("Max(CarNumber)")== null) 
            {
                txtregno.setText("C0001");
            } 
            else 
            {
              long id = Long.parseLong(rs.getString("Max(CarNumber)").substring(2,rs.getString("Max(CarNumber)").length()));
               id++;
             txtregno.setText("C0" + String.format("%03d", id));
            }

What I have tried:

I tried everything still getting the error. is anything wrong with the syntax?

Posted 8-Jan-20 7:24am

Kurt Jimenez

Updated 8-Jan-20 8:07am

RickZeeland

v2

Add a Solution

Comments

Kris Lantz 8-Jan-20 13:35pm

Does the column "CarNumber" exist in the DB?

Kurt Jimenez 8-Jan-20 13:40pm

yes, im using microsoft sql server

2 solutions

Solution 2

That's probably because it is not a string value, try something like this:

int max = rs.getInt(1);

I'm not a Java programmer, so the syntax might not be correct :)

Posted 8-Jan-20 8:07am

RickZeeland

Updated 8-Jan-20 8:08am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2020-01-08T07:56:00

Solution 1

Since you're using an aggregate you need to give an alias to the column if you want to reference it by name. For example

Statement s = con.createStatement();

ResultSet rs = s.executeQuery("select Max(CarNumber) AS MaxCarNo from CarRegistration");
rs.next();
rs.getString("MaxCarNo");

if (rs.getString("MaxCarNo")== null) {
...

Posted 8-Jan-20 7:56am

Wendelius

Comments

Kris Lantz 8-Jan-20 13:58pm

Beat me to it. Take my stars...

Wendelius 8-Jan-20 23:14pm

Thank you.

Kurt Jimenez 8-Jan-20 14:12pm

Yeah you're right bruhhh. Thank you :) and God bless you O:) you saved my day...

Wendelius 8-Jan-20 23:14pm

Glad to be of service :)