Solved

Need sample on how to acess Oracle using ojdbc14.jar

Posted on 2004-10-15
1
703 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help with my python script 6 178
How to find all the method available in a module in Python 1 106
Python - desktop use 1 57
Python Scrip in Windows Task Schedule 2 41
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…
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Suggested Courses

734 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