如果WebSphere使用数据源连接 数据库尤其是oracle的时候出现错误:
连接池管理器无法分配一个受管连接:javax.resource.spi.ResourceAllocationException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: 仅 READ_COMMITTED 和 SERIALIZABLE 是有效的事务处理级.
这时候应该修改目录:
WebSphere/AppServer/config/cells/yc-server/applications/ycportal.ear/deployments/ycportal/ycportal.war/WEB-INF下的文件:ibm-web-ext.xmi
找到 <resourceRefExtensions xmi:id="ResourceRefExtension_1" isolationLevel="TRANSACTION_REPEATABLE_READ">将其修改为:<resourceRefExtensions xmi:id="ResourceRefExtension_1" isolationLevel="TRANSACTION_SERIALIZABLE">
同时找到应用目录中WEB-INF下的文件:ibm-web-ext.xmi
找到 <resourceRefExtensions xmi:id="ResourceRefExtension_1" isolationLevel="TRANSACTION_REPEATABLE_READ">将其修改为:<resourceRefExtensions xmi:id="ResourceRefExtension_1" isolationLevel="TRANSACTION_SERIALIZABLE">
然后重启应用就可以了