Oracle Diagnostic Case-Sql_trace II

Question note: Many times When we do database operations For example, drop user,drop table and so on, often encounter such errors. ORA-00604: error occurred at recursive SQL level 1 . Such prompts are often useless. This case provides an idea and method for reference. 1. Dropuser has problems Exit after reporting the following error RA-006 ...

Posted on Fri, 19 Apr 2019 20:18:33 -0400 by zenon

Determine whether the username is correct

In the process of program development, it is often necessary to determine whether the user name input is correct. The user name input can be determined by comparing whether the user name string input by the user is the same as that in the database or the existing set. Java's basic data type can use "==" to determine whether the two op ...

Posted on Fri, 19 Apr 2019 19:42:33 -0400 by Unknown_Striker

(Summary) Batch data import of SQL Server Bulk Insert

 (summary) Batch Data Import of SQL Server Bulk Insert 2012-11-19 17:07:51 Classification: Oracle From:http://rsljdkt.iteye.com/blog/1147707 The Bulk Insert statement of SQL Server can import local or remote data files into the database in batches, which is very fast. Remote files must be shared, and file paths must be ...

Posted on Fri, 19 Apr 2019 16:18:33 -0400 by yepster123

eclipse uses maven to build maven + database transactions

This article is reproduced to: http://www.cnblogs.com/java-zhao/p/5350106.html In actual development, transactions are seldom used. Generally, transactions are mostly used in the aspect of money calculation. After mybatis is integrated with spring, what should its transactions do? In fact, it is very simple to add the @Transactional ann ...

Posted on Fri, 19 Apr 2019 13:33:33 -0400 by Wien

Introduction to Amazon DynamoDB 8: Delete items

The last article introduced DynamoDB updates, which will cover project deletion operations and dynamoab-py Delete data from tables In SQL, the DELETE statement Deletes one or more rows from the table. DynamoDB deletes an item at a time using the DeleteItem operation. SQL In SQL, you can use the DELETE statement to delete one or more rows. The W ...

Posted on Fri, 19 Apr 2019 13:18:33 -0400 by Boz

Deep Understanding of memcache Principle

Original address: http://blog.csdn.net/wusuopuBUPT/article/details/18238003 1. Why use memcache Due to the high concurrent reading and writing requirements of websites, traditional relational type data base Bottlenecks are beginning to emerge, such as: 1) High concurrent reading and writing of databases: Relational database itself ...

Posted on Thu, 18 Apr 2019 23:51:33 -0400 by Ted Striker

Java 8 (5): Processing null with Optional

Students who have written Java programs have generally encountered NullPointerException:) - In order not to throw this exception, we will write the following code: User user = getUserById(id); if (user != null) { String username = user.getUsername(); System.out.println("Username is: " + username); // Use username } But a lot of times, w ...

Posted on Thu, 18 Apr 2019 23:00:35 -0400 by ozone1

Tencent Cloud Technology Sharing: MySQL AHI Implementation Analysis

The process of locating user records in MySQL can be described as: opening index - > searching B + tree branch node layer by layer according to index key value - > locating leaf node, locating cursor on rec satisfying condition; if tree height is N, then reading N nodes in index tree and comparing them. If buffer_pool is small, a large nu ...

Posted on Thu, 18 Apr 2019 22:36:33 -0400 by dcj1978

Summary of node express mongoDB personal blog

1 Registration, login and exit 1.1 User Registration and Login Configuration template engine, mongoDB database driver, static file path and post request parsing Middleware Unified data return format for api.js routing // Unified return data format var responseData; // Initialize each request router.use(function (res, req, next) { responseDa ...

Posted on Thu, 18 Apr 2019 17:21:33 -0400 by obsidian

C# Transaction Processing (II) ADO.NET Transaction

Before publishing the System.Transaction name, you can use ADO.NET to create transactions, or you can use components, features, and COM+ (located in System. Enterprise Services) runtime for transaction processing. 1.ADO.NET transaction First, look at the traditional ADO.NET transactions. If you don't create transactions manually, every SQL ...

Posted on Thu, 18 Apr 2019 15:21:33 -0400 by jipacek