cancel
Showing results for 
Search instead for 
Did you mean: 

Out of memory error in JDBC sender adapter

Former Member
0 Kudos

Hi

I am inserting a large data set using a sender JDBC adapter into a single table in an MSSQL server.

Theoretically I could use statement batch mode to increase throughput. However if I set the batch flag I get an "insufficient system memory to execute this SQL Statement" exception which is apparently being thrown by the SQL server jdbc driver

Question is: Is there a way to allow it to use more memory? Which parameter should be modified and where is it?

Thanx

-Sam.

Accepted Solutions (1)

Accepted Solutions (1)

VijayKonam
Active Contributor
0 Kudos

Are you using sender jdbc channel for inserting data? I am afraid.. you should be using receiver adapter for this..!! Also since the error is being thrown from the SQL server, you might want to talk to the SQL Server administrators..!

VJ

Former Member
0 Kudos

You are right, I meant to say receiver adapter.

Answers (0)