Bugs item #648094, was opened at 2002-12-03 23:49 Message generated for change (Comment added) made by pilhuhn You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=648094&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Peter Luttrell (objec) Assigned to: Nobody/Anonymous (nobody) Summary: Create Table+Constraints Initial Comment: JBoss3.0.3 Using PostgreSQL, with the following config: <datasource>java:/myPostgreSqlDS</datasource> <datasource-mapping>PostgreSQL</datasource- mapping> <create-table>true</create-table> <remove-table>false</remove-table> <read-only>false</read-only> <pk-constraint>false</pk-constraint> <fk-constraint>true</fk-constraint> Didn't work. It complained that the related tables did not exist when one of the constraints was created, i believe the fk. Then the next time that I ran, it got further...after 6or7 deploys it worked completely, but the fk constrainst aren't all there. 16:27:36,530 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=Users,service=EJB org.jboss.deployment.DeploymentException: Error while adding foreign key constraint; - nested throwable: (java.sql.SQLException: ERROR: UNIQUE constraint matching given keys for referenced table "generic_user" not found) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.add ForeignKeyConstraint(JDBCStartCommand.java:384) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.add ForeignKeyConstraint(JDBCStartCommand.java:295) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.exe cute(JDBCStartCommand.java:123) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start StoreManager(JDBCStoreManager.java:457) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start (JDBCStoreManager.java:369) at org.jboss.ejb.plugins.CMPPersistenceManager.start (CMPPersistenceManager.java:198) at org.jboss.ejb.EntityContainer.start (EntityContainer.java:376) at org.jboss.ejb.Container.invoke (Container.java:756) at org.jboss.ejb.EntityContainer.invoke (EntityContainer.java:1058) at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:517) at org.jboss.system.ServiceController$ServiceProxy.invoke (ServiceController.java:976) at $Proxy5.start(Unknown Source) at org.jboss.system.ServiceController.start (ServiceController.java:397) at sun.reflect.GeneratedMethodAccessor6.invoke (Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invok e(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:517) at org.jboss.util.jmx.MBeanProxy.invoke (MBeanProxy.java:174) at $Proxy231.start(Unknown Source) at org.jboss.ejb.EjbModule.startService (EjbModule.java:430) at org.jboss.system.ServiceMBeanSupport.start (ServiceMBeanSupport.java:164) at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invok e(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:517) at org.jboss.system.ServiceController$ServiceProxy.invoke (ServiceController.java:976) at $Proxy5.start(Unknown Source) at org.jboss.system.ServiceController.start (ServiceController.java:397) at sun.reflect.GeneratedMethodAccessor6.invoke (Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invok e(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:517) at org.jboss.util.jmx.MBeanProxy.invoke (MBeanProxy.java:174) at $Proxy11.start(Unknown Source) at org.jboss.ejb.EJBDeployer.start (EJBDeployer.java:394) at org.jboss.deployment.MainDeployer.start (MainDeployer.java:802) at org.jboss.deployment.MainDeployer.start (MainDeployer.java:794) at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:616) at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:580) at sun.reflect.GeneratedMethodAccessor9.invoke (Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invok e(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:517) at org.jboss.util.jmx.MBeanProxy.invoke (MBeanProxy.java:174) at $Proxy4.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner. deploy(URLDeploymentScanner.java:427) at org.jboss.deployment.scanner.URLDeploymentScanner. scanDirectory(URLDeploymentScanner.java:648) at org.jboss.deployment.scanner.URLDeploymentScanner. scan(URLDeploymentScanner.java:499) at org.jboss.deployment.scanner.AbstractDeploymentScan ner$ScannerThread.doScan (AbstractDeploymentScanner.java:212) at org.jboss.deployment.scanner.AbstractDeploymentScan ner$ScannerThread.loop (AbstractDeploymentScanner.java:225) at org.jboss.deployment.scanner.AbstractDeploymentScan ner$ScannerThread.run (AbstractDeploymentScanner.java:202) Caused by: java.sql.SQLException: ERROR: UNIQUE constraint matching given keys for referenced table "generic_user" not found at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:94) at org.postgresql.Connection.ExecSQL (Connection.java:398) at org.postgresql.jdbc2.Statement.execute (Statement.java:130) at org.postgresql.jdbc2.Statement.executeUpdate (Statement.java:73) at org.jboss.resource.adapter.jdbc.local.LocalStatement.ex ecuteUpdate(LocalStatement.java:231) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.add ForeignKeyConstraint(JDBCStartCommand.java:375) ... 55 more ---------------------------------------------------------------------- >Comment By: Heiko W.Rupp (pilhuhn) Date: 2003-08-26 17:07 Message: Logged In: YES user_id=217112 What Jboss Version is this exactly? Does this persist with a 3.2 series? Have some of the tables not been created by Jboss? There is code in JDBCStartCommand that should prevent this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=648094&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0 _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development