cancel
Showing results for 
Search instead for 
Did you mean: 

How can I transfer binary data from a database to another database?

Former Member
0 Kudos

Hi all.

I want to transfer binary data from a MS SQL Server 2000 to anohter SQL Server 2000.

I created JDBC(table) to JDBC(stored procedure) scenario,and

I uploaded a JPG image file to the sender table using the java program I developed.

The JPG data was transfered to receiver,but the transfered data was broken.

I can't not open the file correctly.

Can XI transfer binary data using JDBC adapter?

The sender table structure is following.

<b>column (data type)</b>

id (int 4)

binary (binary 8000)

flag (int 4)

The receiver stored procedure parameter is following.

<b>parameter (data type)</b>

id (smallint)

binary (binary 8000)

flag (smallint)

Regards.

Yuuki

Accepted Solutions (0)

Answers (1)

Answers (1)

prateek
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi,

<i>

Can XI transfer binary data using JDBC adapter?

Ans: Yes</i>

How Can I transfer binary data using XI?Please let me know.

Reagard,

Yuuki.

former_member335553
Active Contributor
0 Kudos

Hi

Have u refered this thread

/people/william.li/blog/2006/09/08/how-to-send-any-data-even-binary-through-xi-without-using-the-integration-repository