Top "Resultset" questions

java resultset.getstring("col_name") query

I have a simple query regarding ResultSet.getString() method in java for JDBC. Suppose the value in the Database column …

java escaping resultset getstring

The statement did not return a result set. Java Error

I am trying to delete data from a table from java using JDBC. First I am counting the no of …

java jdbc resultset truncate

Getting the JDBC column types

I need to ask about my column jdbc type in a table, today I am looping throw my columns and …

java jdbc resultset

Retrieving Multiple Result sets with stored procedure in php/mysqli

I have a stored procedure that has multiple result sets. How do I advance to the 2nd result set in …

php stored-procedures mysqli resultset

SSIS Result set, Foreachloop and Variable

I'm having an issue and I don't know if this is possible to do. I have a simple SQL task. …

sql variables ssis resultset foreach-loop-container

Using Resultset in Java Program

Resultset rs=stmt.executeQuery("select count(*) from feedsca group by score order by score"); Using the above java code above, …

java jdbc resultset

JDBC ResultSet getDate losing precision

I am losing precision in my ResultSet.getDate(x) calls. Basically: rs = ps.executeQuery(); rs.getDate("MODIFIED"); is returning dates …

java oracle date jdbc resultset

How to mock jdbc connection and resultSet using Mockito in TestNG

I have to write some unit tests but I have problem with mocking ResultSet and jdbc Connection. I have this …

java unit-testing jdbc mockito resultset

C# SQLServer retrieving results and place in a .csv format

I had a look on the site and on Google, but I couldn't seem to find a good solution to …

c# sql sql-server client-server resultset

Behaviour of ResultSet.TYPE_SCROLL_SENSITIVE

I am confused about the behaviour of a ResultSet that is of type TYPE_SCROLL_SENSITIVE. My understanding of this …

java jdbc resultset