服务启动报错，求解决

[wyy16318]

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[sports-exercise-server:17085::] 2023-03-28 14:59:36.908:[ERROR] [39216] [] [main:19915] [org.springframework.boot.SpringApplication.reportFailure:826] Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'getCacheUidGenerator' defined in class path resource [com/zdr/sports/exercise/config/datasource/ExerciseMybatisAutoConfiguration.class]: Invocation of init method failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.github.zuihou.uid.dao.WorkerNodeDAO.addWorkerNode
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1794)
	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.lambda$doGetBean$0(AbstractBeanFactory.java:324)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226)
	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:397)
	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.zdr.sports.exercise.ExerciseServerApplication.main(ExerciseServerApplication.java:36)
Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.github.zuihou.uid.dao.WorkerNodeDAO.addWorkerNode
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:51)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedInvoker$0(MybatisMapperProxy.java:111)
	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
	at com.baomidou.mybatisplus.core.toolkit.CollectionUtils.computeIfAbsent(CollectionUtils.java:117)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedInvoker(MybatisMapperProxy.java:98)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy312.addWorkerNode(Unknown Source)
	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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy313.addWorkerNode(Unknown Source)
	at com.github.zuihou.uid.service.DisposableWorkerIdAssigner.assignWorkerId(DisposableWorkerIdAssigner.java:63)
	at com.github.zuihou.uid.service.DisposableWorkerIdAssigner$$FastClassBySpringCGLIB$$821f2d3c.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.github.zuihou.uid.service.DisposableWorkerIdAssigner$$EnhancerBySpringCGLIB$$1aaf10ff.assignWorkerId(<generated>)
	at com.baidu.fsg.uid.impl.DefaultUidGenerator.afterPropertiesSet(DefaultUidGenerator.java:100)
	at com.baidu.fsg.uid.impl.CachedUidGenerator.afterPropertiesSet(CachedUidGenerator.java:73)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1790)
	... 16 common frames omitted


Process finished with exit code 1

[zuihou]

你们项目包名为： com/zdr/sports。
lamp-uid 下面的 WorkerNodeDAO 的包名为： com.github.zuihou

解决方案：
在配置数据源相关的类上，加上如下注解:

@MapperScan(basePackages = { "com.github.zuihou" } )

[wyy16318]

@Configuration
@Slf4j
@MapperScan(
        basePackages = { "com.zdr.sports.exercise", "com.github.zuihou"}, annotationClass = Repository.class,
        sqlSessionFactoryRef = ExerciseDatabaseAutoConfiguration.DATABASE_PREFIX + "SqlSessionFactory")
@EnableConfigurationProperties({MybatisPlusProperties.class})
@ConditionalOnExpression("!'DATASOURCE'.equals('${zuihou.database.multiTenantType}')")
public class ExerciseDatabaseAutoConfiguration extends BaseDatabaseConfiguration {
    /**
     * 每个数据源配置不同即可
     */
    final static String DATABASE_PREFIX = "master";

    public ExerciseDatabaseAutoConfiguration(MybatisPlusProperties properties,
                                              DatabaseProperties databaseProperties,
                                              ObjectProvider<Interceptor[]> interceptorsProvider,
                                              ObjectProvider<TypeHandler[]> typeHandlersProvider,
                                              ObjectProvider<LanguageDriver[]> languageDriversProvider,
                                              ResourceLoader resourceLoader,
                                              ObjectProvider<DatabaseIdProvider> databaseIdProvider,
                                              ObjectProvider<List<ConfigurationCustomizer>> configurationCustomizersProvider,
                                              ObjectProvider<List<MybatisPlusPropertiesCustomizer>> mybatisPlusPropertiesCustomizerProvider,
                                              ApplicationContext applicationContext) {
        super(properties, databaseProperties, interceptorsProvider, typeHandlersProvider,
                languageDriversProvider, resourceLoader, databaseIdProvider,
                configurationCustomizersProvider, mybatisPlusPropertiesCustomizerProvider, applicationContext);
        log.debug("检测到 zuihou.database.multiTenantType!=DATASOURCE，加载了 ExerciseDatabaseAutoConfiguration");
    }

显示的是配置过的

[zuihou]

看一下 WorkerNodeDAO 类代码

[wyy16318]

/*
 * Copyright (c) 2017 Baidu, Inc. All Rights Reserve.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.github.zuihou.uid.dao;

import com.baidu.fsg.uid.worker.entity.WorkerNodeEntity;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * DAO for M_WORKER_NODE
 *
 * @author yutianbao
 */
@Repository
@InterceptorIgnore(tenantLine = "true", dynamicTableName = "true")
public interface WorkerNodeDAO {

    /**
     * Get {@link WorkerNodeEntity} by node host
     *
     * @param host
     * @param port
     * @return
     */
    WorkerNodeEntity getWorkerNodeByHostPort(@Param("host") String host, @Param("port") String port);

    /**
     * Add {@link WorkerNodeEntity}
     *
     * @param workerNodeEntity
     */
    void addWorkerNode(WorkerNodeEntity workerNodeEntity);

}

这个打开的是一个jar

[zuihou]

/*
 * Copyright (c) 2017 Baidu, Inc. All Rights Reserve.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.github.zuihou.uid.dao;

import com.baidu.fsg.uid.worker.entity.WorkerNodeEntity;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * DAO for M_WORKER_NODE
 *
 * @author yutianbao
 */
@Repository
@InterceptorIgnore(tenantLine = "true", dynamicTableName = "true")
public interface WorkerNodeDAO {

