googlesz
发贴: 5
积分: 0
|
于 2004-12-02 11:20
When I use Webmethods Jdbc Adapter to synchronize data from different database,I generate the adapter notification,the Adaper will operate on the database directly to generate trigger and temp table ,while in the financial company,the database cannot be operated directly,you have to first give the script to the DBA and then the DBA check the security of the script,and then the database changed,did anyone come to this problem?how to solve?I have to use basic notification,but you have to write the script yourself .and the other way ,set debug 10,and make a little error ,then the script will appear,then I change the script myself.the two way really can solve the problem.But in TIBCO,its JDBC Adapter Can generate script and you can choose execute directly or give to DBA to execute,I wonder if any have any good way to resolve this problem!any suggestion are appreciated.
|