连接到SQL Server localdb JDBC [英] Connect to SQL Server localdb JDBC

问题描述

我在系统上安装了Microsoft SQL Server 2012 Express localdb .

I installed Microsoft SQL Server 2012 Express localdb on my system.

在创建(并启动)具有数据库(db1)的实例(测试)之后，我尝试连接Java应用程序.

After I created (and started) a Instance (Test) with an database (db1) I tried to connect with my java-Applikation.

驱动程序为"com.microsoft.sqlserver.jdbc.SQLServerDriver".

The driver ist "com.microsoft.sqlserver.jdbc.SQLServerDriver".

我的连接字符串是"jdbc:sqlserver://(localdb)\ Test; databaseName = db1; schema = db1;"

My connection-string is "jdbc:sqlserver://(localdb)\Test;databaseName=db1;schema=db1;"

错误(已截断): java.net.UnknownHostException:'(localdb)'命名实例'Test' 检查UDP端口1434 检查是否启动了SQL Server浏览器服务

Error (truncated): java.net.UnknownHostException: '(localdb)' named instance 'Test' Check UDP Port 1434 Check if SQL Server browser-Service is started

我的.NET Framework版本是4.0.2

My .NET Framework Version is 4.0.2

'SQLCMD.EXE -S(localdb)\ Test'工作正常.

'SQLCMD.EXE -S(localdb)\Test' works fine.

我该如何解决这个问题?

How can I solve this problem?

推荐答案

Microsoft SQL Server JDBC驱动程序不支持localDB.参见评论

The Microsoft SQL Server JDBC driver does not support localDB. See the comment http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx#10250447

Krzysztof Kozielczyk-MSFT 2011年12月22日上午11:10 #

Krzysztof Kozielczyk - MSFT 22 Dec 2011 11:10 AM #

@查尔斯·斯坦顿(Charles Stanton)

@Charles Stanton

不幸的是，JDBC驱动程序目前不支持LocalDB，并且 没有简单的解决方法.团队知道这种失踪 功能，但提交连接项始终有助于DCR跟踪 和优先级.

Unfortunately JDBC driver doesn't support LocalDB at this moment and there is no easy workaround. The team is aware of this missing feature, but filing a connect item is always helpful for DCR tracking and prioritization.

谢谢

-Krzysztof

-Krzysztof

如使用JDBC连接到SQL Server LocalDB中的答案所解释的那样，可以使用jTDS驱动程序来做到这一点.

As explained by an answer in Connecting to SQL Server LocalDB using JDBC, it is possible to do this using the jTDS driver.

这篇关于连接到SQL Server localdb JDBC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！