Java query SQLServer encountered a problem: the object name is invalid.

liyezxs

Are there keywords in the table?
Ha ha

55924321

java.sql.SQLException: [Microsoft][SQLServer Driver for JDBC][SQLServer] object name ‘xxx’ is invalid


root cause:

The user who accesses the database has login permission, but no permission to operate the table

Solution:

1. In the [Enterprise Console] window-[Tree] sub-window-[Security] sub-tree-[Login] item, set the default database of the login user you use to the database you use.

2. Add a login user in the [Enterprise Console] window-[Tree] sub-window-[Security] sub-tree-[Login] item (select SQL Server authentication, server role and database to be accessed) , Some new users will be able to access the database you selected in the future.

I also encountered the problem of the original poster, and I felt like crying without tears, and finally solved it with this method! ! ! ! ! ! ! ! ! !

bigr0427

Explain that there is no such table

cjgooo222

The default database is wrong

zxlwbi199101

That's right, it is to modify the default database of the logged in user! But why is this? The name of the database is clearly indicated in the url! why? ? ?
[color=#FF0000]Solve...[/color]

penda110

I just encountered this problem, because the user of the current database does not have permission. Select the table you want to operate, right-click and select properties, then click permissions, and then check the permissions that your user needs.

heiselingdai

The landlord must have written the wrong name of the database used to connect java to sql server.

huxiabingbig

Generic error.

Write this statement in SQL
use database name

Run OK

wanglong8013

Just follow the55924321approach! ! ! Thanks a lot! ! ! ! ! ! ! ! !

tj2005626

When a non-sysadmin fixed server role member (non-DBA user) creates a new database object in the query analyzer or program (asp, vb, etc.), the owner of the database object is the current logged-in user. If the program is changed to run as a DBA or other identity the next time, it will prompt that the database object cannot be found.

For example: If the user Andrew is not a member of the fixed server role sysadmin, but only a member of the fixed database role db_owner, and creates the table T1, then T1 belongs to Andrew and is limited to Andrew.T1. Other users need to add the owner in front of the table when using SQL statements in the query analyzer or program to access the table:

                  select * from Andrew.T1

               But not directly

                  select * from T1

                   Otherwise, you will be prompted that the table object cannot be found.
In the [Enterprise Console] window-[Tree] sub-window-[Security] sub-tree-[Login] item, set the default database of the login user you use to the database you use.
Server role: system administrator cannot be checked, otherwise the owner must be added when querying the table. (Select * from Andrew.T1)