cancel
Showing results for 
Search instead for 
Did you mean: 

File to JDBC 20 MB file

Former Member
0 Kudos

Hi,

I need to upload a file to Database system around 20 MB file size. If I break/split message into four parts then I should upload everything successfully or rollback complete file. Is there any commit approach after uplaoding four splitted messages.

Otherwise what is the best approach ?

What should be the system configuration tol support the 20 MB file upload like CPU speed, RAM, multiple java nodes.

Thanks

My3

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member208856
Active Contributor
0 Kudos

As suggested by S.Vijay, use Batch Mode for the same.

I have also used this in my interfaces, it works.

goto ADVANCE tab of CC --> Tick on Advance Mode --> Tick on Batch Mode

Shabarish_Nair
Active Contributor
0 Kudos

not sure but

"If you want to collect SQL statements in a batch, select Batch Mode"

Guess that might maintain the commit.

Former Member
0 Kudos

Hi,

I'm not sure about your hardware configuration and the PI server version that you are using.

But you can try with 'CLOB' field in database to dump the data as it is using a java mapping.

Regards

Praveen.