• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
Bartenders:
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

problem retrieving date type from database.  RSS feed

 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have come across a peculiar problem when I try to deploy ear in Weblogic Sun Solaris.

I am trying to fetch data from a table which has a field of type DATE.

I am using resultset.getObject(index) method to get the object for each column in the table. The issue starts here. In my windows system when I try to get the type of this object it returns java.sql.TimeStamp for the date column but when I deploy in UNIX it returns to me that object type of this column is java.sql.Date.

Can anyone explain why is this behaving differently in different platforms ?

I am using Weblogic 8.1 SP2 for the deployment in sun and windows OS.
 
author & internet detective
Marshal
Posts: 38667
677
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Unni,
It looks like the drivers are giving you different types when you do not specify a specific type to return. If you call the getDate() or getTimestamp() method, you will consistenly get the type you are expecting.
 
unni krishna
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks friend, it worked.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!