Skip to Content
Former Member
Apr 25, 2007 at 01:26 AM

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


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)