SQL Developer

ORA SQL – Change Oracle SQL Developer Java Development Kit (jdk) executable file

 
ORA SQL – Change Oracle SQL Developer Java Development Kit (jdk) executable file_s001When you start SQL Developer for the first time you are prompted to select the Java Development Kit executable file.

On subsequent uses of SQL Developer it will run the selected jdk. If you want to change the specific jdk follow these steps:

1== Go to SQL Developer installation folder and open the file .\sqldeveloper\bin\sqldeveloper.conf

2== Replace SetJavaHome entry by setting a new jdk file path. Something like:

SetJavaHome C:\Program Files\Java\jdk1.7.0_21

3== Save file and restart SQL Developer


Tested With
Oracle Sql Developer 3.2.20.09.87 x64
Java Developer Kit 1.7.0 21

Categories: SQL Developer | Leave a comment

ORA SQL – Change Oracle SQL Developer default language

 
Follow these steps to change software startup language to English:

1== Go to SQL Developer installation folder and open file .\sqldeveloper\bin\sqldeveloper.conf

2== Add the following lines:


AddVMOption -Duser.language=en

AddVMOption -Duser.country=US

3== Save file and restart SQL Developer

 

Check supported languages

1== Go to SQL Developer installation folder and open file .\ide\bin\ide.boot

2== Check the line starting with oracle.translated.locales =…

        These are the product supported translation languages


Tested With
Oracle Sql Developer 3.2.20.09.87 x64

Categories: SQL Developer | Leave a comment

ORA SQL – Connect to SQL Server with Oracle SQL Developer

 
Follow these steps to setup the connection:

1== Download SQL Developer from Oracle web site (latest version)

        http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

2== Extract SQL Developer software to C:\Program Files\Oracle

3== Download JDBC driver for SQL Server Pluggin (jtds) from Sourceforge web site (latest version)

        http://sourceforge.net/projects/jtds/files/jtds/

4== Unzip jtds-x.x.x-dist.zip

        We will use 2 files: .\jtds-x.x.x.jar and .\x64\SSO\ntlmauth.dll

5== Copy the jtds-x.x.x.jar to C:\Program Files\Oracle\sqldeveloper\jlib\

6== Copy the ntlmauth.dll to C:\Program Files\Oracle\sqldeveloper\jdk\jre\bin\

7== Start SQL Developer

 ORA SQL – Connect to SQL Server with Oracle SQL Developer_s001

8== Go to Tools > Preferences

        Expand [+] Database option and choose Third Party JDBC Drivers

        Press Add Entry

        Browse and select the file C:\Program Files\Oracle\sqldeveloper\jlib\jtds-x.x.x.jar

9== Restart SQL Developer

 ORA SQL – Connect to SQL Server with Oracle SQL Developer_s002

10== You’re ready to generate a new SQL Server connection


In Depth
http://jtds.sourceforge.net/
http://docs.oracle.com/cd/E35137_01/index.htm

Tested With
Oracle Sql Developer 3.2.20.09.87 x64
JTDS 1.3.1 (x64)

Categories: SQL Developer, SQL management tools | Leave a comment

Blog at WordPress.com.