JDBC Batch Mode - metamatrix

[susan_pfab]

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.

[rajasekhar_reddy14]

> 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.

>

We dont have any option to specify Btach size.

> 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.

Some JDBC drivers wont support Batch mode operation, i think your driver not supporting it. so go with normal procesisnfg.

Regards,

Raj