Cannot unwrap to requested type [javax.sql.DataSource]

本文介绍了解决Hibernate与Spring框架中DataSource配置冲突的方法。通过调整配置,确保两个框架使用相同的DataSource,避免出现类型转换错误。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Struts 2.3.16
Spring 4.0.1
Hibernate 4.3.4

 Cannot unwrap to requested type [javax.sql.DataSource]

异常来自这段代码:


if ( ConnectionProvider.class.equals( unwrapType ) ||
    DriverManagerConnectionProviderImpl.class.isAssignableFrom( unwrapType ) ) {
    return (T) this;
} else {
    throw new UnknownUnwrapTypeException( unwrapType );
}

这里指明,Connection 需要从 javax.sql.DataSource 中获取。
请确保删除 hibernate.cfg.xml 配置文件中定义的数据源,并将 Spring 定义的 DataSource 注入 LocalSessionFactoryBean。

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
    <property name="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=SqlPro" />
    <property name="username" value="sa" />
    <property name="password" value="123" />
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="configLocation">
        <value>classpath:hibernate.cfg.xml</value>
    </property>
    <property name="dataSource" ref="dataSource" />
    <property name="packagesToScan" value="ko.java.entity" />
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>


因为hibernate 和 spring 提供的事务管理器需要使用同一个数据源,
如果将数据源配置在 hibernate 配置文件中,那么 spring 就无法得到 hibernate 的数据源


转载:http://www.cnblogs.com/kostark/archive/2013/04/27/3046382.html

联邦SQL测试失败: Error while executing SQL "select u."user_id", t."task_name" from MYSQL."sys_user" u join PGSQL."ops_task" t on u."user_id" = t."task_id" limit 1": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.runtime.ResultSetEnumerable enumerable = org.apache.calcite.runtime.ResultSetEnumerable.of((javax.sql.DataSource) root.getRootSchema().getSubSchema("MYSQL").unwrap(javax.sql.DataSource.class), "SELECT `user_id`\r\nFROM `sys_user`\r\nORDER BY `user_id` IS NULL, `user_id`", new org.apache.calcite.linq4j.function.Function1() { public org.apache.calcite.linq4j.function.Function0 apply(final java.sql.ResultSet resultSet) { return new org.apache.calcite.linq4j.function.Function0() { public Object apply() { try { final Object value; value = resultSet.getLong(1); if (resultSet.wasNull()) { value = null; } return value; } catch (java.sql.SQLException e) { throw new RuntimeException( e); } } } ; } public Object apply(final Object resultSet) { return apply( (java.sql.ResultSet) resultSet); } } ); enumerable.setTimeout(root); final org.apache.calcite.runtime.ResultSetEnumerable enumerable0 = org.apache.calcite.runtime.ResultSetEnumerable.of((javax.sql.DataSource) root.getRootSchema().getSubSchema("PGSQL").unwrap(javax.sql.DataSource.class), "SELECT \"task_name\", CAST(\"task_id\" AS BIGINT) AS \"task_id0\"\r\nFROM \"ops_task\"\r\nORDER BY 2", new org.apache.calcite.linq4j.function.Function1() { public org.apache.calcite.linq4j.function.Function0 apply(final java.sql.ResultSet resultSet) { return new org.apache.calcite.linq4j.function.Function0() { public Object apply() { try { final Object[] values = new Object[2]; values[0] = resultSet.getObject(1); values[1] = resultSet.getLong(2); if (resultSet.wasNull()) { values[1] = null; } return values; } catch (java.sql.SQLException e) { throw new RuntimeException( e); } } } ; } public Object apply(final Object resultSet) { return apply( (java.sql.ResultSet) resultSet); } } ); enumerable0.setTimeout(root); final org.apache.calcite.linq4j.Enumerable _inputEnumerable = org.apache.calcite.linq4j.EnumerableDefaults.mergeJoin(enumerable, enumerable0, new org.apache.calcite.linq4j.function.Function1() { public long apply(long left) { return left; } public Object apply(Long left) { return apply( left.longValue()); } public Object apply(Object left) { return apply( (Long) left); } } , new org.apache.calcite.linq4j.function.Function1() { public long apply(Object[] right) { return org.apache.calcite.runtime.SqlFunctions.toLong(right[1]); } public Object apply(Object right) { return apply( (Object[]) right); } } , null, new org.apache.calcite.linq4j.function.Function2() { public Object[] apply(Long left, Object[] right) { return new Object[] { left, right[0], right[1]}; } public Object[] apply(Object left, Object right) { return apply( (Long) left, (Object[]) right); } } , org.apache.calcite.linq4j.JoinType.INNER, new java.util.Comparator(){ public int compare(Long v0, Long v1) { final int c; c = org.apache.calcite.runtime.Utilities.compare(v0, v1); if (c != 0) { return c; } return 0; } public int compare(Object o0, Object o1) { return this.compare((Long) o0, (Long) o1); } }, null).take(1); return new org.apache.calcite.linq4j.AbstractEnumerable(){ public org.apache.calcite.linq4j.Enumerator enumerator() { return new org.apache.calcite.linq4j.Enumerator(){ public final org.apache.calcite.linq4j.Enumerator inputEnumerator = _inputEnumerable.enumerator(); public void reset() { inputEnumerator.reset(); } public boolean moveNext() { return inputEnumerator.moveNext(); } public void close() { inputEnumerator.close(); } public Object current() { final Object[] current = (Object[]) inputEnumerator.current(); final Object input_value = current[0]; final Object input_value0 = current[1]; return new Object[] { input_value, input_value0}; } }; } }; } public Class getElementType() { return java.lang.Object[].class; }
最新发布
08-02
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值