Skip to content

XAware Open Source Data Integration

You are here: Home arrow Forums
XAware Community Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Blob field insertion Error (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Blob field insertion Error
#3082
hejunion (User)
XAware user
Posts: 5
User Offline Click here to see the profile of this user
Re:Blob field insertion Error 1 Month, 2 Weeks ago Karma: 0  
Hi,dblack,

I am using the below format:
<root>
<bizcomp1/>
<bizcomp2/>
</root>

Here is the XBD as explained:
<Document>
<sql XBC read data from table>
<file XBC write XML as in file>
<sql XBC insert the record in table of another database>
<Document>

I also tested only the writing sql XBC, inputting the XML file, got the same error; when remove the BLOB mapping, the record got inserted successfully.

Thanks & Regards
-----------------------
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns:xa="http://xaware.org/xas/ns1" xa:version="5.0" xa:on_error="xa-doc::/Document/Error" xa:visible="yes">
<xa:input>
<xa:param xa:name="file_type" xa:datatype="string" xa:default="826" xa:description="" />
<xa:param xa:name="cus_mst_no" xa:datatype="string" xa:default="2525632" xa:description="" />
<xa:param xa:name="filetoWrite" xa:datatype="string" xa:default="C:\Applications\xaware\designer\workspace\TFGT\data\file1.xml" xa:description="File XML will be written to" />
</xa:input>
<get_dbt_c_in_file xa:bizcomp="myService/dbt_c_in_file.xbc" xa:remove="yes" file_type="%file_type%" cus_mst_no="%cus_mst_no%" />
<writetoxml xa:bizcomp="myService/writeXML.xbc" xa:input="xa-doc::/Document/DBT_C_IN_FILE" xa:remove="yes" filetoWrite="%filetoWrite%" />
<Update_dbt_c_in_file xa:bizcomp="myService/insert_dbt_c_in_file.xbc" xa:input="xa-doc::/Document/DBT_C_IN_FILE" xa:remove="yes" />
<Error xa:include="no">
<detail>$xavar:error_stack$</detail>
</Error>
</Document>
-----------------------------------
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Blob field insertion Error
hejunion 2008/11/17 06:49
    thread link
thread linkthread link Re:Blob field insertion Error
dblack 2008/11/17 11:17
    thread link
thread linkthread linkthread link Re:Blob field insertion Error
hejunion 2008/11/17 20:40
    thread link
thread linkthread linkthread linkthread link Re:Blob field insertion Error
dblack 2008/11/18 14:34
    thread link
thread linkthread linkthread linkthread linkthread link Re:Blob field insertion Error
hejunion 2008/11/18 20:07
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Blob field insertion Error
dblack 2008/11/19 16:34
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Blob field insertion Error
hejunion 2008/11/19 20:00
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Blob field insertion Error
dblack 2008/11/20 11:15
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Blob field insertion Error
dblack 2008/11/20 12:21
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:Blob field insertion Error
hejunion 2008/11/20 20:48
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Community Login

Polls

What best describes your current or next project that will include data services?
 

Visit XAware.com