发布于2023-12-25 22:25 阅读(482) 评论(0) 点赞(10) 收藏(0)
是否可以为通过 JAVA JDBC 进行的 TERADATA FASTLOADCSV 调用设置 TENACITY 和 SLEEP?
我的 jdbc 连接字符串是
jdbc:teradata://99.99.99.99/TMODE=ANSI,CHARSET=UTF8,TYPE=FASTLOADCSV,LOG=INFO,SESSIONS=1
您可以在执行 FASTLOAD 脚本时设置这些选项,如下所示:-
By default the Tenacity feature is not turned on. The feature is turned on by the script command: Tenacity n;
Where n specifies the number of hours FastLoad continues trying to logon. The n specification must be greater than zero. If zero is entered, Teradata FastLoad responds with an error message and terminates. During the Tenacity duration, FastLoad tries to log on every 6 minutes by default. The 6 minute default can be changed by using the script command: Sleep m;
Where m specifies the number of minutes Teradata FastLoad sleeps before retrying the logon operation. The m specification must be greater than zero. If zero is entered, Teradata FastLoad responds with an error message, and terminates.
Below is an example of Tenacity usage. Suppose the commands in the script are: Tenacity 1;
Sleep 15;
The Tenacity duration is 60 minutes and the Sleep interval is 15 minutes.
通过 jdbc 执行 FASTLOADCSV 时可以设置这些选项吗?
我认为这些选项不存在,因为 FASTLOADCSV 与 FastLoad 不同,它只是使用低级别的 FastLoad协议。
您可能必须在程序中实现睡眠和坚韧逻辑,在连接时检查 2633(?) 错误。
作者:黑洞官方问答小能手
链接:http://www.javaheidong.com/blog/article/685776/c87b22aff5e48e7c3b2e/
来源:java黑洞网
任何形式的转载都请注明出处,如有侵权 一经发现 必将追究其法律责任
昵称:
评论内容:(最多支持255个字符)
---无人问津也好,技不如人也罢,你都要试着安静下来,去做自己该做的事,而不是让内心的烦躁、焦虑,坏掉你本来就不多的热情和定力
Copyright © 2018-2021 java黑洞网 All Rights Reserved 版权所有,并保留所有权利。京ICP备18063182号-2
投诉与举报,广告合作请联系vgs_info@163.com或QQ3083709327
免责声明:网站文章均由用户上传,仅供读者学习交流使用,禁止用做商业用途。若文章涉及色情,反动,侵权等违法信息,请向我们举报,一经核实我们会立即删除!