I am a final year student studying Business Info Systems in DIT, Ireland. As part of our course I have to design a final year project. I have my idea but am unsure of how I actually go about doing it. I am designing a software application wriiten in C/C++ and would like to have an Oracle database in the background storing all old and newly processed data. My software application will be the end-user interface, while my database does all the storage.
My problem is that I am totally clueless on how I link up the two objects (database & software application). I would be extremely grateful if you could point me in the right direction. Thanks for your time, and I look forward to hearing from you in the near future.
To link an application program to an Oracle database, you some sort of interface. How this is done depends on your application programming language. For instance, Perl programs will use the Oracle DBI module. C++ programs can use Oracle's Pro*C precompilers or the Oracle Call Interface (OCI). Java programs use JDBC drivers and java SQL packages. Each method is slightly different, so you'll have to look up documentation for each. You can find many resources on Oracle's Technet site. You'll need to register for an account, but it is free. There, you will find many code samples, especially for C++ and Java development platforms.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.