Java开发网 - Webmethods JDBC Adapter Cannot generate Script

Topic: Webmethods JDBC Adapter Cannot generate Script

1.Webmethods JDBC Adapter Cannot generate Script

Posted by: googlesz
Posted on: 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.

2.Re:Webmethods JDBC Adapter Cannot generate Script [Re: googlesz]	Copy to clipboard
Posted by: wishmaster Posted on: 2004-12-08 05:34 you might want to have a staging database/schema dedicated to webMethods environment and get DBA grants. btw, tibco bw designer has more visibility into the sql but you can find some more details in the log files or through the monitor in webMethods.

3.Re:Webmethods JDBC Adapter Cannot generate Script [Re: googlesz]

Copy to clipboard

Posted by: whisperwind
Posted on: 2004-12-08 16:21

对于监听数据库事件，可以采用接口表的方式，JDBC adapter监听接口表。不过比较麻烦，需要在源生产库表中创建一个trigger，在生产库表发生变化后由trigger往接口表添数据，接口表可以在与源生产库表不同的schema下创建。对于往数据库写数据，可以采用接口表或存储过程。