Hi, I am trying to deploy my Employee and Phone EJB which has 1:N relationship. But I am getting the following error as the fkey name generated by jboss is longer than supported by Cloudscape. Is there a setting in jboss to generate a smaller key name? -------------------------- org.jboss.deployment.DeploymentException: Error while adding foreign key constraint; - nested throwable: (SQL Exception: The name 'FK_PHONE_EMPLOYEELOCAL' is too long. The maximum length is '18'.) ----- Caused by: SQL Exception: The name 'FK_PHONE_EMPLOYEELOCAL' is too long. The maximum length is '18'. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java) at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:272) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.addForeignKeyConstraint(JDBCStartCommand.java:1064)
Thanks, Roy View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3874846#3874846 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3874846 ------------------------------------------------------- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user