jboss里怎么配置mysql数据库的连接池啊？

Question

我想配置好mysql的数据库连接池给hibernate用但不知如何配置？希望有人可以指点一二

Answer 1

大概这样子：

[code="xml"]

<bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
    <property name="properties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">true</prop>
            <prop key="jdbc.fetch_size">50</prop>
            <prop key="jdbc.batch_size">100</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
            <prop key="hibernate.cache.use_query_cache">true</prop>
            <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
            <prop key="hibernate.query.substitutions">true 1,false 0</prop>
        </props>
    </property>
</bean>

<bean id="sessionFactory" class="net.java.dev.springannotation.hibernate.AutomaticAnnotationSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="hibernateProperties" ref="hibernateProperties"/>
    <property name="mappingDirectoryLocations">
        <list>
            <value>classpath:xxx/domain</value>
        </list>
    </property>
</bean>

[/code]