FreeformQuery returns always empty

Hi everyone!

I’m trying to display a table with all the user that I have saved in my Oracle database, but always I’m getting empty results. I don’t know what is exactly the problem because if I execute of the FreeformQuery (select * FROM USERS) directly by command it returned that I want.

Does not give any error, just returns me an empty table! What is my error? Please help me!


JDBCConnectionPool connectionPool = null;
try {
connectionPool = new SimpleJDBCConnectionPool(“oracle.jdbc.OracleDriver”,
“jdbc:oracle:thin:@localhost:1521:xe”, “user”, “userpass”, 2, 5);
catch (SQLException e) {

    SQLContainer container = null;
    //TableQuery tq = new TableQuery("USERS", connectionPool,new OracleGenerator());
    try {
        container = new SQLContainer(new FreeformQuery("select * FROM USERS" , connectionPool,"USER_ID"));
    } catch (SQLException e) {            
      table_1 = new Table(null, container);


[/code]Thanks in advance!

Hey Pedro,

Have you read through this?

Hi Joacim,

Yes, I tried to follow this tutorial and supposedly my solution should work but it always returns empty…


Hmm, try debugging the code; look what the query returns, and/or whether or not the container “contains” any items?