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

sunzoutao

The easiest way is to delete this table and rebuild it. Maybe the problem will be solved. I have encountered such a problem before, but it is not in java. It is done directly in the query analyzer and deleted the table. It can be used after rebuilding, and I haven't figured out why until now, which expert can give pointers!

cm200red

But the problem is, I have no problem querying this in the query analyzer.

It is invalid when querying in java.

moxianran

Simply change the name of the table below.
Databases with user fields often have such errors
And with name

yangzidong

Has it been solved? I have encountered the same problem?
I use jdbc:jtds to connect to the database

yangzidong

I solved it. The reason was that there was a problem when connecting. Modify the connection to the database:
For example: "jdbc:jtds:sybase://10.200.4.193:5000; DatabaseName=GOLDSIGN"
Change to: "jdbc:jtds:sqlserver://127.0.0.1:1433/GOLDSIGN";

kingcw418

What's the difference!

jy02191569

Haha, beginners are generally very careless

spirit625

UserInfo may be some spare, special characters in the database, so try to use those strings as table names and field names as little as possible!
Create a new one! Addition tb_userInfo

player33

Of course, copying directly to java is not enough.The string copied is inconsistent with the statement you execute in the query analyzer.

Modify your query statement to be similar to the following statement
str = "SELECT id from userInfo where name = "+'strwww'+" and password = "+str00000;

笨笨塞

Adding the use database name before the query statement can solve this problem