1 Reply Latest reply on Feb 13, 2007 10:33 AM by Clebert Suconic

    Please delete the user data before you insert it!

    Tim Fox Master

      When running tests - this crops up on every test.

      @main 14:38:31,566 WARN [JDBCJMSUserManager] Failed to execute INSERT INTO JBM_
      USER (USER_ID,PASSWD,CLIENTID) VALUES ('dilbert','dogbert','dilbert-id')
      java.sql.SQLException: Duplicate entry 'dilbert' for key 1
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
       at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
       at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
       at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
       at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(Wrappe
      dStatement.java:184)
       at org.jboss.jms.server.plugin.JDBCJMSUserManager.insertUserRoleData(JDB
      CJMSUserManager.java:192)
       at org.jboss.jms.server.plugin.JDBCJMSUserManager.start(JDBCJMSUserManag
      er.java:99)
       at org.jboss.jms.server.plugin.JDBCJMSUserManagerService.startService(JD
      BCJMSUserManagerService.java:78)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
      upport.java:289)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
      96)
       at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
      er.java:157)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
      or.java:138)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
      BeanOperationInterceptor.java:140)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
      java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
       at org.jboss.test.messaging.tools.jmx.ServiceContainer.invoke(ServiceCon
      tainer.java:808)
       at org.jboss.test.messaging.tools.jmx.rmi.LocalTestServer.startServerPee
      r(LocalTestServer.java:359)
       at org.jboss.test.messaging.tools.ServerManagement.startServerPeer(Serve
      rManagement.java:718)