File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problems with CachedRowSet - Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 489

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
author & internet detective

Joined: May 26, 2003
Posts: 33130

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Fernando Franzini
Ranch Hand

Joined: Jan 09, 2009
Posts: 489

Hi Jeanne

I'm using I'll try getDate or getTimeStamp....and I'll replay here what happened !!
Thanks for replay.
I agree. Here's the link:
subject: Problems with CachedRowSet - Oracle
It's not a secret anymore!