----------jboss-4.0.5.GA\server\default\deploy\mysql-ds.xml----------
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://10.1.4.xx:3306/xx_xxx</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xxxxx</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>50</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support-->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
<!--最小连接池数目-->
<min-pool-size>5</min-pool-size>
<!--最大连接池数目-->
<max-pool-size>50</max-pool-size>
<!-- 数据库连接空闲时间,单位为分钟,如果负载较大,可以设为5,如果一般,可以设为3 -->
<idle-timeout-minutes>5</idle-timeout-minutes>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
----------jboss-4.0.5.GA\server\default\deploy\jbossweb-tomcat55.sar\server.xml----------
<!-- add youlong
<Valve className="org.jboss.web.tomcat.tc5.jca.CachedConnectionValve"
cachedConnectionManagerObjectName="jboss.jca:service=CachedConnectionManager"
transactionManagerObjectName="jboss:service=TransactionManager" />
-->
----------jboss-4.0.5.GA\server\default\deploy\jbossweb-tomcat55.sar\META-INF\jboss-service.xml----------
<!-- add youlong
<depends>jboss.jca:service=CachedConnectionManager</depends>
-->
----------jboss-4.0.5.GA\server\default\conf\standardjboss.xml----------
<!--<interceptor>org.jboss.resource.connectionmanager.CachedConnectionInterceptor</interceptor>-->
----------jboss-4.0.5.GA\server\default\conf\login-config.xml----------
<!--
<application-policy name = "MySqlDbRealm">
<authentication>
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">MySqlDS</module-option>
<module-option name = "userName">root</module-option>
<module-option name = "password">000000</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>
</authentication>
</application-policy> -->
----------jboss-4.0.5.GA\server\default\conf\standardjbosscmp-jdbc.xml----------
<datasource>java:/MySqlDS</datasource>
<!-- optional since 4.0 <datasource-mapping>Hypersonic SQL</datasource-mapping> -->
<datasource-mapping>mySQL</datasource-mapping>
<datasource>java:/DefaultDS</datasource>
<!-- optional since 4.0 <datasource-mapping>Hypersonic SQL</datasource-mapping> -->
----------jboss-4.0.5.GA\server\default\conf\standardjbosscmp-jdbc.xml----------
<datasource>java:/DefaultDS</datasource>
<type-mapping>Hypersonic SQL</type-mapping>
<datasource>java:/MySqlDS</datasource>
<type-mapping>mySQL</type-mapping>
上面啰嗦了半天其实和JBOSS没有关系。因为Mysql的问题
修改mysql参数:
vi /etc/my.cnf
分别在[client]、[mysqld]域加上如下参数
default-character-set = utf8
修改 wait_timeout = 31536000
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://10.1.4.xx:3306/xx_xxx</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xxxxx</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>50</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support-->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
<!--最小连接池数目-->
<min-pool-size>5</min-pool-size>
<!--最大连接池数目-->
<max-pool-size>50</max-pool-size>
<!-- 数据库连接空闲时间,单位为分钟,如果负载较大,可以设为5,如果一般,可以设为3 -->
<idle-timeout-minutes>5</idle-timeout-minutes>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
----------jboss-4.0.5.GA\server\default\deploy\jbossweb-tomcat55.sar\server.xml----------
<!-- add youlong
<Valve className="org.jboss.web.tomcat.tc5.jca.CachedConnectionValve"
cachedConnectionManagerObjectName="jboss.jca:service=CachedConnectionManager"
transactionManagerObjectName="jboss:service=TransactionManager" />
-->
----------jboss-4.0.5.GA\server\default\deploy\jbossweb-tomcat55.sar\META-INF\jboss-service.xml----------
<!-- add youlong
<depends>jboss.jca:service=CachedConnectionManager</depends>
-->
----------jboss-4.0.5.GA\server\default\conf\standardjboss.xml----------
<!--<interceptor>org.jboss.resource.connectionmanager.CachedConnectionInterceptor</interceptor>-->
----------jboss-4.0.5.GA\server\default\conf\login-config.xml----------
<!--
<application-policy name = "MySqlDbRealm">
<authentication>
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">MySqlDS</module-option>
<module-option name = "userName">root</module-option>
<module-option name = "password">000000</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>
</authentication>
</application-policy> -->
----------jboss-4.0.5.GA\server\default\conf\standardjbosscmp-jdbc.xml----------
<datasource>java:/MySqlDS</datasource>
<!-- optional since 4.0 <datasource-mapping>Hypersonic SQL</datasource-mapping> -->
<datasource-mapping>mySQL</datasource-mapping>
<datasource>java:/DefaultDS</datasource>
<!-- optional since 4.0 <datasource-mapping>Hypersonic SQL</datasource-mapping> -->
----------jboss-4.0.5.GA\server\default\conf\standardjbosscmp-jdbc.xml----------
<datasource>java:/DefaultDS</datasource>
<type-mapping>Hypersonic SQL</type-mapping>
<datasource>java:/MySqlDS</datasource>
<type-mapping>mySQL</type-mapping>
上面啰嗦了半天其实和JBOSS没有关系。因为Mysql的问题
修改mysql参数:
vi /etc/my.cnf
分别在[client]、[mysqld]域加上如下参数
default-character-set = utf8
修改 wait_timeout = 31536000