我有一个虚拟机运行一个MsSQL数据库。 我之前使用的是Oracle数据库。 我的应用程序注入启动时的一些示例数据,我得到这个错误:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'springbootdb.users'.
data.sql
INSERT INTO "springbootdb"."users" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED, CURRENT_STATUS, POSITION_TITLE) VALUES ('1', '[email protected]', 'asdf', 'asdf', 'asdf', '12345', 0, 1, 'In Office', 'Advanced Developer'); INSERT INTO "springbootdb"."users" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED, CURRENT_STATUS, POSITION_TITLE) VALUES ('2', '[email protected]', 'asdf', 'asdf', 'asdf', '12345', 0, 1, 'In Office', 'Associate Developer'); INSERT INTO "springbootdb"."users" (USER_ID, EMAIL, FIRST_NAME, INITIAL_NAME, LAST_NAME, PASSWORD, ROLE, ENABLED, CURRENT_STATUS, POSITION_TITLE) VALUES ('3', '[email protected]', 'asdf', 'asdf', 'adsf', '12345', 1, 1, 'In Office', 'Line Manager');
application.properties
# MsSQL Connection spring.datasource.url=jdbc:sqlserver://11.11.111.1:1433;database=springbootdb; spring.datasource.username=admin spring.datasource.password=123! spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver spring.jpa.show-sql=true spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect spring.jpa.hibernate.ddl-auto=create-drop
我testing了确实有一个联系。 我也可以从一个SQL帐户从MSQLSMS访问数据库,如下图所示:
为什么我得到这个错误?
插入的表名应该是springbootdb.dbo.users