Hi all,

My program is getting date from database (oracle) and am getting that date's day of week also.

In windows its giving one number and different in linux

For Example:

30 - Jun - 2009

Am getting 2 in windows and 3 in Linux.

Am not understanding whats going wrong.. Am using same JDBC driver in windows and linux.

Thanks in advance,
Raji.

Presumably is reporting what the operating system calls that day of the week, whether they start with the first day being 0 or 1 and them using a different day as the start of the week?

Thank you.

Its taking monday as 1. this is same as windows day of week but when i ran my application its giving 2 ;(

Regards,
Raji.

Resolved the issue

The configuration of NLS_TERRITORY in Oracle database is by default AMERICA. When my application is executed from all windows boxes, the JDBC Driver changes it to AUSTRALIA based on the locale.
However when running my application on UNIX, where the server OSs are also setup with AMERICA as the locale, the driver fails to change the NLS_TERRITORY setting. Given that the Oracle DB and OS would not be configured with AUSTRALIA as the locale (as AMERICA is the standard followed); the solution is to start the JVM when running the application with a parameter specifying that the locale is AUSTRALIA.