2 Replies Latest reply on Jun 30, 2004 4:05 PM by Andreas

    Foreign key constraint not added as requested

    Andreas Newbie

      Hei all,

      This is a question for JBoss 3.2.3
      I have an application running with several EJB that use CMP/CMR.
      At server startup i see the following output in the log, which makes me worrying if there is something wrong here:

      20:12:44,126 DEBUG [Customer] Executing SQL: CREATE TABLE t_customer (userId varchar(20) NOT NULL, firstname varchar(20), lastname varchar(20), email varchar(40), telephone varchar(20), language varchar(3), currency varchar(3), securityquestion_fk varchar(32), account_fk varchar(20), CONSTRAINT pk_t_customer PRIMARY KEY (userId))
      20:12:44,137 INFO [Customer] Created table 't_customer' successfully.
      20:12:44,138 DEBUG [Customer] Foreign key constraint not added as requested: relationshipRolename=customer-has-securityquestion
      20:12:44,139 DEBUG [Customer] Foreign key constraint not added as requested: relationshipRolename=securityquestion-belongs_to-customer
      20:12:44,141 DEBUG [Customer] Foreign key constraint not added as requested: relationshipRolename=customer-has-account
      20:12:44,165 DEBUG [Customer] Foreign key constraint not added as requested: relationshipRolename=account-belongs_to-customer
      20:12:44,167 DEBUG [Customer] Foreign key constraint not added as requested: relationshipRolename=customer-has-orders
      20:12:44,172 DEBUG [Customer] Foreign key constraint not added as requested: relationshipRolename=order-belongs_to-customer
      20:12:44,173 DEBUG [Customer#findByPrimaryKey] SQL: SELECT userId FROM t_customer WHERE userId=?
      20:12:44,174 DEBUG [Customer] Added findByPrimaryKey query command for local home interface
      20:12:44,175 DEBUG [Customer#findByEmail] EJB-QL: SELECT OBJECT(c) FROM Customer AS c WHERE c.email = ?1

      The app is working and I have not yet observed any problems, but maybe there are problems on the way..?

      Please tell me if I have to take any action in regard to the output in the log.

      Regards

      Andreas