1) First we need to download JDBC drivers. I select ojdbc14.jar under Oracle9.2.0.1.
2)Creating a DSN, for this goto Controlpannel->administrative tools->ODBC->userDSN->add ->enter the DSN name: cnya(myname)
TSN name: orcl(what we gave at the time of oracle installation)-> OK.
3)In Eclipse, after creating a new project -> right click on projname-> properties -> select Java Buildpath-> Add External Jars-> enter the downloaded jar file path -> Ok
It adds the external jdbc jars to our project.
4)Loading and Connecting to OracleDriver(thin driver).
I use thin driver bcoz it is fast comparatively with the remaining drivers in our local machine.

Hi,vchaithanya!
I hope you are still checking your blog. I realy want to thank you for your most appreciated tips regarding JDBC in Eclipse. Believe it or not, I have been trying to fix this for almost a week now. I have searched the web for a tip or two like never before. When I was about to give up, I came across your tips. And guess what, all the problems I have had to deal with in Eclipse and JDBC are now gone! My java applikation is doing exactly what it is supposed to do thanks to your tips. I wish you all the best and success in your endeavours.

Do you have a website dedicated just for JDBC and Eclipse? I would like to learn more about this subject. My desire is to develope a full fledged java application in Eclipse and Oracle DB as data sorce. Thank you once more! Dani.