aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problems with CachedRowSet - Oracle" Watch "Problems with CachedRowSet - Oracle" New topic
Author

Problems with CachedRowSet - Oracle

Fernando Franzini
Ranch Hand

Joined: Jan 09, 2009
Posts: 486
    
    2

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 CachedRowSet....it return me the yyyy-dd-mm value.....!
So...Somebody know anything ???
Regards.


Fernando Franzini - Java Blog
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30758
    
156

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
    
    2

Hi Jeanne

I'm using getString....so I'll try getDate or getTimeStamp....and I'll replay here what happened !!
Thanks for replay.
Regards.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problems with CachedRowSet - Oracle