JBOSS多实例部署出现Table already exists: JMS_MESSAGES in statement[更新]
来源:互联网 发布:淘宝上哪家皮草店好 编辑:程序博客网 时间:2024/06/06 23:17
如果在jboss中使用ServiceBindingManager部署多个实例,在启动第二个以及以后的实例的时候,会出现这个错误
java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:224)
..................................
hsqldb可能在启动实例的时候要重复创建表,因此删除后面的实例中的hsqldb-ds.xml文件即可
文件位置:/.../jboss-version/server/node*/deploy/hsqldb-ds.xml
经过实践:把hsqldb-ds.xml
相关的配置检查下,实在不行的情况下:如果没有用到这些,直接用原来的安装包的内容替换掉
然后把deploy下的没用的war等删除掉,即使是多实例部署仍然是没问题的。
- JBOSS多实例部署出现Table already exists: JMS_MESSAGES in statement[更新]
- Maven 使用Intellij IDEA部署添加Maven Module出现 'pom.xml' already exists in VFS
- Hbase Table already exists
- Hbase Table already exists:
- SLT logging table already exists
- Hbase Table already exists问题
- 1050, "Table 'django_content_type' already exists"
- table already exists (code 1)
- MySQL触发器更新本表数据异常:Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this
- hive java.sql.SQLException: Table/View 'PARTITION_STATS_V2' already exists in Schema 'APP'.
- Create a table unless it already exists
- 错误代码: 1050 Table 'emp' already exists
- mySQL Table 'A.bill' already exists
- django migrate error: table 'xxx' already exists
- 部署项目到weblogic中出现"Bean already exists: "weblogic.j2ee.descriptor.FilterMappingBeanImpl@4b873872"
- jfinal jboss 多个数据源报错 Config already exists: main
- IDEA打jar包时出现manifest.mf already exists in vfs解决办法
- magento -- 解决magento错误:ERROR: Base table or view already exists: 1050 Table ... already exists
- Spring jdbc 批量更新
- camera3
- POJ 2923 Relocation (状态压缩 0-1背包)
- android 各种控件颜色值的设置(使用Drawable,Color)
- camera4
- JBOSS多实例部署出现Table already exists: JMS_MESSAGES in statement[更新]
- HDU_4317 Unfair Nim 状态压缩dp
- camera5
- 思维、找规律题目汇总
- ubuntu bluetooth 配对过程
- 2012-7-31 总结
- NAND Flash 驱动详解
- 如何在按下(但是没有长按)和长按时分别执行不同的操作
- OpenGL 纹理