Skip to Content
Aug 10, 2011 at 02:56 AM

JDBC Batch Mode - metamatrix


I am trying to use Batch Mode on a JDBC receiver channel with a metamtrix database. So far, I have been unsuccessful.

1. Is there a setting in PI where I can specify the JDBC batch size? It seems it tries to group every record in the message into 1 batch, which is not good since there are over 20,000 records to be inserted.

2. We are getting a "Attempting to write to a closed socket" metamatrix driver error. I thought this was because by the time it groups all the inserts together for batch insert, the session/socket has expired, but I really don't know.