Freigeben über

JDBC to SQL Azure

  • Artikel

Using the open source jTDS JDBC Driver, you can connect to SQL Azure.

 

Driver class name: net.sourceforge.jtds.jdbc.Driver

Database URL: jdbc:jtds:sqlserver:// <server>. database.windows.net:1433/ <databasename> ;ssl=require

Username: (in the form username@server from SQL Azure)

 

The key thing is the “ssl=require” placed at the end of the connection string. SQL Azure SSL encrypts the data on the wire, and requires SSL. Which is rather a good thing.

Hope this saves someone some time.

Comments

  • Anonymous
    July 20, 2010
    Thank you for those information, it helps me to start working with Azure from our open source bpm java product. Regards Olivier

  • Anonymous
    February 08, 2011
    So, is jTDS an officially supported JDBC Driver?

  • Anonymous
    February 09, 2011
    Try the more recent msdn.microsoft.com/.../aa937724

  • Anonymous
    August 16, 2012
    Thank you very much for this. It saved me lots of time. Much appreciated.

  • Anonymous
    January 23, 2013
    i am using jtds 1.2 .jar for SQL Azure getting error like this any solution java.lang.Exception: Connection failed with unspecified error. at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:109) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:72) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:53) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355) at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76) at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

  • Anonymous
    January 24, 2013
    @ganapathi : has the IP address you are attempting to connect from been added to the Permitted IP addresses in the Firewall rules (SQL Azure)

  • Anonymous
    June 02, 2013
    The comment has been removed

  • Anonymous
    June 02, 2013
    The comment has been removed

  • Anonymous
    June 03, 2013
    The comment has been removed

  • Anonymous
    June 04, 2013
    As I am not deeply involved in this as I once was, I suggest popping over to msdn.microsoft.com/.../gg715284.aspx or www.windowsazure.com/.../java

  • Anonymous
    August 11, 2014
    -Djsse.enableCBCProtection=false is needed too -- that did the trick for me. See stackoverflow.com/.../connecting-to-azure-sql-db-via-jtds-on-an-android-device