51Testing软件测试论坛

标题: 项目通过Maven管理，已配置Mongodb连接，测试dao接口报错 [打印本页]
作者: 测试积点老人    时间: 2022-3-4 13:26
标题: 项目通过Maven管理，已配置Mongodb连接，测试dao接口报错

项目是通过Maven的，我想从Mongodb数据库里面查询出来存进去的数据，然后做单元测试DAO接口，一直报错拒绝连接。

本地测试，可以访问Mongodb,使用 navicat 测试连接也没有问题。

[attach]136716[/attach]

DAO接口

  1. public interface BannerDao {

  3.     List<Banner> getBanners();
  4. }
复制代码

DAO实现类

  1. @Repository
  2. public class BannerDaoImpl implements BannerDao {

  4.     @Autowired
  5.     private MongoTemplate mongoTemplate;

  7.     /**
  8.      * 查询数据
  9.      * @return
  10.      */
  11.     public List<Banner> getBanners() {
  12.         Date now = new Date();
  13.         Query query = Query.query(
  14.                 Criteria.where("beginTime").lt(now)
  15.                         .and("endTime").gt(now)
  16.         );

  18.         return  mongoTemplate.find(query,Banner.class);
  19.     }
  20. }

复制代码

单元测试类


  2. @SpringBootTest(classes = {LivegoodsBannerApp.class})
  3. @RunWith(SpringRunner.class)
  4. public class TestDao {

  6.     @Autowired
  7.     private BannerDao bannerDao;

  9.     @Test
  10.     public void testSelect(){
  11.         List<Banner> banners = bannerDao.getBanners();
  12.         for (Banner b : banners){
  13.             System.out.println(b);
  14.         }
  15.     }

  17. }
复制代码

demo_banner的pom-xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5. <parent>
  6.         <artifactId>demo</artifactId>
  7.         <groupId>com.demo</groupId>
  8.         <version>1.0-SNAPSHOT</version>
  9.     </parent>
  10.     <modelVersion>4.0.0</modelVersion>

  12.     <artifactId>demo_banner</artifactId>
  13.     <version>1.0-SNAPSHOT</version>
  14.     <dependencies>
  15.         <dependency>
  16.             <groupId>org.springframework.boot</groupId>
  17.             <artifactId>spring-boot-starter-web</artifactId>
  18.         </dependency>
  19.         <dependency>
  20.             <groupId>org.springframework.cloud</groupId>
  21.             <artifactId>spring-cloud-starter-netflix-eureka-client</artifactId>
  22.         </dependency>
  23.         <dependency>
  24.             <groupId>com.demo</groupId>
  25.             <artifactId>demo_mongodb</artifactId>
  26.             <version>1.0-SNAPSHOT</version>
  27.         </dependency>
  28.         <dependency>
  29.             <groupId>org.springframework.boot</groupId>
  30.             <artifactId>spring-boot-starter-test</artifactId>
  31.         </dependency>
  32.     </dependencies>

  34. </project>
复制代码

另一个子项目demo_mongodb配置文件如下：application-mongodb.yml

  1. spring:
  2.   data:
  3.     mongodb:
  4.       host: 192.168.1.13
  5.       port: 27017
  6.       username: admin
  7.       password: admin
  8.       authentication-database: admin
  9.       database: livegoods
复制代码

demo_mongodb的pom-xml


  2. <?xml version="1.0" encoding="UTF-8"?>
  3. <project xmlns="http://maven.apache.org/POM/4.0.0"
  4.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  6.     <parent>
  7.         <artifactId>demo</artifactId>
  8.         <groupId>com.demo</groupId>
  9.         <version>1.0-SNAPSHOT</version>
  10.     </parent>
  11.     <modelVersion>4.0.0</modelVersion>

  13.     <artifactId>demo_mongodb</artifactId>
  14.     <version>1.0-SNAPSHOT</version>

  16.     <dependencies>
  17.         <dependency>
  18.             <groupId>org.springframework.boot</groupId>
  19.             <artifactId>spring-boot-starter-data-mongodb</artifactId>
  20.         </dependency>
  21.     </dependencies>
  22. </project>
