Get Timestamp from Sqlserver

Question

I really wanted to get the TimeStamp from the Sqlserver database, but I’m not getting it, follow my example:

Connection connUpdate = DriverManager.getConnection(ConnectionURL);
PreparedStatement atualizaDevice = connUpdate.prepareStatement("select current_timestamp");
atualizaDevice.execute();
ResultSet r = atualizaDevice.getResultSet();
Timestamp t = r.getTimestamp(1);
String time = String.valueOf(t);
txtTime.setText(time);
Log.e("TIME", time);
connUpdate.close();

Using this code returns the following error:

java.sql.Sqlexception: No Current Row in the Resultset.

Any idea what to do?

Answer 1

You have to select the database row, the way you are doing is not selecting. From a read in this article: https://andrielleazevedo.wordpress.com/2011/06/06/usando-o-comando-select-no-sql-server/ The returned Excption is coming directly from the lack of line selection