Hi All,

I made the mapping correct and the query run fine no errors neither and exceptions.

Once i use the sql query that hibernate did generate, it returns rows.

The code i use is normal query, using a session to create a query and then
just query.list(), but always nada.



here is a part from the log :

17406 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
17406 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - HQL: select x.reqId, x.requestType, x.msisdn, x.HLRStatus from com.atos.activdb.model.RequestHistory as x where x.HLRStatus = 7
17406 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - SQL: select requesthis0_.Request_Id as col_0_0_, requesthis0_.Request_Type as col_1_0_, requesthis0_.Msisdn as col_2_0_, requesthis0_.HLR_Status as col_3_0_ from SEMA_ACTIVPLUS_REQUEST requesthis0_ where requesthis0_.HLR_Status=7
17406 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
17406 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17406 [main] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
17406 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
17406 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
17406 [main] DEBUG org.hibernate.SQL - select requesthis0_.Request_Id as col_0_0_, requesthis0_.Request_Type as col_1_0_, requesthis0_.Msisdn as col_2_0_, requesthis0_.HLR_Status as col_3_0_ from SEMA_ACTIVPLUS_REQUEST requesthis0_ where requesthis0_.HLR_Status=7
17406 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
17469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
17469 [main] DEBUG org.hibernate.loader.Loader - processing result set
17469 [main] DEBUG org.hibernate.loader.Loader - done processing result set (0 rows)
17469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
17469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
17484 [main] DEBUG org.hibernate.engine.PersistenceContext - initializing non-lazy collections
17484 [main] DEBUG org.hibernate.jdbc.JDBCContext - after autocommit

What do you mean by "nada"... please provide more info

nada means "Niente, Nothing" or in German: "Nichts, Nix" ;-)

The mapping is correct, everything seems fine.
but no rows returned.

This is the request i use :

public static String getrecycle = "select x.reqId, x.requestType, x.msisdn,
x.HLRStatus from RequestHistory as x where x.HLRStatus = 7";

public List execute() throws BusinessException,
Throwable {
List requestList;
Session session = HibernateUtil.currentSession();
Query query = session.createQuery(getrecycle);

requestList = query.list();

HibernateUtil.closeSession();
return requestList;

...

}

But once i use the sql query built by hibernate in log, the weird thing is that it returns rows.

So I am quite lost.

Any help will be appreciated.

Try a bind variable for the where clause.

Dear Mike,

Even with introducing a bind variable :status

query.setParamter("status", 7);

the query still does not return the supposed rows.

Hi All,

Could this be happening ?

In the table I am mapping there some columns in each row can accept null values.

In case I execute a select query on this table, does the null value impact the selection result ???

I mean, if a row contains a null value would it be select or no ???

Thanks in advance for your reply.