cancel
Showing results for 
Search instead for 
Did you mean: 

How does JDBC adapter reads or writes the data to DB

Former Member
0 Kudos

Hi All,

How does JDBC adapter read the data from a db, is it that it collects all the data in one go and sends to XI, or is it record by record. And what if it writes to a db?

Xier

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

It collects all record at one time and while writing to DB you can push all data at one go...

We are using receiver JDBC adapter to push data to DB and its one go..

Nilesh

Former Member
0 Kudos

Nilesh how about when i use stored procedure call both for reading and writing, would the stored procedure call be executed for each read and write or just once for reading and once for writing?

XIer

Former Member
0 Kudos

Yes. abs.

You can pass whole data to stored procedure is one shot....and vice-versa.

Nilesh