com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 无效

[chunci99]

谁遇到这样的问题啦,或是以解决这样的问题,请分享下你的经验吧~大家来讨论
我的sql 语句是:
sql = "SELECT * FROM Lperson WHERE name=? and password=?";

下面是错误提示:
com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'Lperson' 无效
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at org.apache.jsp.login_005fconf_jsp._jspService(login_005fconf_jsp.java:99)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
at java.lang.Thread.run(Thread.java:619)

[jinjazz]

对象名 无效
你的sql语句有问题

[chunci99]

sql语句问题出在哪里呢??

[jinjazz]

Lperson这个表没有吧

[chunci99]

这个表存在的,执行插入也没问题,

[jinjazz]

我觉得你数据库连错了，既然报错他不存在一定是不存在的

[chunci99]

那我再回去看看哪里有问题,谢谢你!

[llpoo]

sql = "SELECT * FROM Lperson WHERE name=? and password=?";
改成
sql = "use [数据库名] SELECT * FROM Lperson WHERE name=? and password=?";

[xmmlanya]

7 楼正解， 需要指定数据库

[zy_love]

你看一下你的
连接语句

DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=tableName");

看一下红色指定的数据库里，是否有你要查询的表

[zy_love]

你看一下你的
连接语句

DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=tableName");

看一下红色指定的数据库里，是否有你要查询的表

[Hacimfy]

我也遇到了相同的问题，在你写的语句前面指定数据库名字就可以了。

[lovedahai123]

我刚遇到这个问题，不知道怎么解救

[abuying]

sql = "SELECT * FROM Lperson WHERE name=? and password=?";  
改成
sql = "use [数据库名] SELECT * FROM Lperson WHERE name=? and password=?";
--a或者
sql = "SELECT * FROM [数据库名].dbo.[Lperson] WHERE name=? and password=?"; 

[zhixulong]

很好啊，我也找到了，哈哈谢谢