问题

问题

  • 可以做什么来阻止这个消息:"执行失败"?这是一个例子:
DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY))java.sql.SQLException: ORA-00955: name is already used by an existing object

这是另一个例子:

DEBUG [org.jboss.jms.server.plugin.JDBCJMSUserManager] Failed to execute INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('nobody','nobody') 
    java.sql.SQLException: Violation of unique constraint SYS_PK_60: duplicate value (s) for column (s)
  • 当我尝试在EAP 4.3 -CP06中调出ports-01时,会收到以下警告消息.请问如何解决这个问题?
2012-06-14 08:15:04,435 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY(DUMMY))
java.sql.SQLException: Table already exists: JBM_DUAL in statement [CREATE TABLE JBM_DUAL]
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)

Issue

  • What can be done to prevent this message: "Failed to execute"?  Here is an example:
DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY))java.sql.SQLException: ORA-00955: name is already used by an existing object

Here is another example:

DEBUG [org.jboss.jms.server.plugin.JDBCJMSUserManager] Failed to execute INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('nobody','nobody') 
    java.sql.SQLException: Violation of unique constraint SYS_PK_60: duplicate value (s) for column (s)
  • When I try to bring up ports-01 in EAP 4.3 -CP06, I get a warning message as below. Can you please advise on how to fix this issue?
2012-06-14 08:15:04,435 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY(DUMMY))
java.sql.SQLException: Table already exists: JBM_DUAL in statement [CREATE TABLE JBM_DUAL]
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)


解决方法

请关注DeveloperQ公众号以获得问题解决方法 DeveloperQ公众号




相关问题推荐