Part of you not understanding it was me not understanding it either :)
I now have a compositeusertype which handles getting the String in my object to be a timestamp in the database. I want to work with the field(let's call it Apples) as a Timestamp in my HQL queries. Is this possible?
Example:
Suppose this is my class
public class Apples{
...
String DateString;
...
}
for this Apples class, I made a CompositeUserType:
public class ApplesCompositeUserType{
...
// a few interesting tidbits from that class
public Class returnedClass() {
return String.class;
}
public Object nullSafeGet(...){
Date blah = ResultSet.getDate(names[0])
return blah.toString();
} // nullSafeSet will build the Date from a string
...
}
My mapping would be like:
<property name="DateString"
column="TIMESTAMPHERE"
type="ApplesCompositeUserType">
I haven't been able to do a great deal of testing on it yet. What I'm wondering is, what sort of HQL functionality will I be able to use if I run with this sort of a setup? Can I use the HQL date stufflike comparing it to CURRENT_DATE? Can I call something like YEAR(apple.DateString)?
What about making a parameter of this usertype be a timestamp field. If I gave the String a TimeStamp field could I work with that field as if it were a Java Date object?
Login
FAQ
Search
