on 03-23-2010 8:06 AM
Hi,
I need to send a picture to a Database table. Please can you assist? How do I get the picture into the SQL query.
Your assistance in this regard will be highly appreciated.
Regards
Willie Hugo
We will be coding a JAVA proxy to do this. This then will allow us to reuse the solution, which will not be the case with a mapping.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Willem,
Check my new Blog: [SAP XI/PI: Storing BINARIES (Images, PDFs etc.) in the Database (BLOBs) Using JDBC Adapter|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18494] [original link is broken] [original link is broken] [original link is broken];
Regds,
Praveen Gujjeti.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Raj,
Please can you elaborate of how you would map the picture, using the PI Message Mapping, to the JDBC Insert Query? I just can not visualize this in my mind.
May thanks for your quick reply.
Regards
Willie Hugo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The binary data for BLOB should be hexadecimal encoded. You can acheive this using some javacode as suggested by sekhar.
[http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]
The rest JDBC adapter will take.
Check this link for sample java code..........
[http://www.example-code.com/java/bytearray_encoding.asp]
byte[].getEncoded("hex")
Edited by: Praveen Gujjeti on Mar 24, 2010 2:50 PM
Edited by: Praveen Gujjeti on Mar 24, 2010 3:14 PM
Hi,
Follow below steps.
1)Create PICTURE/IMAGE field in Data base as a BLOB field,which stores larged sizes.
Then in PI use INSERT query to insert data in Data base.
or
Use UDF or JAVA Mapping to insert Data.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.