Tips like this save a lot of time and improve productivity and that's why I have always said that a good understanding of Eclipse IDE is a must to become an expert Java J2EE developer and developers should spend some time learning their tools e.g. Choose JDBC Driver and specify its location.Create Connection Profile, Chose Oracle.Open Eclipse IDE and Select Database Perspective (Windows > Open Perspective > Other > Database Development).Here are the exact steps to connect the Oracle instance from Eclipse: The steps are exactly similar to what I have shown you before while connecting to Microsoft SQL Server from Eclipse IDE, here, the only difference is, this time, we are choosing Oracle from the list of databases and installing Oracle JDBC driver instead of SQL Server JDBC driver. Steps to connect Oracle database from Eclipse I am using Eclipse Java EE IDE for Web Developers, Version: Kepler Service Release 2.
Once you have these two things, we are ready to connect to any local or remote Oracle database instance from Eclipse IDE.
If you don't have one, you can download it from here. You can use any type of JDBC driver, but I prefer Oracle JDBC thin driver like ojdbc14.jar file to connect to Oracle 11g instance. You can download the latest version of Eclipse IDE for Java EE developers here.Ģ) Oracle JDBC JAR, since Eclipse uses JDBC to connect to the Oracle database it needs JDBC driver JAR for Oracle. In order to connect to the Oracle database instance, you need two things:ġ) Eclipse IDE for Java EE developers, because that contains the database development plugin which doesn't come along with Eclipse IDE for Java developers. Enter the username, password, and sid and you are ready to execute the SQL query to the Oracle database from Eclipse. Just download this JAR file and configure it on Eclipse IDE.
Oracle 10g or Oracle 11g you need to download Oracle JDBC thin driver like ojdbc14.jar file.
0 kommentar(er)
