Can a JDBC adapter query the database table? If yes, what are different possibilities?
Yes. You can configure sender and receiver communication channels. A special XML format is defined for content coming from the Integration Engine. This canonical format enables SQL Insert, Update, Select, Delete or stored procedure statements to be processed. A message is always processed in exactly one database transaction. b) JDBC adapter cannot insert records in the database. c) We should not insert, update records in the database directly.
Related Questions
- Why is the access rule table displayed after lookup in the read-only policy query window different from the one configured in Security Manager?
- Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
- Can a JDBC adapter query the database table? If yes, what are different possibilities?