基于OCI9的数据库访问接口的改进与实现.PDFVIP

2010 19 5 OCI9 1 2 1 (1. 610065; 2. 610064) OCI9 ORACLE / Improvement and Implementation of Database Access Interface Based on OCI9 1 2 1 XU Wei , HU Shu , YANG Cheng (1.Department of Computer, Sichuan University, Chengdu 610065, China; 2.Institute of Image and Graphics, Sichuan University, Chengdu 610064, China) Abstract: A database access interface based on OCI9 is designed and implemented. Double conditional variable mechanism is presented in the interface to resolve the long time blocking problem caused by function when some anomalies occur in the database. Secondly, when the net wire is pulled out, the database reconnection will have a problem of the increase in memory. To avoid it, a solution of double detections of connection is put forward. Finally, experiments are made to test the application effect of the database access interface. Keywords: ATC system; OCI blocking/non-blocking; double conditional variable; increase in memory; double detections of connection 1 OCI9 Oracle (ATC system) 2 OCI ORACLE (OCI: Oracle Call Interface) ORACLE Oracle OCI Oracle ORACL E ( ) , (C ) ATC OCI ORACLE [1] ODBC ()