I know most databases have restrictions, but Postgres doesn’t. You can run any number table creations, column changes and index changes in a transaction, and the changes aren’t visible to other users unit COMMIT succeeds. That’s how databases should be! 🙂 As for SQL Server you can run DDL inside of a transaction, but SQL … Read more
They are distinct implementations. The jTDS driver is a type 4 and in my experience has better performance. I have been using the jTDS driver in a production environment without any issues for 5 years. I would recommend going with jTDS.
List of JDBC drivers for SQL Server 2008 (comparison) [closed]
As detailed in the jTDS Frequenlty Asked Questions, the URL format for jTDS is: jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;…]] So, to connect to a database called “Blog” hosted by a MS SQL Server running on MYPC, you may end up with something like this: jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS;user=sa;password=s3cr3t Or, if you prefer to use getConnection(url, “sa”, “s3cr3t”): jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS EDIT: Regarding your Connection … Read more