Solved

Need sample on how to acess Oracle using ojdbc14.jar

Posted on 2004-10-15
1
666 Views
Last Modified: 2012-06-27

Hi,

Need sample on how to acess Oracle using ojdbc14.jar

if at all posible.

TIA
0
Comment
Question by:eDias
1 Comment
 
LVL 11

Accepted Solution

by:
cjjclifford earned 250 total points
ID: 12337002
ojdbc14.jar is the JDBC thin client that is provided by Oracle (this is the equivalent for the old "classes12.zip"). To use this through Python is a little tricky - if you use Jython, then it should be straightforward enough (Create a java.sql.Connection, use that to create a java.sql.Statement, use that to executeQuery() on a SQL statement, which will return a java.sql.ResultSet, which can be used to go through the data.
If you are using C Python, then ojdbc14.jar is not the way to go... You should have a look at cx_Oracle, which is a Database access module conforming to the Python database API. (http://sourceforge.net/projects/cx-oracle/). You'll need the Oracle Client software installed to use this...

Documentation on using cx_Oracle is available here: http://starship.python.net/crew/atuining/cx_Oracle/html/index.html
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Plenty of writing has gone on the web trying to compare Python with other competitive programming languages and vice versa. However, not much has been put into a wholistic perspective. This article should help you decide whether to adopt Python as a…
Flask is a microframework for Python based on Werkzeug and Jinja 2. This requires you to have a good understanding of Python 2.7. Lets install Flask! To install Flask you can use a python repository for libraries tool called pip. Download this f…
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now