连接SQLsever有问题，两个数据库都建立了，连接时提示有字段找不到。

Connected to the target VM, address: '127.0.0.1:10296', transport: 'socket'
Application Version: 3.1.0
Spring Boot Version: 2.2.13.RELEASE
////////////////////////////////////////////////////////////////////
// start //
////////////////////////////////////////////////////////////////////
13:52:11.202 [background-preinit] INFO o.h.v.i.util.Version - [,21] - HV000001: Hibernate Validator 6.0.22.Final
13:52:11.232 [restartedMain] INFO c.r.RuoYiApplication - [logStarting,55] - Starting RuoYiApplication on PF3VG6YF with PID 27800 (E:\RUOYI\ruoyi-sqlserver-master\ruoyi\ruoyi-admin\target\classes started by L230421 in E:\RUOYI\ruoyi-sqlserver-master\ruoyi)
13:52:11.233 [restartedMain] DEBUG c.r.RuoYiApplication - [logStarting,56] - Running with Spring Boot v2.2.13.RELEASE, Spring v5.2.12.RELEASE
13:52:11.233 [restartedMain] INFO c.r.RuoYiApplication - [logStartupProfileInfo,655] - The following profiles are active: druid
13:52:12.589 [restartedMain] INFO o.a.c.h.Http11NioProtocol - [log,173] - Initializing ProtocolHandler ["http-nio-8080"]
13:52:12.590 [restartedMain] INFO o.a.c.c.StandardService - [log,173] - Starting service [Tomcat]
13:52:12.590 [restartedMain] INFO o.a.c.c.StandardEngine - [log,173] - Starting Servlet engine: [Apache Tomcat/9.0.41]
13:52:12.591 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - Loaded Apache Tomcat Native library [1.2.39] using APR version [1.7.4].
13:52:12.591 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
13:52:12.591 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
13:52:12.595 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - OpenSSL successfully initialized [OpenSSL 3.0.11 19 Sep 2023]
13:52:12.649 [restartedMain] INFO o.a.c.c.C.[.[.[/] - [log,173] - Initializing Spring embedded WebApplicationContext
13:52:12.982 [restartedMain] DEBUG c.r.f.s.f.JwtAuthenticationTokenFilter - [init,242] - Filter 'jwtAuthenticationTokenFilter' configured for use
13:52:14.216 [restartedMain] INFO c.a.d.p.DruidDataSource - [init,994] - {dataSource-1} inited
13:52:14.220 [restartedMain] DEBUG c.r.s.m.S.selectConfigList - [debug,159] - ==> Preparing: select config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark from sys_config order by 1
13:52:14.243 [restartedMain] DEBUG c.r.s.m.S.selectConfigList - [debug,159] - ==> Parameters:
13:52:14.261 [restartedMain] DEBUG c.r.s.m.S.selectConfigList - [debug,159] - <== Total: 3
13:52:14.333 [restartedMain] INFO i.l.c.EpollProvider - [,68] - Starting without optional epoll library
13:52:14.334 [restartedMain] INFO i.l.c.KqueueProvider - [,70] - Starting without optional kqueue library
13:52:14.685 [restartedMain] DEBUG c.r.s.m.S.selectDictTypeAll - [debug,159] - ==> Preparing: select dict_id, dict_name, dict_type, status, create_by, create_time, remark from sys_dict_type
13:52:14.686 [restartedMain] DEBUG c.r.s.m.S.selectDictTypeAll - [debug,159] - ==> Parameters:
13:52:14.698 [restartedMain] DEBUG c.r.s.m.S.selectDictTypeAll - [debug,159] - <== Total: 10
13:52:14.704 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.799 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_user_sex(String)
13:52:14.809 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 3
13:52:14.831 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.832 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_show_hide(String)
13:52:14.840 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.849 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.849 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_normal_disable(String)
13:52:14.858 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.865 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.865 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_job_status(String)
13:52:14.875 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.885 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.885 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_job_group(String)
13:52:14.899 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.916 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.918 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_yes_no(String)
13:52:14.929 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.937 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.937 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_notice_type(String)
13:52:14.946 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.960 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.961 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_notice_status(String)
13:52:14.969 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:14.981 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:14.982 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_oper_type(String)
13:52:14.991 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 9
13:52:14.999 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Preparing: select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark from sys_dict_data where status = '0' and dict_type = ? order by dict_sort asc
13:52:15.000 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - ==> Parameters: sys_common_status(String)
13:52:15.007 [restartedMain] DEBUG c.r.s.m.S.selectDictDataByType - [debug,159] - <== Total: 2
13:52:15.240 [restartedMain] INFO o.q.i.StdSchedulerFactory - [instantiate,1220] - Using default implementation for ThreadExecutor
13:52:15.248 [restartedMain] INFO o.q.c.SchedulerSignalerImpl - [,61] - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
13:52:15.249 [restartedMain] INFO o.q.c.QuartzScheduler - [,229] - Quartz Scheduler v.2.3.2 created.
13:52:15.252 [restartedMain] INFO o.q.c.QuartzScheduler - [initialize,294] - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'RuoyiScheduler' with instanceId 'PF3VG6YF1705384335241'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.

13:52:15.253 [restartedMain] INFO o.q.i.StdSchedulerFactory - [instantiate,1374] - Quartz scheduler 'RuoyiScheduler' initialized from an externally provided properties instance.
13:52:15.253 [restartedMain] INFO o.q.i.StdSchedulerFactory - [instantiate,1378] - Quartz scheduler version: 2.3.2
13:52:15.254 [restartedMain] INFO o.q.c.QuartzScheduler - [setJobFactory,2293] - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2c4af9e5
13:52:17.340 [restartedMain] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - [refresh,559] - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysJobController': Unsatisfied dependency expressed through field 'jobService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysJobServiceImpl': Invocation of init method failed; nested exception is org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Invalid object name 'QRTZ_LOCKS'. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'QRTZ_LOCKS'.]
13:52:17.340 [restartedMain] INFO o.q.c.QuartzScheduler - [shutdown,666] - Scheduler RuoyiScheduler_$PF3VG6YF1705384335241 shutting down.
13:52:17.341 [restartedMain] INFO o.q.c.QuartzScheduler - [standby,585] - Scheduler RuoyiScheduler$PF3VG6YF1705384335241 paused.
13:52:17.341 [restartedMain] INFO o.q.c.QuartzScheduler - [shutdown,740] - Scheduler RuoyiSchedulerPF3VG6YF1705384335241shutdowncomplete.13:52:17.342[restartedMain]INFOsys−user−[shutdownAsyncManager,31]−====关闭后台任务任务线程池====13:52:17.343[restartedMain]WARNo.s.c.a.CommonAnnotationBeanPostProcessor−[postProcessBeforeDestruction,185]−Destroymethodonbeanwithname′shutdownManager′threwanexception:java.lang.ExceptionInInitializerError13:52:17.345[restartedMain]INFOc.a.d.p.DruidDataSource−[close,2029]−dataSource−1closing...13:52:17.347[restartedMain]INFOc.a.d.p.DruidDataSource−[close,2101]−dataSource−1closed13:52:17.482[restartedMain]INFOo.a.c.c.StandardService−[log,173]−Stoppingservice[Tomcat]13:52:17.501[restartedMain]ERRORo.s.b.SpringApplication−[reportFailure,826]−Applicationrunfailedorg.springframework.beans.factory.UnsatisfiedDependencyException:Errorcreatingbeanwithname′sysJobController′:Unsatisfieddependencyexpressedthroughfield′jobService′;nestedexceptionisorg.springframework.beans.factory.BeanCreationException:Errorcreatingbeanwithname′sysJobServiceImpl′:Invocationofinitmethodfailed;nestedexceptionisorg.quartz.impl.jdbcjobstore.LockException:Failureobtainingdbrowlock:Invalidobjectname′QRTZLOCKS′.[Seenestedexception:com.microsoft.sqlserver.jdbc.SQLServerException:Invalidobjectname′QRTZLOCKS′.]atorg.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor
AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambdadoGetBean
0(AbstractBeanFactory.java:324)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
at com.ruoyi.RuoYiApplication.main(RuoYiApplication.java:18)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysJobServiceImpl': Invocation of init method failed; nested exception is org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Invalid object name 'QRTZ_LOCKS'. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'QRTZ_LOCKS'.]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:415)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambdadoGetBean
0(AbstractBeanFactory.java:324)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessorAutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640)...24commonframesomittedCausedby:org.quartz.impl.jdbcjobstore.LockException:Failureobtainingdbrowlock:Invalidobjectname′QRTZLOCKS′.atorg.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:184)atorg.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)atorg.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238)atorg.quartz.impl.jdbcjobstore.JobStoreSupport.clearAllSchedulingData(JobStoreSupport.java:2002)atorg.quartz.core.QuartzScheduler.clear(QuartzScheduler.java:1547)atorg.quartz.impl.StdScheduler.clear(StdScheduler.java:239)atcom.ruoyi.quartz.service.impl.SysJobServiceImpl.init(SysJobServiceImpl.java:40)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:498)atorg.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor
LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessorLifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)atorg.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)...36commonframesomittedCausedby:com.microsoft.sqlserver.jdbc.SQLServerException:Invalidobjectname′QRTZLOCKS′.atcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)atcom.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)atcom.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)atcom.microsoft.sqlserver.jdbc.SQLServerPreparedStatement
PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3240)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3237)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:181)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:123)
... 49 common frames omitted
Disconnected from the target VM, address: '127.0.0.1:10296', transport: 'socket'

Process finished with exit code 1
![输入图片说明](https://foruda.gitee.com/images/1705386424180831027/557aab1f_5443040.png "屏幕截图")
楼主，你好，为什么我新建了两个数据库，为什么一直提示我找不到QRTZ_LOCKS，

数据源配置
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver

druid:
  # 主库数据源
  master:
    url: jdbc:sqlserver://172.18.164.104:1433;DatabaseName=ry-vue
    username: tms
    password: LmP#2024TmKS
  # 从库数据源
  slave:
    # 从数据源开关/默认关闭
    enabled: true
    url: jdbc:sqlserver://172.18.164.104:1433;DatabaseName=quartz
    username: tms
    password: LmP#2024TmKS

白鹭fly/ruoyi SQL Server

内容风险标识

评论 (1)