commit

13.5.1 Close Cursor 1. Close the cursor with the closing command After processing the data in the cursor, the cursor must be closed to release the data result set and the lock positioned on the data record. The close statement closes the cursor,

Because our team now uses Crucible as a code review tool, I asked my colleagues to study the use of this tool, and this is the result of his research, and I just translated it in Chinese: Examples, such as the one named Charles Wang, examine the

Sqlserver2000 transaction processing in server|sqlserver| transaction processing   I.        Definition and its nature: transaction: A series of actions performed as a single logical unit of work. Attribute: A logical unit of work must have four

oracle| string 1, in the database to build a new table for testing.CREATE Tbale Tb_test(ID number,BLB BLOB);COMMIT; 2. Insert a new record into the Tb_test table for testing.INSERT into Tb_test VALUES (1, Empty_blob ());COMMIT;NOTE: Insert a new

Many people are skeptical about whether Java is the right place to deal with bulk data, and this extends to the idea that ORM may not be particularly suitable for batch processing of data. In fact, I think that if we apply it properly, we can

four necessary conditions of a deadlock 1. Mutually exclusive conditions (Mutual exclusion): Resources cannot be shared and can only be used by one process. 2. Request and retention conditions (Hold and wait): a process that has already been

Case 5: --New table space is not backed up, datafile is corrupted 1) test environment 07:52:16 sql> Create tablespace LX 07:52:24 2 datafile '/u01/app/oracle/oradata/prod/lx01.dbf ' size 10m; Tablespace created. 07:52:38 sql> Conn Scott/tiger

Today a customer consults with their RAC environment, Emd_maintenance. The Execute_em_dbms_job_procs process starts frequently and consumes a lot of system resources. This task runs every minute, and it is always in front of the top. This job is

Advanced | data | database One, Connection pool 1, Features: ①, Advantages: Performance ②, disadvantage: There may be many unused connections, resource waste 2, ADO. NET Connection Pool ① each. NET data provider that is contained in Ado.net can

Notes | transaction processing Understanding SQL Incident Handling1 The work done by the statement during SQL transaction can be canceled (using the rollback statement) before it is permanently written to the database. Commit tells the DBMS to make

The point of knowledge of this topic is to understand the insert usage in Oracle A, pivoting Insert (rotary insert) 1. CREATE TABLE Marks_details Gyj@ocm> CREATE TABLE Marks_details ( 2 student_id number (4) NOT NULL, 3 subject_id1

asp.net| data Many database operations need to be transacted, and there are roughly 3 levels of transactions under ASP.net: (1) Transaction at the level of the stored procedure (2) Ado.net-level transactions (3) asp.net transaction at the page level

The sample code is as follows: 1.package com.hb3.pack_01; 2. 3.import Java.util.Iterator; 4.import java.util.List; 5. 6.import Org.hibernate.Query; 7.import org.hibernate.Session; 8.import org.hibernate.SessionFactory; 9.import

Asp. NET Web page includes some additional elements that it can recognize and process at run time by ASP.net. Asp. NET pages can also contain reusable, custom controls. These custom controls will be processed by the server. This allows you to set

In the official blog of Microsoft Asia-Pacific Database Support Group, you will find that many articles use the Procmon.exe tool. Today I would also introduce this tool How big is the experiment based on this article, SQL Server, per log write? "

Techniques | data | Database design principles for large database databases Author: Thinking about finishing: Nanhai A good database product is not equal to have a good application system, if can not design a reasonable database model, not only will

Whether intentionally or unintentionally, if a transaction remains open in the database, it blocks other processes from manipulating the modified data. Similarly, backing up the transaction log only truncates the part of the transaction log for

Client| Data | When the database uses ado.net, each database operation must set connection properties, establish connection, use command, transaction processing, etc., more cumbersome, there are a lot of duplication of work. Can you put these

server| Solution Database operation deadlock is unavoidable, this article does not intend to discuss how deadlocks are generated, the focus is to resolve deadlocks, through SQL Server 2005, now seems to have a new solution. The following SQL

Use examples: save (' table_1 ', $row); Update $db->update (' table_1 ', $row); Delete $db->remove (' Table_1 ', 1); Query $rows = $db->find ($sql, ' id ') ?>