Hi:

I need more information on the use of ISqlWorker that what is proviced by the javadoc example. Someone can refer me a document, link, etc. where I can get some examples and documentation ?

In particular I would like to see how to use
com.webMethods.portal.service.sql.DataManager
and com.webMethods.portal.service.sql.core.ConnectionManager
to handle ltransaction scope and connection reuse.

In the code in the javadoc thre is a call to getConnInfo, if I comment out the call the code also seems to work. What is the purpouse to call getConnInfo() ?

String dataSource = “dataSourceName”;
// get the connection information for the datasource
ConnectionInfo conninfo = ConnectionManager.getConnInfo(dataSource);

//get a worker instance from the data manager
worker = DataManager.createWorker(dataSource);
:
:
worker.release();
:

}

Thanks