I have to query a MS SQL DB using java

Question

I have to query a MS SQL DB using java. I am querying DB using following code

         Class.forName("net.sourceforge.jtds.jdbc.Driver");
         Connection conn = DriverManager.getConnection(
                 "jdbc:jtds:sqlserver://XXX.XX.XX>XX:1433/DBNAME", "USERNAME", "Password");

         querystr="select DATEDIFF(second,Finish_Time,ReqTime) As FinishDifference from DB.SCHEMA.TABLE where ID='123'";
         Statement stmt=conn.createStatement();
         ResultSet res=stmt.executeQuery(querystr);
         System.out.print(res.getRow());

When I query DB manually using query string, I am able to successfully gets results but res.getRow() shows 0.

juergen d · Accepted Answer · 2012-06-27 10:40:59Z

1

you forgot to include next() to fetch the first record:

ResultSet res=stmt.executeQuery(querystr);
if(res.next()) // add this line
    System.out.print(res.getRow());

answered Jun 27, 2012 at 10:40

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

Comments

Rais Alam · Accepted Answer · 2012-06-27 11:23:43Z

0

Initially ResultSet returns current cursor position.

ResultSet res=stmt.executeQuery(querystr);
res.getRow();// It will return 0 (Zero) because result set is pointing to begining of the first record

res object is pointing to 0th position of table in your DB. When you iterate with the help of res.next();

It will move to next record and now if you call

 res.getRow();// It will return 1 because cursor is moved to 1st record of table.

Try this.

while(res.next())
{
         System.out.println(res.getRow());
}

It will print the All rows number one by one.

answered Jun 27, 2012 at 11:23

Rais Alam

7,02613 gold badges56 silver badges84 bronze badges

1 Comment

user1472300 Over a year ago

Thanks. yes, I forget to add res.next

juergen d · Accepted Answer · 2012-06-27 14:38:49Z

0

The getRow() method gives the row number of current row. The first row is number 1, the second number 2, and so on.

and gives the current row number as 0 if there is no current row which is your case.

http://docs.oracle.com/javase/1.4.2/docs/api/java/sql/ResultSet.html#getRow()

edited Jun 27, 2012 at 14:38

juergen d

205k40 gold badges303 silver badges377 bronze badges

answered Jun 27, 2012 at 10:44

user980089

3741 gold badge3 silver badges11 bronze badges

2 Comments

user980089 Over a year ago

@juergend yeah he tried the query manually on MS SQL. But in no way he can use getRow() in SQL String. The query is fine and data is fetched but because of using getRow() wongly in java he got unexpected result.

user1472300 Over a year ago

getrow was just used to find rowcount. Query returns no result. I am getting exception "No current row in the ResultSet" when try to access resultset

Collectives™ on Stack Overflow

I have to query a MS SQL DB using java

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related