using rs.next() instead of rs.first() to get the first record

Appdynamics / SQLMonitor

SQL-monitoring-extension is a monitor which puts arbitrary queries against a SQL database as metrics

Apache License 2.0

3 stars 9 forks source link

using rs.next() instead of rs.first() to get the first record #1

Open jjschlesinger opened 10 years ago

jjschlesinger commented 10 years ago

When using the MS Sql Server jdbc driver, an exception is thrown when first() is called stating "The requested operation is not supported on forward only result sets.". Changing this to rs.next() makes the sqlserver driver happy and accomplishes the same thing as first().