DB connectivity help needed. Python or Java

[reef_d]

Does anyone have good links to Database connectivity in Python?

Also I am working on a JDBC program. The program has to create tables, insert and query an oracle database. I've made sql files for the same and plan on using file I/O for each of the required functions. How do i go about executing the all the lines of the sql file? Should i store each Create/Insert command in a String array (doesn't sound feasible) or use the StringBuffer? What would be a good strategy to follow? I'm quite a n00b with JDBC and kinda loathe Databases (more of a network security guy) so any help would be appreciated.

Thanks in advance

 

[qxsilvr]

what IDE are u using?

 

[qxsilvr]

Does this application have to constantly create new tables?
If no..
Manually create tables in ur DB.
Using JDBC calls make insert/update/query ur tables.
Store ur queries in String/StringBuffers.

 

[Amol]

Python - Oracle FAQ

 

[random2]

You can also try SQLAlchemy -> SQLAlchemy - The Database Toolkit for Python

One of the most commonly used DB connectivity tool in Python.

 

[reef_d]

thanks guys