hi,

how can i get null values from a table.I have a query like this:
String srvTypeID = "1";
String query = "FROM Service WHERE SRV_GROUP LIKE'"+srvTypeID+"%' ORDER BY SRV_GROUP,SRV_NO";
List result = session.createQuery(query).list();

i got a error like this:

WARN - SQL Error: 17026, SQLState: null
ERROR - Numeric Overflow
Exception in thread "main" java.lang.RuntimeException: could not execute query
at de.gloegl.road2hibernate.EventManager.getServiceInfoList(EventManager.java:90)
at de.gloegl.road2hibernate.EventManager.main(EventManager.java:56)

Are SRV_GROUP and SRV_NO the names of the columns in the table or are they the names of the getters in your service object? Those should correspond to getter/setter in your Service object.