Top "Resultset" questions

Convert a Result Set from SQL Array to Array of Strings

I am querying the information_schema.columns table in my PostgreSQL database. Using a table name, the result set finds …

java arrays postgresql jdbc resultset

ResultSet: Exception: set type is TYPE_FORWARD_ONLY -- why?

I have very simple code: pstat=con.prepareStatement("select typeid from users where username=? and password=?"); pstat.setString(1, username); pstat.…

java sql resultset jdbc-odbc

Bulk insert in Java using prepared statements batch update

I am trying to fill a resultSet in Java with about 50,000 rows of 10 columns and then inserting them into another …

java resultset bulkinsert prepared-statement

JDBC returning empty result set

I'm using JDBC for very simple database connectivity. I have created my connection/statement and executed a query. I check …

java sql oracle jdbc resultset

Oracle doesn't remove cursors after closing result set

Note: we reuse single connection. ************************************************ public Connection connection() { try { if ((connection == null) || (connection.isClosed())) { if (connection!=null) log.severe("Connection …

java oracle jdbc cursor resultset

Storing Result set into an array

i know this should be simpel and im probably staring straight at the problem but once again im stuck and …

java sql jdbc resultset

How can I determine if the column name exist in the ResultSet?

As the ResultSet contains the data returned from the dynamic SQL, if there are any method to determine if the …

java jdbc resultset

ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position

When I run the following servlet: // package projectcodes; public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { String UserID = …

java jdbc resultset sqlexception

Convert Resultset to String array

I need to Convert My result set to an array of Strings. I am reading Email addresses from the database …

java arrays oracle11g resultset

How do you get values from all columns using ResultSet.getBinaryStream() in jdbc?

How do I to write an entire table to a flat file (text file) using jdbc? So far I've attempted …

java sql jdbc db2 resultset