SQL Developer - The Universal Database Frontend


Frequently Asked Questions


Where is the installer?

We deliver the application without any installer because you don't really need one. After unpacking the downloaded archive the program can be started directly from your harddisk, a CD, a USB memory stick or any other removable media. This enables you to take SQL Developer with you and to start the application even in a more restrictive environment that disallows user made installations. The Download section describes how to start the program on the different operating systems.

How do I connect to my favorite database?

If you want to establish an ODBC connection you can use the JDBC-ODBC bridge supplied by the Sun Microsystems JRE. For other connection types you will have to get the suitable JDBC driver for your database. See Drivers.

What is JDBC?

JDBC (Java DataBase Connectivity) technology is an API that provides cross-database connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment. Today all major databases provide JDBC drivers for access.

Why does the navigator tree not look the same for every database?

In principle SQL Developer supports any database connected via JDBC. For some databases special features are supported but not covered by the JDBC interface. Oracle for example supports packages, package bodies, tablespace and rollback segment information etc.

Why do I get an error when starting SQL Developer?

You will encounter a java.lang.UnsupportedClassVersionError on startup if you try to run SQL Developer with a Java Runtime Environment prior to JRE 1.4. You can determine the version number of the JRE installed on your machine by typing java -version into a shell window. SQL Developer requires JRE 1.4.2 or higher to run.

To download the latest Java release for your system, see Download.

Can I use 3rd party Look and Feels in SQL Developer?

Yes, the application provides support for additional Look and Feels. See Look and Feel to learn how to activate your favorite look and feel.

How do I increase the memory for the Java Virtual Machine?

Usually the default memory configuration of your VM should be sufficient to work with SQL Developer. If you want to increase the available memoy anyway you will have to start the application with additional command line options.

If you use a Sun Microsystem Java VM open a shell window, change to the SQL Developer folder and type java -Xmx256m -jar sqldeveloper.jar to start with a maximum heap memory of 256 MB. The default maximum heap size is 64 MB.

If you use another VM please refer to the vendor's VM specification to get the analogous command line option.