TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Open Sourcing the Microsoft JDBC Driver and Maven Support

147 pointsby careyover 8 years ago

11 comments

sehropeover 8 years ago
Finally!<p>Having dealt with <i>many</i> database drivers over the years, I can say first hand that closed source drivers are the bane of my existence. The only thing worse than running into a deep-in-the-stack bug in a database driver is one that you can&#x27;t correct, let alone debug properly.<p>Regardless of your views on closed source software on the server side of things, it&#x27;s a disservice to your customers to not have open source client side drivers. The secret sauce is always on the server side so it doesn&#x27;t buy you anything. At best there&#x27;s (very poor) argument for security through obscurity or you&#x27;re doing something silly like hiding server side features behind client side feature flags.<p>Plus the more tech savvy of your users will directly contribute back to improve the driver. This is both for fixing existing bugs and adding features to support existing database server features. In this particular case, I&#x27;ve got a laundry list of things I&#x27;d like corrected &#x2F; added &#x2F; improved in the SQL Server JDBC driver. Had it been open sourced a few years back, I would have already done them myself.<p>Unless there&#x27;s a legal restriction for not doing so, like say not owning the original source, there&#x27;s no good reason not to open source the client side of things.
评论 #12986850 未加载
评论 #12990274 未加载
ysleepyover 8 years ago
Yay... Isnt everyone using jTDS anyway because it is reliably faster?<p><a href="https:&#x2F;&#x2F;social.msdn.microsoft.com&#x2F;Forums&#x2F;en-US&#x2F;36e7b9cf-5bc5-445d-874c-1d6f8e819b63&#x2F;ms-jdbc-driver-performance-observations-versus-jtds?forum=sqldataaccess" rel="nofollow">https:&#x2F;&#x2F;social.msdn.microsoft.com&#x2F;Forums&#x2F;en-US&#x2F;36e7b9cf-5bc5...</a><p><a href="http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;7848213&#x2F;why-is-jtds-faster-than-microsoft-jdbc-driver" rel="nofollow">http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;7848213&#x2F;why-is-jtds-faste...</a><p>Edit: seems like they fixed their abysmal performance after 5years in jan 2016; see stackoverflow comment.
评论 #12988059 未加载
评论 #12989016 未加载
评论 #12989199 未加载
评论 #12989138 未加载
farnulfoover 8 years ago
Static code analysis with SonarQUBE : <a href="https:&#x2F;&#x2F;sonarqube.com&#x2F;dashboard&#x2F;index?id=com.microsoft.sqlserver%3Amssql-jdbc" rel="nofollow">https:&#x2F;&#x2F;sonarqube.com&#x2F;dashboard&#x2F;index?id=com.microsoft.sqlse...</a>
hugiover 8 years ago
Yay! Just… Yay!<p>Now it&#x27;s your turn, Oracle.
评论 #12986217 未加载
评论 #12987314 未加载
0xmohitover 8 years ago
Nice. Microsoft seems to be open-sourcing a fair bit of stuff lately.<p>However, unlike their other repos there are a couple of things that strike out. The code isn&#x27;t even consistently formatted. There are parts that make you say ouch.
评论 #13004101 未加载
maaaatsover 8 years ago
How did people use this before if it wasn&#x27;t in the Maven Central Repo?<p>I know it&#x27;s <i>possible</i> to not use mvn, just wondering what people did in cases like this where a possibly major component in the stack was unavailable. Most big stuff in Java can be found in mvn, and if not we often end up using an alternative. But that&#x27;s not so easy for a driver.
评论 #12989364 未加载
评论 #12987563 未加载
评论 #12989847 未加载
评论 #12994881 未加载
userbinatorover 8 years ago
Microsoft has been open-sourcing a lot lately, but it seems to be mostly &quot;peripheral&quot; software...<p><i>The JDBC driver can be used to connect to SQL anywhere. Use it to connect to SQL Server (on-prem or in the cloud), Azure SQL Database, and Azure SQL Data Warehouse.</i><p>...associated with the use of their commercial products.
评论 #12986305 未加载
评论 #12986466 未加载
haddrover 8 years ago
Oh, this driver was really troublesome!<p>I remember we had once revert to java 6, because we couldn&#x27;t get connectivity in Java 7 with SQL Server through their JDBC Driver... It took days to figure it out...
SloopJonover 8 years ago
This is really cool. I&#x27;d like to see a lot more in the test directory, though. Can any MSFTies here describe how this is tested?
Akonkagvaover 8 years ago
wooohoo... 20 years later
cobookmanover 8 years ago
First off kudos to microsoft for open sourcing their JDBC driver.<p>I would have figured microsoft would have used a linter to fix style issues with their code before Open Sourcing. E.x: <a href="https:&#x2F;&#x2F;github.com&#x2F;Microsoft&#x2F;mssql-jdbc&#x2F;blob&#x2F;master&#x2F;src&#x2F;main&#x2F;java&#x2F;com&#x2F;microsoft&#x2F;sqlserver&#x2F;jdbc&#x2F;SQLServerColumnEncryptionJavaKeyStoreProvider.java#L81" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;Microsoft&#x2F;mssql-jdbc&#x2F;blob&#x2F;master&#x2F;src&#x2F;main...</a><p>Anyone know if microsoft is going to specify their java style guide.
评论 #12986551 未加载
评论 #12986220 未加载
评论 #12987742 未加载