(RADIATOR) SessionDatabase SQL date problems and solution

[Hartmaier Alexander]

Hi!

 

I just discovered why I got ‘ORA-01861: literal does not match format string’ errors for my Oracle session db.

I use the ConnectionHook to alter the session NLS_DATE_FORMAT but didn’t do this for the SessionDatabase because the docs don’t mention it as a valid configuration option.

While looking for a solution I found out that the SessSQL module is a subclass of SqlDb so ConnectionHook works!

 

Please add this info to the docs and maybe rethink the whole db connection configuration.

It would be great to be able to specify db connections and use them by identifier.

 

With best regards

Alexander Hartmaier

 

T-Systems Austria GesmbH

Rennweg 97-99

A-1030 Vienna

 

phone: +43-(0)57057-4320

mobile: +43-(0)676-8642-4320

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080123/c7e91ea4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5611 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080123/c7e91ea4/attachment.bin>