on 04-02-2009 12:51 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.