Oracle underlying interfaces: OCI, occi, and oo4o

For Oracle underlying interfaces: OCI and oo4o, please feel free to advise! Ivy_go (Yunmen dance set) 21:07:07 asked questions in other database development/SQL Anywhere Studio

I want to use VC for database access now. I used ODBC before, but the speed is too slow,
After searching previous posts, it seems that OCI is faster, and some people have said that oo4o is also very useful,
I quickly flipped through the online documentation of orcle, which contains some examples and help,
However, I hope you can give me some comments and suggestions on the use of the two,
Thank you!Number of questions: 100, replies: 17Top

Flowerofwind on the first floor (the reality is cruel) Back to 21:56:57 score 40

To quickly and flexibly interact with Oracle, it is best to use the OCI interface. A lot of database middleware is developed using OCI, and I also think it is very useful, of course, you need to draw some effort on the interface design encapsulation. You can even design interfaces that are compatible with the JDBC class. If you use Oracle9i, there is occi in it and C ++ is encapsulated, can be used directly
What is oo4o? Top

2 floor yfr (a Mao) Back to 22:00:54 score 40

First, let's talk about OCI, the full name: Oracle call interface, which is an interface based on C language with high efficiency and powerful functions. It supports array interfaces, but there are many functions. Some functions have many parameters, it is complicated to use custom data types.

Oo4o (Object Oriented for (four's homophonic) Ole) uses OCI as the underlying interface with the database. It is encapsulated by COM and can be used in VC, VB, and ASP. It is also provided to you in an object-oriented way (that is, encapsulated classes one by one), which is easier to use. However, because of the use of the COM mechanism, its performance has an impact. These two interfaces are dedicated interfaces of Oracle. If you need to port a database, you cannot use these interfaces. If you can understand OCI, it is strongly recommended to use OCI. If the interface performance requirements are not high, oo4o will be good!Top3 floor

Jlandzpa (jlandzpa) Back to 22:01:26 score 20

Oracle Objects for OLE (oo4o) is an oracle middleware that allows native access to Oracle from client applications using the Microsoft Object Linking and Embedding (OLE) standard. but performance-wise it is better than open database connectivity (ODBC), a standard database access method developed by Microsoft Corporation, to access Oracle. oo4o is thread safe and provides full support for PL/SQL. connection pooling is also available with later versions of oo4o.
top

Flowerofwind on the 7th floor (the reality is cruel)The score is 0 at 20:12:26.

YesOcci is a encapsulated C ++ class

Flowerofwind on the eighth floor (the reality is cruel) The score is 0 at 20:17:26.

The array interface means that you need to import data from text files to the database in batches. you can insert data one by one, but it is very slow. The array interface provided by OCI allows you to insert data in batches, equivalent to bcptop

Chfhy (spring rain) on the 12th floor)The score is 0 at 08:59:13.

Some suggestions: Because the OCI interface makes the standard, you can first develop the top port for accessing the database with VC on Windows.

Yfr (a Mao) on the 13th floor) The score is 0 at 11:45:02.

The so-called array interface means you can use one statement to manipulate multiple records (mainly for insert, update, and delete statements. For example:
Insert into tab_name values (: col_a,: col_ B,: col_c );
If the placeholder col_a, col_ B, col_c has at least one help for scalar data (non-array), only one record can be inserted at a time. If these Placeholders are bound to an array, you can insert multiple records at a time (if the number of elements in each array is inconsistent, the number of inserted records is equal to the number of elements in the array with the least number of elements) Top