Showing posts from December, 2010

SQL Developer DB2 Connection

SQL Developer 2.1.1 (and 3.0) supports browsing of IBM DB2 LUW 7, 8, 9 databases.
IBM DB2 iSeries and ZSeries Z/OS are not supported at this time.

To connect to DB2 LUW, SQL Developer first needs the correct JDBC driver.
Only one specific JDBC driver is supported.
db2jcc.jar with db2jcc_license_cu.jar

All other IBM drivers are not supported and may cause problems even if the above two drivers are specified. So best to only add the above two.

These drivers are usually found in your own DB2 database install or DB2 client install.
They are also available when you agree to the license (please check this first) and download IBMs DB2 Express-C database or Data Studio Standalone administration tools

Once you have a DB2 client or database installed you can search for the specific JDBC jar files.
db2jcc.jardb2jcc_license_cu.jarNote you cannot use db2jcc4.jar and this would cause issues if added to SQL Developers Third Party JDBC Drivers list…

SQL Server and Sybase Browsing

SQL Developer 3.0 (EA3) makes it easier to browse your SQL Server and Sybase servers.

All databases on your server are now available under the one connection, not just the default databases selected in the new connection dialog.

As long as your login has the privileges you can browse the objects in databases other than your default database.

When it comes to issuing commands/queries in the worksheet you can reference objects outside of the default database explicitly
SELECT * FROM databasename.owner.table1

or you can change the default database using a worksheet "hint"
/*sqldev:stmt*/USE databasename;
SELECT * FROM table1

or you can choose the default databases in the navigator

Note that the default is set for the life of the session only. If you want to change the default database permanently you can do this in the New Connection Dialog. Just right click the connection and choose Properties. Then click "Retrieve Databases", choose the default databases and click save.