Orchidelle

2021年2月25日

摘要： reference: https://zhuanlan.zhihu.com/p/75891315 之前我说过，在Windows 的.Net平台下，做很多开发还是很舒服的。但是SQL Server 是个例外。安装 SQL Server就是个很困难的事情，中间步骤有很多术语都不明白微软是怎么搞的。好在，阅读全文

posted @ 2021-02-25 21:52 Orchidelle 阅读(125) 评论(0) 推荐(0)

scp 报错 not a regular file

摘要： scp source/filename [username]@[host]: destination scp 报错 not a regular file 解决方法：加上-r选项 scp -r wift* 10.160.9.202:/srv/backup/ 原因：要拷贝的是文件夹阅读全文

posted @ 2021-02-25 21:50 Orchidelle 阅读(227) 评论(0) 推荐(0)

Tomcat 设置 web encryption

摘要： sudo keytool -genkey -alias tomcat -keyalg RSA -keystore /etc/tomcat8/keystore sudo vi /etc/tomcat8/server.xml find and uncomment lines with SSL add s 阅读全文

posted @ 2021-02-25 21:49 Orchidelle 阅读(82) 评论(0) 推荐(0)

Fatal error in launcher Unable to create process using 'dapppythonpython37python

摘要： Fatal error in launcher: Unable to create process using '"d:\app\python\python37\python.exe" "E:\app\Python\Python37\Scripts\pip.exe" list' C:\Users\J 阅读全文

posted @ 2021-02-25 21:41 Orchidelle 阅读(1224) 评论(0) 推荐(0)

Using Sqoop to import from db2 to hadoop

摘要：参考： https://stackoverflow.com/questions/23933481/db2-data-import-into-hadoop sqoop import --driver com.ibm.db2.jcc.DB2Driver --connect jdbc:db2://db2 阅读全文

posted @ 2021-02-25 11:40 Orchidelle 阅读(93) 评论(0) 推荐(0)

2021年2月24日

MySQL 导出 select 结果集

摘要： reference: https://blog.csdn.net/huaishuming/article/details/74762652法一：SELECT * from jc_archives where senddate>UNIX_TIMESTAMP('2014-9-1' ) into outf 阅读全文

posted @ 2021-02-24 05:03 Orchidelle 阅读(398) 评论(0) 推荐(0)

Python Linux 命令行执行脚本输出重定向print到日志文件

摘要： reference: https://unix.stackexchange.com/questions/182537/write-python-stdout-to-file-immediately 立即输出print内容到文件 $ export PYTHONUNBUFFERED=1 $ ./mysc 阅读全文

posted @ 2021-02-24 05:02 Orchidelle 阅读(521) 评论(0) 推荐(0)

Error Code 1175. You are using safe update mode and you tried to update a table

摘要： update fund_nav set nav_chg_rate=left(nav_chg_rate, length(nav_chg_rate)-1) where right(nav_chg_rate, 1) != '%' and nav_chg_rate != ' 0000' Error Code 阅读全文

posted @ 2021-02-24 04:58 Orchidelle 阅读(216) 评论(0) 推荐(0)

oracle 查看 FK constraint referenced_table及columns

摘要： select uc.table_name, uc.r_constraint_name, ucc.table_name, listagg(ucc.column_name, ',') within group (order by ucc.column_name) over (partition by u 阅读全文

posted @ 2021-02-24 04:53 Orchidelle 阅读(84) 评论(0) 推荐(0)

oracle 19c 导入 12c ORA-39002 ORA-39358

摘要：直接用19c导出的dmp文件导入到12c，报错： ORA-39002: invalid operation ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 12.2.0 解决方法：重阅读全文

posted @ 2021-02-24 04:52 Orchidelle 阅读(2628) 评论(0) 推荐(0)

我的Wordpress博客地址：https://orchidelle.wordpress.com/