spring+ hibenate+proxool 配置两个proxool连接池时报错 Every derived table must have its own alias
来源:互联网 发布:怎么目测身高知乎 编辑:程序博客网 时间:2024/05/17 05:04
我在配置连接池时,刚开始一个用的c3p0,一个是proxool,今天我就准备同换成proxool,
但是一换就报Every derived table must have its own alias,这是我意料之中的事情.
刚开始以为是DAO操作数据库,没有给某张table取别名,或者连接查询别名去重复了。
仔细检查了一些,也修改了别名.可结果还是一样。
那应该不是别名的问题,看到"alias "我就想起来了,是不是要给两个数据源配置一个
别名,不然没法知道该连接哪一个数据源?重新配置后,果然就可以访问数据库了。
具体配置如下:
但是一换就报Every derived table must have its own alias,这是我意料之中的事情.
刚开始以为是DAO操作数据库,没有给某张table取别名,或者连接查询别名去重复了。
仔细检查了一些,也修改了别名.可结果还是一样。
那应该不是别名的问题,看到"alias "我就想起来了,是不是要给两个数据源配置一个
别名,不然没法知道该连接哪一个数据源?重新配置后,果然就可以访问数据库了。
具体配置如下:
- <!-- proxool oracle -->
- <bean id="dataSourceoracle" class="org.logicalcobwebs.proxool.ProxoolDataSource" >
- <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
- <property name="driverUrl" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
- <property name="user" value="oracle"/>
- <property name="password" value="oracle"/>
- <property name="maximumConnectionCount" value="85"/>
- <property name="minimumConnectionCount" value="5"/>
- <property name="maximumActiveTime" value="30000"/>
- <property name="houseKeepingSleepTime" value="90000"/>
- <property name="trace" value="true"/>
- <property name="alias" value="proxooloracle"/>
- <property name="delegateProperties" value="user=oracle,password=oracle"/>
- </bean>
- <!-- proxool mysql -->
- <bean id="dataSourcemysql" class="org.logicalcobwebs.proxool.ProxoolDataSource" >
- <property name="driver" value="com.mysql.jdbc.Driver"/>
- <property name="driverUrl" value="jdbc:mysql://127.0.0.1:3306/ktable?
- useUnicode=true&characterEncoding=GBK"/>
- <property name="user" value="root"/>
- <property name="password" value="kaiyuan"/>
- <property name="maximumConnectionCount" value="85"/>
- <property name="minimumConnectionCount" value="5"/>
- <property name="maximumActiveTime" value="30000"/>
- <property name="houseKeepingSleepTime" value="90000"/>
- <property name="alias" value="proxoolmysql"/>
- <property name="trace" value="true"/>
- <property name="delegateProperties" value="user=mysql,password=mysql"/>
- spring+ hibenate+proxool 配置两个proxool连接池时报错 Every derived table must have its own alias
- Every derived table must have its own alias
- MySQL错误:Every derived table must have its own alias
- Every derived table must have its own alias
- [Err] 1248 - Every derived table must have its own alias
- mysql出现“Every derived table must have its own alias”
- 【mysql】Every derived table must have its own alias
- every derived table must have its own alias
- mysql错误 Every derived table must have its own alias
- 5.4mysql Every derived table must have its own alias
- 错误代码: 1248 Every derived table must have its own alias
- Every derived table must have its own alias
- Mysql错误:Every derived table must have its own alias
- mysql 提示:Every derived table must have its own alias
- Every derived table must have its own alias
- Every derived table must have its own alias(sql语法错误)
- Every derived table must have its own alias
- Mysql两个查询结果相加?错误:Every derived table must have its own alias
- JSON的javascript调用
- Servlet 环境下取得 spring 的 ApplicationContext
- 怎麼看懂Alt+Ctrl+Delete的性能页面?
- 在Oracle的连接视图上进行数据更新操作
- 简单VBA添加线要素
- spring+ hibenate+proxool 配置两个proxool连接池时报错 Every derived table must have its own alias
- overload和override的区别
- 日出东海落西山,愁也一天,喜也一天
- 测试管理---Testlink
- 开博,留念
- c#验证错误提示
- 2008.12.11
- JVM内存调优
- 20081211