使用jdbc连接访问在MSSQL服务器的dbo中创建的表 [英] Access tables which are created in dbo in MSSQL server using jdbc connection

问题描述

我已使用以下代码通过Java连接了MSSQL服务器

I have connect MSSQL server through java using following Code

Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DATABASENAME=;instanceName=MSSQLSERVER", "DB_USER_NAME", "DB_PASSWORD");

之后，我可以连接数据库并执行sql脚本，而无需给出任何对象名称.例如

After that I am able to connect database and execute sql script without giving any object name. for example

SELECT * FROM TEST_TABLE

现在，我有一些在dbo下创建的表，我想使用相同的连接访问它们. 我该如何处理? 我尝试过

Now, I have some tables which are got created under dbo and I want to access them using same connect. How Can I go with this? I have try with

SELECT * FROM dbo.TEST_TABLE1

但是它说该表不在数据库中.

but it says that this table is not there in database.

推荐答案

使您的数据库用户成为数据库所有者.

Make your DB user to the DB owner.

这篇关于使用jdbc连接访问在MSSQL服务器的dbo中创建的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！