Hi Vladimir, I have no experience with MySQL as DB storage, but I thought this kind of problem should be solved rather at ORM level (Hybernate? driver?). To my understanding, MySQL hase really flexible NLS/collation facility. I'm wondering if it's not just a minor configuration issue. What if you ommit this TZ stuff at all? Well your date in DB is meant EDT but the framework is aimed to let the user in US and Europe see DIFFERENT output in browser (accoding to local time zone EDT or CET) keeping the data constant. If you just set it 'hard' at view level, both will see exactly the same. If you make it configurable in your code, you have to maintain the conversion not only befor renderind, but after posting too. Why don't let JS do the job locally, at client? One more consideration.. precision. Have you tried DATETIME, not DATE? Anyway I have just a new MySQL instance at my test server. It's a good occasion to play a bit with this for a sample scroller/paging application.
Regards, paul Vladimir Isakovich wrote: > > Hi Paul, > I am getting to the conclusion that it will be impossible to use hibernate > generated pojos with jsf directly (I tried to change from date to > timestamp > in mySql - no better). > -- View this message in context: http://www.nabble.com/Tomahawk%2BDataScroller%2BWorkingWithLargeTables-tf4016097.html#a11513466 Sent from the MyFaces - Users mailing list archive at Nabble.com.
