Hi Jim,

Thanks for the quick reply.

Jim Breen wrote:
> I don't have any answers for you, but if I was debugging it I would 
> try two things:
>
> 1) Put a breakpoint in PersistentLocalDate.nullSafeSet() as from what 
> I understand Hibernate would use that method to set the dates in the 
> query's prepared statement.  Perhaps what goes on in that method will 
> provide some clues.
Actually, when I set up my project to use joda-time, I spent a bit of 
time trying to work out how to get Maven to pull the source code as 
well, but couldn't solve that problem and ran out of time to pursue it.  
Probably would have been better spending the time downloading the source 
manually and putting it in the right place, but never mind.

I have a deadline approaching (Friday) so for now, I'm simply working 
around the problem by adding 1 day to each date I use in a query.  This 
seems wrong to me, but it's working and it'll get me past the immediate 
deadline.  As I mentioned in my first email, I'm on UTC + 9 hours and 
it's currently nearly 14:30 here and the query still needs a day added 
for it to work properly, so I suspect it's not a TZ issue after all.  
Maybe the problem's in Hibernate's Criteria code.  Unfortunately, I 
don't have the time ATM to play around with other options.
> 2) Temporarily change your code to use LocalDateTime instead of 
> LocalDate and see what the generated query looks like.  If there's 
> some unexpected timezone conversion going on, the times should show 
> you that.
I may give that a try on the weekend or next week, though as I 
mentioned, my current thinking is that it isn't a TZ issue so I'll 
probably look at other options first.

Thanks again,
Rob Hills
Waikiki, Western Australia

-------------------------------------------------------------------------
SF.Net email is sponsored by: 
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Joda-interest mailing list
Joda-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/joda-interest

Reply via email to