Thanks for all the help, I got it working pretty much by ignoring the date aspect of things... let me know if you think this will cause any problems. ...

Hi Andras,

I tried first to take the query and paste it right into Enterprise manager itself, replacing the rangeStart and rangeEnd with relevant numbers instead of ?, then when it...

Here is the exact exception that I am getting -

EXCEPTION_TYPE: Exception CLASS: .DBQuery METHOD: getDiseaseRange MESSAGE: java.lang.Short

EXCEPTION_TYPE: Exception CLASS: ...