Asynch Table: Database Connector Vs JDBC code

, ,
1

Hi,

I observed two popular approaches to work with database using myWebmethods 7.0

a) The built-in Database Connector

b) The java JDBC code that uses ISqlWorker and jdbc classes.

Option a) seems to be good and generic for results from a SELECT queries

Option b) seems to work well when we have to collect information from user esp in UPDATE/DELETE/INSERT actions and the user submits a form with lot of inputs. I can use this option for SELECT queries aswell.

My question now is: w.r.t Asynch tables? which one is more optimized.

2

I would recommend using the Database connector for as many situations as you can.