Re: rOracle JDBC drivers and setting NLS_DATE_FORMAT in a logon trigger doesn't work

"Andre van Winssen \(andrew\)" <andrew-no-spam-svp_at_info.nl> wrote in message news:3c95e933$0$11068$4d4ebb8e_at_news.nl.uu.net...

> Did anybody ran into the same problem before and found better
> alternatives for manipulating NLS settings for Java applications
> without hardcoding alter session stmts?

Usually, I hard-code specific format in the SELECT/INSERT statements:

SELECT ..TO_CHAR(thedatefield,'DD-MM-YYYY')...

INSERT... TO_DATE('01-01-2002','DD-MM-YYYY')... This way I'm absolutely sure about what I put into the db and what I get back from it.
I admit: it's not very nice & clean, but it works.

Davide

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG