无法从数据源获取连接

Question

我正在尝试使用 MulesSoft 连接到德比客户端数据库，我已经按照给定的学习材料进行操作。一旦我建立了通用连接并尝试运行 url 错误，就会显示：无法从数据源获取。

在我面临的错误消息下方

//////////////////////////////

org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source

Caused by: org.mule.extension.db.api.exception.connection.ConnectionCreationException: Could not obtain connection from data source

Caused by: org.mule.runtime.extension.api.exception.ModuleException: java.sql.SQLException: Error trying to load driver:  org.apache.derby.jdbc.ClientDriver : Cannot load class ' org.apache.derby.jdbc.ClientDriver': [

     org.apache.derby.jdbc.ClientDriver, 

    Cannot load class ' org.apache.derby.jdbc.ClientDriver': [

    Class ' org.apache.derby.jdbc.ClientDriver' has no package mapping for region 'domain/default/app/tooling-application-8bc17c50-a618-11e9-a2eb-025041000101'., 

    Cannot load class ' org.apache.derby.jdbc.ClientDriver': [

    Class ' org.apache.derby.jdbc.ClientDriver' has no package mapping for region '/domain/default'., 

    Class ' org.apache.derby.jdbc.ClientDriver' not found in classloader for artifact 'container'.]]]

Caused by: java.sql.SQLException: Error trying to load driver:  org.apache.derby.jdbc.ClientDriver : Cannot load class ' org.apache.derby.jdbc.ClientDriver': [

     org.apache.derby.jdbc.ClientDriver, 

    Cannot load class ' org.apache.derby.jdbc.ClientDriver': [

    Class ' org.apache.derby.jdbc.ClientDriver' has no package mapping for region 'domain/default/app/tooling-application-8bc17c50-a618-11e9-a2eb-025041000101'., 

Answer 1

您是否将 JDBC 驱动程序设置为 POM 中的共享库？https://docs.mulesoft.com/connectors/db/db-configure-connection#set-the-jdbc-driver

Answer 2

嘿，以防万一有人在我这边遇到这个错误，我忘了关闭连接finally {         call.closeAll();     }这导致错误=“无法从数据源获取连接，不允许添加多个最后资源。当前资源是 org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@17d3bab6