产生的原因:com.microsoft.sqlserver.jdbc.SQLServerException:无效的对象名称springboot.USERS“
问题描述:
我想一些样本SQL数据插入到在运行时我Springboot应用:产生的原因:com.microsoft.sqlserver.jdbc.SQLServerException:无效的对象名称springboot.USERS“
INSERT INTO "springboot"."USERS" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED) VALUES ('1', '[email protected]', 'asdf', 'asdf', 'asdf', '12345', 0, 1);
INSERT INTO "springboot"."USERS" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED) VALUES ('2', '[email protected]', 'asdf', 'asdf', 'asdf', '12345', 0, 1);
INSERT INTO "springboot"."USERS" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED) VALUES ('3', '[email protected]', 'asdf', 'asdf', 'asdf', '12345', 0, 1);
INSERT INTO "springboot"."USERS" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED) VALUES ('4', '[email protected]', 'asdf', 'asdf', 'XXX', '12345', 1,
INSERT INTO "springboot"."REQUEST" (REQUEST_ID, DESCRIPTION, REQUEST_DATE, STATUS, USER_ID) VALUES ('1', 'TEST', TO_TIMESTAMP('2017-02-09 08:56:29.722000000', 'YYYY-MM-DD HH24:MI:SS.FF'), '1', '1');
例外:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'springboot.USERS'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)
at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:471)
什么我收到错在这里?以下是什么格式?
INSERT INTO "springboot"."USERS"
INSERT INTO "databaseName"."table" ?
INSERT INTO "dbAdmin"."table" ?
答
检查您的SQL连接,确保您连接到正确的服务器和数据库。
答
检查您用来连接数据库的用户是否有权访问此数据库。
绝对连接。 – santafebound
@santafebound您是否可以冒险尝试从SSMS插入声明?在相同的数据库连接?如果连接到正确的数据库,请尝试刷新'Tables'目录,查看这些表是否存在,或者仔细检查数据库是否存在于您连接的服务器实例上。 – LONG