连接到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.