Mediator - convert XSD datetime to SQL date value
Fusion 11g, JDev 11.1.1, W server 2008
Hi there,
using JDev we've defined a DB adapter (towards an ORACLE schema), which basically serves two operations: INSERT and SELECT. On the DB table we've got a DATE_TIME while on on the other side we've defined a wsdl where the INPUT operation takes as parameter an XSD DATETIME value.
The values have different structures and so we've started to play with the "Assign Values" function on the Mediator component, unfortunately without any success.
Right now our expression is the following
from
ora:formatDate($in.newEventParam/newEventParam/ns:executionTime,"dd-MMM-yy")
to
$out.LogCollection/top:LogCollection/top:Log/top:when
As first question I would like to ask you if our approach is correct and in that case what's wrong with our expression as we tried to use the same pattern as we use in SQL.
Second, we performed some tests using the EM console. On test failure it shown a stack trace saying only that there was a problem performing a transformation. That's a bit too less, especially when transformation is done on large amount of values. Is there any way to increase trace level and get further details on which transformation didn't work out?
Thanks in advance
Alessandro Ilardo