ResultSet: Exception: set type is TYPE_FORWARD_ONLY — why?

by

Change your first statement to this

pstat=con.prepareStatement("select typeid from users where username=? and password=?",
                            ResultSet.TYPE_SCROLL_SENSITIVE, 
                        ResultSet.CONCUR_UPDATABLE);

This way you can move forward and backward, so less things to worry about

More Related Contents:

  1. How do I get the size of a java.sql.ResultSet?
  2. Most efficient conversion of ResultSet to JSON?
  3. JDBC ResultSet get columns with table alias
  4. Hours and seconds are lost when storing a date in the database [closed]
  5. Multiple queries executed in java in single statement
  6. How to convert java.util.Date to java.sql.Date?
  7. Dates with no time or timezone component in Java/MySQL
  8. Efficient way to do batch INSERTS with JDBC
  9. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  10. How does a PreparedStatement avoid or prevent SQL injection?
  11. Using Prepared Statements to set Table Name
  12. How to use a tablename variable for a java prepared statement insert [duplicate]
  13. SQLite in Android How to update a specific row
  14. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  15. java.sql.SQLException: Exhausted Resultset
  16. Postgres data type cast
  17. How to enable logging for SQL statements when using JDBC
  18. Cleanest way to build an SQL string in Java
  19. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  20. The most sophisticated way for creating comma-separated Strings from a Collection/Array/List?
  21. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  22. Spring JPA @Query with LIKE
  23. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  24. JPA Native Query select and cast object
  25. How to get the number of columns from a JDBC ResultSet?
  26. How to do in-query in jDBI?
  27. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  28. Java JDBC connection status
  29. MyBatis executing multiple sql statements in one go, is that possible?
  30. java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path

Leave a Comment