Problem in session Handling

Many of you might have faced this problem earlier as well. But this is a very new and recent learning which I have gained during my work at Nucleus Software. 


Many times I have seen, that where i expect the web-application to pick up and already existing session, it is creating a new session, when a request.getSession() is encountered.
I was unable to understand the reason, why? Then one colleague of mine helped me solve this problem. 
Still I am not 100% sure of the root cause of the problem, but this trick has solved my problem

Advanced Privacy Settings

You can override automatic cookie handling for all Web sites in the Internet zone by clickingAdvanced on the Privacy tab. You can use the Advanced Privacy Settings dialog box to configure first-party and third-party cookies to Accept, Block, or Prompt, with a check box to always allow session cookies. 





After doing this, session.isNew() started returning false and the problem was solved. 

What do you think of the following query?

What do you think of the following query?

select keyword from v$reserved_words;

to_char and to_date function in oracle

Source : http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html

When a DATE value is displayed, Oracle must first convert that value from the special internal format to a printable string. The conversion is done by a function TO_CHAR, according to a DATE format. Oracle's default format for DATE is "DD-MON-YY". Therefore, when you issue the query
select b from x;

you will see something like:
B
---------
01-APR-98


Whenever a DATE value is displayed, Oracle will call TO_CHAR automatically with the default DATE format. However, you may override the default behavior by calling TO_CHAR explicitly with your own DATE format. For example,
SELECT TO_CHAR(b, 'YYYY/MM/DD') AS b
FROM x;


returns the result:
B
---------------------------------------------------------------------------
1998/04/01
The general usage of TO_CHAR is:
TO_CHAR(, '')


where the  string can be formed from over 40 options. Some of the more popular ones include:
  , for example.

MM	Numeric month (e.g., 07)
MON	Abbreviated month name (e.g., JUL)
MONTH	Full month name (e.g., JULY)
DD	Day of month (e.g., 24)
DY	Abbreviated name of day (e.g., FRI)
YYYY	4-digit year (e.g., 1998)
YY	Last 2 digits of the year (e.g., 98)
RR	Like YY, but the two digits are ``rounded'' to a year in the range 1950 to 2049. Thus, 06 is considered 2006 instead of 1906
AM (or PM)	Meridian indicator
HH	Hour of day (1-12)
HH24	Hour of day (0-23)
MI	Minute (0-59)
SS	Second (0-59)