Hi Everyone,

can any one tell me how would i configure/attach JDBC drivers pertaining to MySQL and Oracle for Jython ?

I have the following code..
#######################################
import java
from java.sql import DriverManager

class DBAdapter:
    def __init__(self):
        conString = "jdbc:mysql://localhost:3306/test"   
        self.db = DriverManager.getConnection(conString,"root","root")
        print "DB Connection established"
    def __del__(self):
        if not self.db.isClosed():
            self.db.close()
   
dbConn = DBAdapter();
#######################################

but when run gives me the following error


Traceback (innermost last):
  File "dbadapter.py", line 13, in ?
  File "dbadapter.py", line 7, in __init__
    at java.sql.DriverManager.getConnection (Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
java.sql.SQLException: java.sql.SQLException: No suitable driver


Could any one throw some light.. or direct me to suitable resources(URLs) over net

--
DREAM IT, DO IT