How do I connect to a SQL Server 2008 database using JDBC?

by

There are mainly two ways to use JDBC – using Windows authentication and SQL authentication. SQL authentication is probably the easiest. What you can do is something like:

String userName = "username";
String password = "password";

String url = "jdbc:sqlserver://MYPC\\SQLEXPRESS;databaseName=MYDB";

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url, userName, password);

after adding sqljdbc4.jar to the build path.

For Window authentication you can do something like:

String url = "jdbc:sqlserver://MYPC\\SQLEXPRESS;databaseName=MYDB;integratedSecurity=true";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url);

and then add the path to sqljdbc_auth.dll as a VM argument (still need sqljdbc4.jar in the build path).

Please take a look here for a short step-by-step guide showing how to connect to SQL Server from Java using jTDS and JDBC should you need more details. Hope it helps!

More Related Contents:

  1. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  2. How to pass Table-Valued parameters from java to sql server stored procedure?
  3. JDBC connection failed, error: TCP/IP connection to host failed
  4. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  5. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  6. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  7. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  8. JPA SQL Server No Dialect mapping for JDBC type: -9
  9. Native Library sqljdbc_auth.dll already loaded in another classloader
  10. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  11. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  12. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  13. How to get *everything* back from a stored procedure using JDBC
  14. Getting the Return Value from JDBC MSSQL
  15. no sqljdbc_auth in java.library.path
  16. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  17. The TCP/IP connection to the host localhost, port 1433 has failed
  18. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  19. Must JDBC Resultsets and Statements be closed separately although the Connection is closed afterwards?
  20. MySQL and JDBC with rewriteBatchedStatements=true
  21. How to connect SQLite with Java?
  22. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  23. PLSQL JDBC: How to get last row ID?
  24. Is asynchronous jdbc call possible?
  25. Setting Network Timeout for JDBC connection
  26. how to get list of Databases “Schema” names of MySql using java JDBC
  27. NamedParameterJdbcTemplate vs JdbcTemplate
  28. Access denied for user ‘root’@’localhost’
  29. Oracle JDBC : invalid username/password (ora-01017)
  30. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values

Leave a Comment