Quarkus 和反应式数据源 - 错误 名称"datasource.url"的多个匹配属性

Question

我在使用PgPool和ResulSet连接到 postgres 数据库时遇到问题，然后是 sql 语句。这是我的服务等级。

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.http.HttpSession;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import org.springframework.web.context.annotation.ApplicationScope;
//import io.vertx.reactivex.pgclient.PgPool;
import io.vertx.axle.pgclient.PgPool;
import ml.kalansow.domain.StudentFees;
import ml.kalansow.service.KalansowService;
@Service
@ApplicationScope
public class StudentFeesService implements KalansowService {
private static final Logger LOG = LoggerFactory.getLogger(StudentFeesService.class);
PgPool client;
// ----Constructor------------------------------------------
public StudentFeesService() {
// TODO Auto-generated constructor stub
};
// ------------------------------Method---------------------------------
@Override
public String getServiceName() {
return this.getClass().getName();
}
public void processGetFeesDetails(HttpSession session) {
String strStudentId = (String) session.getAttribute("StudentId");
StudentFees studentFees = new StudentFees();
if (strStudentId != null) {
// This is mandatory before calling the next method
studentFees.setStudentId(strStudentId);
populateFeesInfo(studentFees);
session.setAttribute("studentFees", studentFees);
} else {
LOG.error("Student Id is null");
}
}
private void populateFeesInfo(StudentFees studentFees) {
String strStudentI = studentFees.getStudentId();
io.vertx.sqlclient.impl.Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
StringBuffer sbQuery = new StringBuffer();
sbQuery.append("SELECT * FROM STUDENT_FEES WHERE STUDENT_I=");
sbQuery.append("" + strStudentI + "''");
if (strStudentI != null) {
//connection = DatabaseService.getDBConnection();
connection=(io.vertx.sqlclient.impl.Connection) client.getConnection();
try {
statement = ((Connection) connection).createStatement();
resultSet = statement.executeQuery(sbQuery.toString());
resultSet.next();
studentFees.setJanAcad(resultSet.getString("JAN_ACAD"));
studentFees.setFebAcad(resultSet.getString("FEB_ACAD"));
studentFees.setMarAcad(resultSet.getString("MAR_ACAD"));
studentFees.setAprAcad(resultSet.getString("APR_ACAD"));
studentFees.setMayAcad(resultSet.getString("MAY_ACAD"));
studentFees.setJunAcad(resultSet.getString("JUN_ACAD"));
studentFees.setJulAcad(resultSet.getString("JUL_ACAD"));
studentFees.setAugAcad(resultSet.getString("AUG_ACAD"));
studentFees.setSepAcad(resultSet.getString("SEP_ACAD"));
studentFees.setOctAcad(resultSet.getString("OCT_ACAD"));
studentFees.setNovAcad(resultSet.getString("NOV_ACAD"));
studentFees.setDecAcad(resultSet.getString("DEC_ACAD"));
} catch (SQLException e) {
LOG.error(e.getMessage());
} finally {
/*DatabaseService.closeDBConnection(statement, resultSet);
DatabaseService.realeaseDBConnection();*/
client.close();
}
} else {
LOG.error("Student id is null");
}
}
}

我的应用程序属性文件包含数据源属性

quarkus.datasource.driver=org.postgresql.Driver quarkus.reactive-datasource.url=vertx-reactive：postgresql：//localhost：5432/test quarkus.reactive-datasource.username=test quarkus.reactive-datasource.password=test

控制台就在这里

错误 [io.qua.dev.DevModeMain] 无法启动 Quarkus：java.lang.IllegalArgumentException：名称"datasource.url"属性的多个匹配属性由公共 java.util.Optional io.quarkus.agroal.runtime.DataSourceRuntimeConfig.url 和公共 java.util.Optional io.quarkus.reactive.pg.client.runtime.DataSourceConfig.url 匹配。这可能是因为您有一个不兼容的扩展组合，它们都定义了相同的属性(例如，包括反应式和阻塞数据库扩展( at io.quarkus.deployment.configuration.matching.PatternMapBuilder.addMember(PatternMapBuilder.java：71( at io.quarkus.deployment.configuration.matching.PatternMapBuilder.addGroup(PatternMapBuilder.java：60( at io.quarkus.deployment.configuration.matching.PatternMapBuilder.addMember(PatternMapBuilder.java：85( at io.quarkus.deployment.configuration.matching.PatternMapBuilder.addGroup(PatternMapBuilder.java：60( at io.quarkus.deployment.configuration.matching.PatternMapBuilder.makePatterns(PatternMapBuilder.java：35( at io.quarkus.deployment.configuration.BuildTimeConfigurationReader.(BuildTimeConfigurationReader.java：107( at io.quarkus.deployment.ExtensionLoader.loadStepsFrom(ExtensionLoader.java：174( at io.quarkus.deployment.QuarkusAugmentor.run(QuarkusAugmentor.java：85( at io.quarkus.runner.RuntimeRunner.run(RuntimeRunner.java：114( at io.quarkus.dev.DevModeMain.doStart(DevModeMain.java：178( at io.quarkus.dev.DevModeMain.start(DevModeMain.java：96(

Answer 1

您暂时不能同时使用Agroal扩展和反应式数据源。

我们正在讨论解决此问题的可能方法： https://groups.google.com/d/msg/quarkus-dev/3r0lquVsUsc/DVxX7SvQAQAJ .

但是现在，您唯一的选择是使用其中之一。