最近遇到一个问题,需求是把大量的数据写入到第三方数据库oracle,目前用的是 EnsLib.SQL.OutboundAdapter 方案,但是感觉队列很容易卡死,不知道是什么原因。然后想换成 set res = ##class(%ResultSet).%New("%DynamicQueryGW:SQLGW") 这种方式执行插入和更新。但是它返回的错误是网关调用失败,我希望得到具体的错误,我用这个对应额sql语句去 navicat执行就能提示出明确的错误!有大佬处理过类似的问题吗?有更好的方案吗?
*** Recovery started at Wed Sep 28 08:14:28 2022 Current default directory: d:\dhc\devsoftware\ensemble\mgr Log file directory: d:\dhc\devsoftware\ensemble\mgr\ WIJ file spec: d:\dhc\devsoftware\ensemble\mgr\CACHE.WIJ Recovering local (d:\dhc\devsoftware\ensemble\mgr\CACHE.WIJ) image journal file... Starting WIJ recovery for 'd:\dhc\devsoftware\ensemble\mgr\CACHE.WIJ'. 0 blocks pending in this WIJ. WIJ pass # is 0. Starting fast WIJ compare Finished comparing 24 blocks in 0 seconds Exiting with status 3 (Success)