Database
hitman.banker
Thinking in Architecture and Art
展开
-
Oracle 11 数据迁移后中文乱码问题
这段时间把测试环境的Oracle 11数据迁移到了一个新的云端环境,迁移的方式就是使用expdp和impdp按表空间导出导入,主要的命令像这样:expdp devmgr/Passw0rd@192.168.2.17:1521/stfaeshoradb tablespaces=USERS dumpfile=usersdb.dmp directory=test_db logfile=expdp...原创 2020-01-14 17:23:51 · 475 阅读 · 0 评论 -
多个同名user导致mysql 1045 错误
在mysql中,create user都是要指定@的,我在一个测试库执行了多次create userCREATE USER 'faetest'@'localhost' IDENTIFIED BY '123456';CREATE USER 'faetest'@'192.168.1.22' IDENDIFIED BY '123456';CREATE USER 'faetest'@'%' ...原创 2020-01-10 17:40:09 · 366 阅读 · 0 评论 -
关于 未能启用约束。一行或多行中包含违反非空、唯一或外键
visual studio 2010, mysql 5使用xsd时,properties开始有显示commandtext,然后点击边上的展开按钮可以看到完整的SQL,展开后看到的可能被Visual Studio加了引号等处理。保存已在mysql workbench调试通过的SQL时,在Visual Studio常常报错,怎么去编辑,头大!发现要以properties开始显示的comma原创 2014-03-13 20:42:12 · 1202 阅读 · 0 评论 -
MySQL Partition By Rank
Reference:1. http://blog.sqlauthority.com/2014/03/09/mysql-reset-row-number-for-each-group-partition-by-row-number/原创 2014-07-03 11:00:32 · 1418 阅读 · 0 评论 -
Trigger Lesson
Reference:[1] https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:363719300346898052原创 2014-08-19 11:50:12 · 497 阅读 · 0 评论 -
Hibernate Performance Revisit
In bird view, consists of 2 parts: Fetching Strategy and Caching StrategyFetching Strategy: elaborate how to原创 2014-09-12 15:45:41 · 684 阅读 · 0 评论 -
No NOWAIT Option in MySQL SELECT FOR UPDATE
It sucks!Beware of this when you want to use SELECT FOR UPDATE for pessimi原创 2014-09-16 17:15:10 · 1405 阅读 · 0 评论 -
Accounting Balance Data Model Design
Reference:[1] http://stackoverflow.com/questions/4373968/database-design-calculating-the-account-balance原创 2014-10-09 18:00:00 · 588 阅读 · 0 评论 -
LESSON: PLSQL Developer Setup Distilled
1. EnvironmentWindows 7 64 bitOracle2. Download Oracle Instant Client3. Download PLSQL Developer Green4. Setup4.1原创 2015-05-21 16:08:00 · 499 阅读 · 0 评论 -
A light weight mysql GUI tool
SQLyog community version.I have been using mysql workbench and TOAD for mysql, but TOAD is not stable, often gets stuck. mysql workbench is not very user friendly as its editor width cannot be adj原创 2016-01-16 17:56:50 · 513 阅读 · 0 评论 -
MyBatis Invalid Bound Statement
1. Problem & AnalysisThe project passes all tests in STS, but fails many tests when executing gradle build.Find the Gradle's test report, many Invalid Bound Statement.Then go to the bin folder,原创 2016-06-24 17:08:42 · 792 阅读 · 0 评论 -
The error occurred while setting parameters
MyBatis, MySQLError: The error occurred while setting parameters. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...An原创 2016-06-10 18:39:13 · 5987 阅读 · 0 评论 -
ORA-00907 missing right parenthesis
看错误,像是缺了右括号,但我的SQL是dbvisualizer生成的,怎么会少括号?把SQL拿出来单独跑,也是报同样错。查网上都是说SQL语法错了。SQL是这样的:ALTER TABLE RTB.TXMSG MODIFY (MSGJSON CLOB);我本来是想把原表的VARCHAR2类型改成CLOB,于是在dbvisualizer上改就遇到这个问题。最后是这样解决...原创 2019-01-29 17:25:43 · 889 阅读 · 0 评论 -
Custom tool error Failed to generate code
1. ProblemVisual Studio 2010. Custom tool error Failed to generate code2. SolutionOur project was based on MySQL connector 6.5.4 initially, my machine installed 6.7.4. Once I downgrade it to 6.5原创 2014-03-13 18:32:35 · 910 阅读 · 0 评论 -
SessionFactory.getCurrentSession()
It's a must to understand SessionFactory.getCurrentSession() thoroughly.To get the session associated with the current Spring transaction, you need to employ sessionFactory.getCurrentSession().T原创 2014-03-12 09:48:46 · 805 阅读 · 0 评论 -
UAT Plight: Fail To Refresh Database
In the past couple of days, we've been making efforts to get the UAT environment ready. Tragically, our database support failed to restore the database with current real data in production environmen原创 2012-03-11 16:46:27 · 656 阅读 · 0 评论 -
Readonly ERP Database For Query, RAC Employed
A Readonly ERP Database will be established in order to optimize ERP OLTP performance.RAC is the key means to synchronize main ERP and readonly ERP. Generally, the delay for synchronization would be原创 2012-03-13 16:49:15 · 506 阅读 · 0 评论 -
LESSON: DON'T Use Oracle 9i Client to EXP Oracle 10g Database
DON'T Use Oracle 9i Client to EXP Oracle 10g Database, otherwise, you would probably encounter an error when you export LOB colomn: "EXP-00003 : no storage definition found for segment ....."原创 2012-03-13 11:42:57 · 682 阅读 · 0 评论 -
Oracle 10g XE Notes on Ubuntu
PART 1: Oracle 10g XE Notes on Ubuntu1. Restartsudo /etc/init.d/oracle-xe restart2. Symptom: I can connect to Oracle XE by SQL command line, the database engine seems work fine, but the Oracle X原创 2012-11-07 18:36:12 · 626 阅读 · 0 评论 -
Unit of Work in ORM
PART 1:Reference: http://stackoverflow.com/questions/3532258/unit-of-work-pattern-and-historyThe concept of Unit Of Work is a central concept of ORMs and has been described by Scott Ambler in hi转载 2012-12-24 18:43:00 · 850 阅读 · 0 评论 -
Case: How To Clean Up Large Table
We have a large interface table with more than 12m records, unfortunately, most of them are useless, we’d like to clean it up for performance optimization.Delete useless data by ‘delete from ’ and原创 2012-12-18 09:41:04 · 523 阅读 · 0 评论 -
UDA
Reference: http://docs.oracle.com/cd/E18727_01/doc.121/e13108/T381249T381418.htm原创 2012-12-18 08:48:00 · 947 阅读 · 0 评论 -
Oracle 11g XE & PLSQL Developer 9
OS: Windows 71. Install Oracle 11g XE2. Install PLSQL Developer 93. ProblemAfter Step 2, got this problem:The OracleXETNSListener service on Local Computer started and then stopped.Solut原创 2012-12-22 08:17:08 · 2005 阅读 · 0 评论 -
PLSQL Developer Setup
0. EnvironmentOracle : Oracle 10gOS: Windows 7 professional 64-bit PLSQL Developer: 7 (green)1. Download Oracle InstantClient and configure it.1.1 Downloadhttp://www.oracle.com/tec原创 2013-09-22 16:39:08 · 1730 阅读 · 0 评论 -
Toad for MySQL formatter
Reference:http://dev.toadformysql.com/webhelp/Content/Editor/formatting_SQL.htm原创 2013-12-19 12:52:07 · 2981 阅读 · 0 评论 -
How To Export MySQL Data as Insert Statements
1. ToolToad for MySQL, free software2. Toad's default behavior is exporting the whole table, thus we'd better create a temporary table first, insert the query result, and follow the Export Wizard,原创 2014-02-26 15:20:30 · 1023 阅读 · 0 评论 -
ORA-28002: the password will expire within 7 days
1. Problem Description请输入用户名: paranoid输入口令:ERROR:ORA-28002: the password will expire within 7 days2. SolutionSQL> conn sys/insomnia as sysdba已连接。SQL> alter user paranoid identified原创 2014-03-06 06:45:13 · 883 阅读 · 0 评论