mysql - 获取应用程序必须提供 JDBC 连接异常

Question

尝试使用 Spring+hibernate 在 Mysql DB 上执行查询时，出现“应用程序必须提供 JDBC 连接”异常

应用程序上下文有以下条目

<bean id="jdbc" class="org.springframework.jdbc.core.JdbcTemplate">
            <property name="dataSource" ref="appDataSource" />      
</bean>

<bean id="appDataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="org.mariadb.jdbc.Driver" />
        <property name="url" value="jdbc:mariadb://localhost:3306/appdb" />
        <property name="username" value="username" />
        <property name="password" value="password" />
</bean>

JNDI 名称为

<jee:jndi-lookup id="appDataSource" jndi-name="java:comp/env/jdbc/Modeling"/>

完整的堆栈跟踪

    java.lang.UnsupportedOperationException: The application must supply JDBC connections
at org.hibernate.engine.jdbc.connections.internal.UserSuppliedConnectionProviderImpl.getConnection(UserSuppliedConnectionProviderImpl.java:44)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:386)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:84)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:    )
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1927)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874)
at org.hibernate.loader.Loader.doQuery(Loader.java:919)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
at org.hibernate.loader.Loader.doList(Loader.java:2610)
at org.hibernate.loader.Loader.doList(Loader.java:2593)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)
at org.hibernate.loader.Loader.list(Loader.java:2417)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:964)

hibernate 配置

<hibernate-configuration>
    <session-factory>
        <mapping resource="service.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

Service.hbm.xml 文件

<hibernate-mapping>
   <class name="service.repository.Account"
        table="ACCOUNTS" discriminator-value="null">
        <id name="id" column="id" type="java.lang.Long">
        //all other entry
   </class>
</hibernate-mapping>

Answer 1

执行以下操作 -

1)检查 hibernate.cgf.xml(或您的 hibernate 配置文件)并确认以下内容是否正确 -

hibernate.connection.url
hibernate.connection.username
hibernate.connection.password
hibernate.dialect
hibernate.connection.driver_class

2) 检查您在standalone.xml(JBoss 配置文件)中定义的数据源名称。它应该与您的 jndi-name ="java:datasource_name"匹配