Oracle SQL Developer and jTDS Incompatibility

27 CommentsOracle

Some readers commented that, after they add JDBC driver for Microsoft SQL Server to their SQL Developer, the “New Connection” window (of SQL Developer) doesn’t open at all. I have downloaded the latest Java (1.6), SQL Developer and added jTDS driver then I have the same problem. I tried to debug the problem with my limited Java knowledge and I think there’s an incompatibility between jTDS and Java 1.6.

Oracle recommends to use Java 1.6 for SQL Developer so instead of trying Java 1.7, I tried to find the latest compatible version of jTDS and luckily I found it on my first try. So to fix the problem, all you need is to download and use 1.2.7 version of jTDS: jtds-1.2.7-dist.zip

Then you’ll be able to connect to Ms SQL Server or Sybase with your Oracle SQL Developer. For more information about using SQL Developer with Ms SQL Server and MySQL, please read my related blog post.

Please share
7     

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

27 Comments

    • Gokhan Atil

      Jeff, I don’t know which version they use but when you visit jTDS page, latest one is 1.3. So people probably tries to use 1.3 version and it doesn’t work with SQL Developer. I downloaded source codes and tried to compile jTDS under Java 1.6 but it didn’t work. In my tests, I see that 1.2.7 works fine with SQL Developer.

  6. Mike

    Reply

    Thank you — excellent work. I have Sqldeveloper3.2.20.09 (.87) working with jtds 1.3.0-dist.

  8. Brian

    Reply

    I wish this page came up higher on the Google search results. Most of blogs are old and were written before 1.3 came out and thus don’t know that the latest version doesn’t work. Lots of wasted time…. Luckily, 1.2.x is up and running for me now.

  9. joe

    Reply

    Thank you very much Gokhan. I have been fighting with this all afternoon. I should have known to check with GA first !!

  10. Alexander

    Reply

    Real help! Thanks.
    1.2.7 version of jTDS works with SqlDev 3.2.20.
    BTW Microsoft JDBC did not work with SqlDev 3.0.04 and Java 1.7, but it does with SqlDev 3.2.20.

  12. Sagar

    Reply

    Can you confirm if Oracle SQL Developer can be used to connect to Sybase IQ. Heard from someone that you can connect only to Sybase ASE. Is that correct ?

  16. senthil kumar

    Reply

    Hi dear, please assist me, iam facing problem unable to connect the Mssql server via sql dveloper tool , i tried to copied the jTDS but unabel to connect the mssql server uisng sql developer version 3.2.20

  20. AJkkcd

    Reply

    Can someone give an example of what to put in the hostname and port for connecting to SQL Server Express?  I have SQL Developer 3.2.20.09 and jtds 1.2.7 and it won’t connect.  I do have the SQL Server tab.

  22. RHOC

    Reply

    Hi Gokhan and Jeff,

    Thanks for both of your combined Blog & Infos. Keep up the Blogs on your respective websites. 🙂

    Realizing there was previously a bug or java problem.

    However here’s an update for SQL Developer Version 4.0.0.13 works fine with the
    jtds-1.3.1.jar from the jtds-1.3.1-dist.zip distribution and the below mentioned Oracle VirtualBox VM setup.

    In new Database connection pop-up window shows the SQLSever and Sybase Tab
    [oracle@localhost projects]$ java -version
    java version “1.7.0_51”
    OpenJDK Runtime Environment (rhel-2.4.4.1.0.1.el6_5-x86_64 u51-b02)
    OpenJDK 64-Bit Server VM (build 24.45-b08, mixed mode)

    [oracle@localhost Downloads]$ uname -rm
    3.8.13-16.2.1.el6uek.x86_64 x86_64
    [oracle@localhost Downloads]$ cat /etc/redhat-release
    Red Hat Enterprise Linux Server release 6.5 (Santiago)

    Greetings,
    RHOC

  23. Ajay

    Reply

    Not working for  Version 4.2.0.16.356
    will try lower version and update you soon
    Thanks BTW.

  24. Aretm

    Reply

    Hello! I setup the JDTS to Oracle Developer (ver. 4-1-5, ver. 4-1-1, ver. 1-5-0) on Ubuntu. All worsk, i can create MS SQL tables and view MS SQL table data. But i cant insert data raws on MS SQL connection databases (on Oracle bases its works). When i click on data when exploring the table, i see the data, but i cant see any icon: add data, delete data, commit changes and e.g, like typically in Oracle bases. Just SQL query can insert data to table from Oracle Developer. And with that problem i doesn’t see MS SQL connection at the Export Tools on Oracle Developer, i see only Oracle BD connection when trying export all MS SQL databese.

Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.