Almost every time I try to connect to SQL Server from Java I end up hacking something together, like copy-pasting the connection string from an old project; then again, more often than not I end up getting some sort of error and spending quite sometime Googling. So I spent sometime trying to understand the different... Continue Reading →
Connecting to SQL Server using jTDS
There are a few posts around on the internet explaining how to connect to SQL Server from Java. The most popular is probably using the JDBC driver (http://msdn.microsoft.com/en-us/sqlserver/aa937724), but somewhere I read that for bulk insertions the jTDS driver (http://jtds.sourceforge.net/) is faster. I’m trying to insert some SNOMED related data into SQL Server (started with... Continue Reading →