• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 727
  • Last Modified:

Need sample on how to acess Oracle using ojdbc14.jar


Need sample on how to acess Oracle using ojdbc14.jar

if at all posible.

1 Solution
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now