    /**
     * Get {@link WorkerNodeEntity} by node host
     *
     * @param host
     * @param port
     * @return
     */
    WorkerNodeEntity getWorkerNodeByHostPort(@Param("host") String host, @Param("port") String port);

    /**
     * Add {@link WorkerNodeEntity}
     *
     * @param workerNodeEntity
     */
    void addWorkerNode(WorkerNodeEntity workerNodeEntity);

}

这个打开的是一个jar

这个类的代码替换一下： https://github.com/zuihou/lamp-util/blob/master/lamp-uid/src/main/java/top/tangyh/basic/uid/dao/WorkerNodeDao.java

[zuihou]

粘贴代码时， 请使用三个 ``` 符号包裹代码

 代码

[wyy16318]

/*
* Copyright (c) 2017 Baidu, Inc. All Rights Reserve.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*     http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.github.zuihou.uid.dao;

import com.baidu.fsg.uid.worker.entity.WorkerNodeEntity;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
* DAO for M_WORKER_NODE
*
* @author yutianbao
*/
@Repository
@InterceptorIgnore(tenantLine = "true", dynamicTableName = "true")
public interface WorkerNodeDAO {

   /**
    * Get {@link WorkerNodeEntity} by node host
    *
    * @param host
    * @param port
    * @return
    */
   WorkerNodeEntity getWorkerNodeByHostPort(@Param("host") String host, @Param("port") String port);

   /**
    * Add {@link WorkerNodeEntity}
    *
    * @param workerNodeEntity
    */
   void addWorkerNode(WorkerNodeEntity workerNodeEntity);

}

[wyy16318]

好的

[wyy16318]

粘贴代码时， 请使用三个 ``` 符号包裹代码

 代码

文件只读 无法替换

[zuihou]

启动类有没有扫描： com.github.zuihou ？

看看启动类代码有没有加：

@ComponentScan({"com.github.zuihou"})

[wyy16318]

使用这个代码 ： https://github.com/zuihou/lamp-util/blob/master/lamp-uid/src/main/java/top/tangyh/basic/uid/dao/WorkerNodeDao.java 替换你们现在 WorkerNodeDAO 的源码。

1. 方案1： 想办法替换 lamp-uid.jar 中的源码，并重新编译打包。

2. 方案2：在你的项目中新建一个类： WorkerNodeDAO ，完整包名为： com.github.zuihou.uid.dao.WorkerNodeDAO。 使用jdk的类加载机制来覆盖 lamp-uid 里面的 WorkerNodeDAO。

第二种方案不行，第一种方案如何实现

[zuihou]

找到 对应版本 zuihou-uid 的源码。

[wyy16318]

找到 对应版本 zuihou-uid 的源码。

还有别的尝试方案吗，我找找怎么实现第一种

[zuihou]

找到 对应版本 zuihou-uid 的源码。

https://github.com/zuihou/lamp-util/tree/2.6.0

[zuihou]

https://github.com/zuihou/lamp-util/tree/2.6.0

按这个地址改吧， 2.6.0 版本我都几年没维护了。

[zuihou]

在看下 zuihou-uid 里面有没有这个xml 文件

[wyy16318]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.github.zuihou.uid.dao.WorkerNodeDAO">
   <resultMap id="workerNodeRes"
              type="com.baidu.fsg.uid.worker.entity.WorkerNodeEntity">
       <id column="ID" jdbcType="BIGINT" property="id"/>
       <result column="HOST_NAME" jdbcType="VARCHAR" property="hostName"/>
       <result column="PORT" jdbcType="VARCHAR" property="port"/>
       <result column="TYPE" jdbcType="INTEGER" property="type"/>
       <result column="LAUNCH_DATE" jdbcType="DATE" property="launchDate"/>
       <result column="MODIFIED" jdbcType="TIMESTAMP" property="modified"/>
       <result column="CREATED" jdbcType="TIMESTAMP" property="created"/>
   </resultMap>

   <insert id="addWorkerNode" useGeneratedKeys="true" keyProperty="id"
           parameterType="com.baidu.fsg.uid.worker.entity.WorkerNodeEntity">
   	INSERT INTO WORKER_NODE
   	(HOST_NAME,
   	PORT,
   	TYPE,
   	LAUNCH_DATE,
   	MODIFIED,
   	CREATED)
   	VALUES (
   	#{hostName},
   	#{port},
   	#{type},
   	#{launchDate},
   	NOW(),
   	NOW())
   </insert>

   <select id="getWorkerNodeByHostPort" resultMap="workerNodeRes">
   	SELECT
   	ID,
   	HOST_NAME,
   	PORT,
   	TYPE,
   	LAUNCH_DATE,
   	MODIFIED,
   	CREATED
   	FROM
   	WORKER_NODE
   	WHERE
   	HOST_NAME = #{host} AND PORT = #{port}
   </select>
</mapper>

有的文件名称是WorkerNodeMapper.xml

[wyy16318]

没有 resources 文件夹

[zuihou]

源文件里面的resources，在编译为jar后，不会体现resources目录。

zuihou-uid.jar-2.6.0 版本已经2-3年没维护了，我也不知道你们的项目为什么没有zuihou-util的源码，请自行找到zuihou-util 的源码，并修改和替换。

这是我开源的 2.6.0版本源码：
https://github.com/zuihou/lamp-util/tree/2.6.0

[wyy16318]

[zuihou]

复制、粘贴，等图片上传完成，在发送

[wyy16318]

[wyy16318]

复制、粘贴，等图片上传完成，在发送

可以了

[wyy16318]

那个错误还有别的解决方案吗，数据源配置是没有问题的

[zuihou]

没有