java.sql.SQLException: Before start of result set [duplicate]

by

You must call rs.next() (and check that it returns true) to access the first row of the result set:

if (rs.next() {
    InputStream stream = rs.getBinaryStream(1);
    ...

Also not that the index should be 1, since your query only selects one column.

I also don’t understand the point in casting the int to a char. The method takes an int as argument. A cast to byte would at least be logical, but bytes and char are not the same thing in Java.

More Related Contents:

  1. Retrieve an Image stored as BLOB on a MYSQL DB
  2. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  3. Hours and seconds are lost when storing a date in the database [closed]
  4. Multiple queries executed in java in single statement
  5. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  6. Java: Insert multiple rows into MySQL with PreparedStatement
  7. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  8. MySQL and JDBC with rewriteBatchedStatements=true
  9. Closing JDBC Connections in Pool
  10. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  11. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  12. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  13. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  14. Returning a ResultSet
  15. How to change MySQL timezone in a database connection using Java?
  16. How to configure Tomcat to connect with MySQL
  17. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  18. How I save and retrieve an image on my server in a java webapp [duplicate]
  19. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  20. mysql prepared statement error: MySQLSyntaxErrorException
  21. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  22. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  23. How to correctly write UTF-8 strings into MySQL through JDBC interface
  24. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  25. How to use prepared statement for select query in Java?
  26. Stumped SQL Exception for JDBC
  27. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  28. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  29. java.sql.SQLException: No database selected – why?
  30. JDBC MySQL connection using Unix Socket

Leave a Comment