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.
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.