Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "what are the matters needing attention in connecting Oracle". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The design of connecting to Oracle can be used as an alternative to ADO, or you can do what JDBC does. Some of the functions of OO4O are divided into OLE DB and ADO.NET. However, OLE DB does not support the object data types introduced in Oracle 8.

Demarest:OO4O supports object data types. And we think that ADO.NET also supports object data types. OLE DB does not support it because it is written on the old specification. ADO never uses another interface. It is closed and not extensible as designed by Microsoft. That's why we developed ODP.NET. ADO.NET does not have access to all those higher-level features in the connection Oracle.

VSM: not many developers use OO4O in many ways, but they use it for XML functionality. Does your. Net support have all the features of OO4O?

Demarest: many of our users choose OO4O over OLE DB because of its quality, scalability, and performance, as well as other features I've talked about, such as advanced queuing, handling connection Oracle object types, and new XML database performance. OO4O has been changed to connect to the Oracle environment, while the functionality provided by Microsoft is more common in nature. The ADO.NET specification gives us the opportunity to provide our own functionality to Windows developers. This is our .NET support. Our direction is to provide a comprehensive functional access. So the answer to your question is yes. We will support .NET according to the needs of our users.

VSM: in .NET, is it possible to get the same level of XML support in Java?

Demarest: we are prepared to provide our XML DB. That's our local XML database performance, announced for connecting to Oracle 9i version 2. It is still in beta: an official version will be released within a year. The most important technical idea is that you can always use the connection Oracle to make standard calls. VS developers always have a way to get our XML database, although it needs to be called up by C or C++.

VSM: can you do those calls in C #?

Demarest: I'm not sure about C#. It may be able to access the CumberCraft + class library.

How to connect to Oracle database in Python environment

Ten skills of JDBC connecting to Oracle Database

Some problems that JSP should pay attention to when connecting to ORACLE database

Eight skills proficient in JDBC connecting to Oracle database

MyEclipse 6.0resolves the problem of connecting Oracle 10g

VSM: compared with Java users, does connecting Oracle consider .NET users to be second-class citizens? Many VS developers seem to think that everything that connects to Oracle is written with Java in mind, not Windows APIs.

Demarest: I don't agree with that. I think Microsoft makes Java users second-class citizens. The services provided by .NET have similar functions-we support them. The J2EE specification is more mature / complete, so more support is needed. .net has always been our goal. We need to integrate some of the technologies of .NET to make our products more persuasive. Obviously Microsoft has privileges and can develop completely and directly using the operating system, while we can't. But we can usually keep pace with Microsoft, so I think we are as good as any other company in terms of resources, white papers, seminars and product launches.

Connection Oracle is primarily a technology infrastructure company for enterprise processing. Users want a secure structure, so we don't want to release anything until everything is ready for the production environment. Take a look at all the content provided by the Windows Development Center on the link to Oracle technology. We are very proactive.

This is the end of the content of "what are the considerations for connecting to Oracle". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.