[sqlite] JDBC stmnt.executeQuery returns empty ResultSet

[Tommy Lane]

All,
        Hope you Easter is going well.

        I am working on a simple journaling application which I'm
choosing to write in Java. Before I get into this description if this is
not the place to ask for help with the sqlite wrapper
(https://bitbucket.org/xerial/sqlite-jdbc/downloads/) please let me
know, although I won't need a plethora of replies to that effect.

        When I execute a chunk of code:
ResultSet getTitles() {
           ResultSet ret = null;

           try (PreparedStatement stmnt = 
sqlConnection.prepareStatement("SELECT * FROM entries")) {
                  ret = stmnt.executeQuery();

           } catch (SQLException ex) {
                  System.out.println("Unable to get entries from the entry 
database.");
                  System.out.println(ex.getMessage());
                  ex.printStackTrace();
           }


           return (ret);
    }

my rs contains no results.

I've verified that the database which sqlConnection has open does indeed contain
data.

ANY help would be greatly appreciated,
-Tommy <km4...@km4lvw.com>

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users