The release V4.0 of sql developer is available for download : oracle.com/technetwork/developer-tools/sql-developer/downloads
The doc is there : docs.oracle.com/cd/E39885_01/index.htm
And read Jeff Smith twit’s and blog
I requested some time ago a 64bit Windows version with JDK on Oracle SQL Developer Exchange and once again it got accepted.
Okay, I have on my PC two Oracle homes : one for 32 bits and one for 64 bits. The 32 bits is first in PATH.
When I start SQL Developer, I could not use the OCI thick driver which is required when connecting via LDAP or TNSNAMES. SQL Developer was failing with error :
ocijdbc11.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform
Apart from changing the path in the Environment variables or in .bat file, it is possible to add the following line in sqldeveloper/bin/sqldeveloper.conf (where dbhome_2 is a 64bits home):
AddVMOption -Djava.library.path=C:\oracle\product\12.1.0\dbhome_2\bin
If you need to connect to Sybase ASE (or MSSQL), download the driver here : http://sourceforge.net/projects/jtds and add it as Datasbase/Third-Party Driver
For MySQL go there : http://dev.mysql.com/downloads/connector/j/ and download the Platfrom Independant ZIP file.
I tried using your instructions to make Oracle SQL Developer point to Oracle 10.2 64 bits, but I am getting another error. Is it possible to make Oracle Developer to work with an specific version of Oracle? Here you can see all the information of my issue: http://dba.stackexchange.com/questions/83806/how-to-connect-to-oracle-with-sql-developer-and-oracle-10.
Thanks!
Might be worth mentioning that you can copy sqldeveloper.conf to %APPDATA%\sqldeveloper\[version] if the original is in a read-only folder. Also in later versions there is a option to set the path for the Oracle Client in Tools > Preferences > Database > Advanced, although it seems sqldeveloper.conf is still useful for overwriting the default java.library.path.
Indeed setting up oracle client doesn’t solve the 32/64 bit confusion… sql dev shall look in registry not in path for the home.
Thanks for the hint about appdata, very usefull indeed