spring hibernate 连接池 异常Not supported by BasicDataSource

时间:2013.07.05 发布人:jy02602734

spring hibernate 连接池 异常Not supported by BasicDataSource

已解决问题

谷歌jy02602734用户在2013.07.05提交了关于“宋伊人spring hibernate 连接池 异常Not supported by BasicDataSource”的提问,欢迎大家涌跃发表自己的观点。目前共有1个回答,最后更新于2024-10-24T10:05:39。applicationContext.xml
<beanid="dataSourcetarget"
class="org.springframework.jndi.JndiObjectFactoryBean">
<propertyname="jndiName"value="j**a:comp/env/jdbc/test"></property>
</bean>
<beanid="dataSource"
class="org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter">
<propertyname="targetDataSource">
<refbean="dataSourcetarget"/>
</property>
<propertyname="username"value="root"></property>
<propertyname="password"value="root"></property>
</bean>

<beanid="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<propertyname="dataSource">
<refbean="dataSource"/>
</property>
<propertyname="hibernateProperties">
<props>
<propkey="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<propkey="hibernate.connection.autocommit">true</prop>
<propkey="***.show_sql">true</prop>
</props>
</property>
<propertyname="mappingResources">
<list>
<value>com/test/vo/User.hbm.xml</value>
</list>
</property>
</bean>
<beanid="hibernateTemplate"
class="org.springframework.orm.hibernate3.h**ibernateTemplate">
<propertyname="sessionFactory">
<refbean="sessionFactory"/>
</property>
</bean>
tomcat/conf/server.xml
<Contextpath="/Test"docBase="Test"
debug="5"reloadable="true"crossContext="true">

<LoggerclassName="org.apache.catalina.logger.FileLogger"
prefix="localhost_MysqlTest_log."suffix=".txt"
timestamp="true"/>

<Resourcename="jdbc/test"auth="Container"type="j**ax.sql.DataSource"/>
<ResourceParamsname="jdbc/test">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>root</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1:3306/test</value>
</parameter>
</ResourceParams>
</Context>
tomcat正常启动,但是添加**时出现NotsupportedbyBasicDataSource希望大家能够帮助她。

详细问题描述及疑问:applicationContext.xml
<beanid="dataSourcetarget"
class="org.springframework.jndi.JndiObjectFactoryBean">
<propertyname="jndiName"value="j**a:comp/env/jdbc/test"></property>
</bean>
<beanid="dataSource"
class="org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter">
<propertyname="targetDataSource">
<refbean="dataSourcetarget"/>
</property>
<propertyname="username"value="root"></property>
<propertyname="password"value="root"></property>
</bean>

<beanid="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<propertyname="dataSource">
<refbean="dataSource"/>
</property>
<propertyname="hibernateProperties">
<props>
<propkey="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<propkey="hibernate.connection.autocommit">true</prop>
<propkey="***.show_sql">true</prop>
</props>
</property>
<propertyname="mappingResources">
<list>
<value>com/test/vo/User.hbm.xml</value>
</list>
</property>
</bean>
<beanid="hibernateTemplate"
class="org.springframework.orm.hibernate3.h**ibernateTemplate">
<propertyname="sessionFactory">
<refbean="sessionFactory"/>
</property>
</bean>
tomcat/conf/server.xml
<Contextpath="/Test"docBase="Test"
debug="5"reloadable="true"crossContext="true">

<LoggerclassName="org.apache.catalina.logger.FileLogger"
prefix="localhost_MysqlTest_log."suffix=".txt"
timestamp="true"/>

<Resourcename="jdbc/test"auth="Container"type="j**ax.sql.DataSource"/>
<ResourceParamsname="jdbc/test">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>root</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1:3306/test</value>
</parameter>
</ResourceParams>
</Context>
tomcat正常启动,但是添加**时出现NotsupportedbyBasicDataSource期待您的答案,千言万语,表达不了我的感激之情,我已铭记在心 !

希望以下的回答,能够帮助你。

第1个回答

用户名:hvwr5788  

正常启动配置应该没问题你也说了是添加**出现异常有可能某字段错误引发该异常