on 2006 Sep 14 8:48 AM
HI ALL,
We have to read data from an Oracle 7.2.3, but we are having problems In the inbound payload I can see that we have the data but is not building the xml properly, because the tags are empty. Someone haa experiencied this issue before?
Many thanks in advance!
Regards
Noelia
Noelia, check my weblog below. The Data Type you defined in IR should be the same as the database column name, and case-sensitive.
<a href="/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter and Tutorial for Sender JDBC Adapter</a>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Noelia,
first I would check your SQL statement (from your communication channel) with another tool.
e.g.TOAD.
See, what the statement delivers!
Regards Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario,
the SQL is correct. I have checked it in Toad. I thinks this is something relative to the driver for oracle, because the jdbc adapter recover the data of the query but the info that I can see in the payload is the following:
<ns:MT_XXXXXX xmlns:ns="http://XXXX.es/xi/XXX">
<row>
<b><></b>123<b></></b>
<b><></b>PEPITO<b></></b>
<b><></b>01/01/2006<b></></b>
</row>
</ns:MT_XXXXXX>
And thats drive me to think that this is an issue with the driver, but Im not sure.
Any idea?
Many thanks
Regards
Noelia
Message was edited by: Noelia Fernandez
User | Count |
---|---|
73 | |
10 | |
9 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.