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
