File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Problems with CachedRowSet - Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problems with CachedRowSet - Oracle" Watch "Problems with CachedRowSet - Oracle" New topic

Problems with CachedRowSet - Oracle

Fernando Franzini
Ranch Hand

Joined: Jan 09, 2009
Posts: 486

Hi Ranchersss

I'm with a strange situations. I have a table in oracle10g and one field that store date and time like yyyy-dd-mm HH:mm. If a got this data with ResultSet, everthing work well...but when I transform ResultSet in CachedRowSet to send to another software layer.....a loose the TIME value (HH:mm). I mean, when I got the value fied with return me the yyyy-dd-mm value.....!
So...Somebody know anything ???

Fernando Franzini - Java Blog
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30138

Are you calling getDate by any chance? That method doesn't return the time - you should be using getTimestamp.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Fernando Franzini
Ranch Hand

Joined: Jan 09, 2009
Posts: 486

Hi Jeanne

I'm using I'll try getDate or getTimeStamp....and I'll replay here what happened !!
Thanks for replay.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Problems with CachedRowSet - Oracle
Similar Threads
How to dispaly the date and time with difference of time from GMT
JSF/RichFaces calendar; value loses one day
<fmt:parseDate pattern> problem
related to Date