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 18:02
Message:
Logged In: YES
user_id=217112
Eww.. I completely overlooked the 3.0.3 at the top .
----------------------------------------------------------------------
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