SEVERE: null com.microsoft.sqlserver.jdbc.sqlserverexception: the result set has no current row.

Question

1.00/5 (1 vote)

See more:

SQL-Server-2012

, +

 try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            con = DriverManager.getConnection("jdbc:sqlserver://;databaseName=Rental;user=MyAdmin;password=123456789");
            
            Statement s = con.createStatement();
            
            ResultSet rs = s.executeQuery("SELECT Car_No FROM CarRegistration");
            rs.next();
            rs.getString("Car_No");
            
            if(  rs.getString("Car_No") ==null)
            {
                txtregno.setText("C0001");
            }else
            {
                long id = Long.parseLong(rs.getString("Car_no").substring(2,rs.getString("Car_no").length()));
                
                id++;
                
                  txtregno.setText("C0" + String.format("%03d", id));
            }
            
            
            
            
          } catch (ClassNotFoundException ex) {
            Logger.getLogger(CarRegistration.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(CarRegistration.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

What I have tried:

I want to make Auto increment in "C0001" but it gives me a error No  current row

Posted 19-Jan-20 18:33pm

Kurt Jimenez

Updated 20-Jan-20 0:19am

Add a Solution

2 solutions

Solution 1

Quote:
the result set has no current row.

May be you should check the number of records in result.

Advice: Never calculate a next id by your code because one day or another, 2 users will create a new id at same time anf you will end up with 2 records with same id.
Let the server handle it for you.
SQL AUTO INCREMENT a Field[^]

Posted 19-Jan-20 19:02pm

Patrice T

Comments

Richard Deeming 21-Jan-20 10:15am

There's no need for two users in this case. With no ORDER BY clause in the query, and no loop on the results, the OP is almost certainly always selecting the first car number. Every subsequent record with get the PK "C0002". :)

Patrice T 21-Jan-20 10:23am

Agreed

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)

Richard MacCutchan · Accepted Answer · 2020-01-20T00:19:00

Solution 2

Java

ResultSet rs = s.executeQuery("SELECT Car_No FROM CarRegistration");
rs.next();

You are assuming that the resultset contains some data. You need to check first whether any rows are present.

Posted 20-Jan-20 0:19am

Richard MacCutchan