复制代码

run testDao报错信息如下：

  1. org.springframework.dao.DataAccessResourceFailureException: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=localhost:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketOpenException: Exception opening socket}, caused by {java.net.ConnectException: Connection refused: connect}}]; nested exception is com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=localhost:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketOpenException: Exception opening socket}, caused by {java.net.ConnectException: Connection refused: connect}}]

  3.     at org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:88)
  4.     at org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:2874)
  5.     at org.springframework.data.mongodb.core.MongoTemplate.executeFindMultiInternal(MongoTemplate.java:2799)
  6.     at org.springframework.data.mongodb.core.MongoTemplate.doFind(MongoTemplate.java:2518)
  7.     at org.springframework.data.mongodb.core.MongoTemplate.doFind(MongoTemplate.java:2500)
  8.     at org.springframework.data.mongodb.core.MongoTemplate.find(MongoTemplate.java:856)
  9.     at org.springframework.data.mongodb.core.MongoTemplate.find(MongoTemplate.java:842)
  10.     at com.livegoods.banner.dao.impl.BannerDaoImpl.getBanners(BannerDaoImpl.java:37)
  11.     at com.livegoods.banner.dao.impl.BannerDaoImpl$FastClassBySpringCGLIB$127a1d05.invoke(<generated>)
  12.     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  13.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
  14.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  15.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  16.     at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  17.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  18.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  19.     at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
  20.     at com.livegoods.banner.dao.impl.BannerDaoImpl$EnhancerBySpringCGLIB$5c04f349.getBanners(<generated>)
  21.     at com.livegoods.test.dao.TestDao.testSelect(TestDao.java:29)
  22.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  23.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  24.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  25.     at java.lang.reflect.Method.invoke(Method.java:498)
  26.     at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
  27.     at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  28.     at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
  29.     at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
  30.     at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)
  31.     at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
  32.     at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
  33.     at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
  34.     at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
  35.     at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
  36.     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
  37.     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
  38.     at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
  39.     at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
  40.     at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
  41.     at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
  42.     at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
  43.     at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
  44.     at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
  45.     at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
  46.     at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
  47.     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
  48.     at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
  49.     at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
  50.     at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
  51.     at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
  52.     at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
  53.     at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
  54.     at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
  55. Caused by: com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=localhost:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketOpenException: Exception opening socket}, caused by {java.net.ConnectException: Connection refused: connect}}]
  56.     at com.mongodb.internal.connection.BaseCluster.getDescription(BaseCluster.java:177)
  57.     at com.mongodb.internal.connection.SingleServerCluster.getDescription(SingleServerCluster.java:41)
  58.     at com.mongodb.client.internal.MongoClientDelegate.getConnectedClusterDescription(MongoClientDelegate.java:147)
  59.     at com.mongodb.client.internal.MongoClientDelegate.createClientSession(MongoClientDelegate.java:98)
  60.     at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.getClientSession(MongoClientDelegate.java:278)
  61.     at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:182)
  62.     at com.mongodb.client.internal.MongoIterableImpl.execute(MongoIterableImpl.java:135)
  63.     at com.mongodb.client.internal.MongoIterableImpl.iterator(MongoIterableImpl.java:92)
  64.     at org.springframework.data.mongodb.core.MongoTemplate.executeFindMultiInternal(MongoTemplate.java:2782)
  65.     ... 49 more
复制代码

一开始是无法访问到，后面通过配置开放防火墙端口，并将mongodb配置文件添加成任何IP都可以访问，但运行后还是无法查询到数据库的数据，显示连接超时，拒绝连接什么的。

我想测试DAO接口，看是否能查询出数据库里面的轮播图的图片路径、开始时间、过期时间这些的。不知道是哪里出错了，希望能帮忙看下是什么原因。


作者: qqq911    时间: 2022-3-7 10:28
看下链路通不通
作者: jingzizx    时间: 2022-3-7 18:05
先不要查询，先看链接



欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/) Powered by Discuz! X3.2