Bugs item #555556, was opened at 2002-05-13 12:57 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=555556&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole >Status: Closed >Resolution: Works For Me Priority: 5 Submitted By: Jeff DeLong (jeffdelong) Assigned to: Dain Sundstrom (dsundstrom) Summary: CMR Table Creation Initial Comment: I have two Entity EJBs (UserEJB and GroupEJB) with a Many relationship between them. They deploy and test correctly with the exception that the relationship table does not appear to be created in my Oracle table space (the ORG_USER and ORG_GROUP tables are created, and deleted, correctly as per the jbosscmp-jdbc.xml (see attached). I believe the relationship table may be created in the DefaultDS. Here is a snippet from the console output when starting JBoss (this is with JBoss 3.0RC2 running on NT4.0 with JDK 1.3.1, database is Oracle 9i running on Solaris 2.8), the server log can be provided if necessary). 11:25:50,923 INFO [GroupEJB] Created table 'ORG_GROUP' successfully. 11:25:51,313 INFO [UserEJB] Created table 'ORG_USER' successfully. 11:25:51,363 INFO [UserEJB] Table 'GROUPEJB_USERS_USEREJB_GROUPS' already exist s 11:25:51,373 INFO [EjbModule] Started ---------------------------------------------------------------------- >Comment By: Dain Sundstrom (dsundstrom) Date: 2002-06-06 00:40 Message: Logged In: YES user_id=251431 Looks like jeffdelong fixed this in his code. ---------------------------------------------------------------------- Comment By: Jeff DeLong (jeffdelong) Date: 2002-06-03 21:36 Message: Logged In: YES user_id=531609 Retested with the correct DTD reference and everything works fine. ---------------------------------------------------------------------- Comment By: Jeff DeLong (jeffdelong) Date: 2002-05-14 09:49 Message: Logged In: YES user_id=531609 attachment may have been too large - here is a snippet ---------------------------------------------------------------------- Comment By: Jeff DeLong (jeffdelong) Date: 2002-05-14 09:44 Message: Logged In: YES user_id=531609 here is the server log - it appears to barf on many of the elements! ---------------------------------------------------------------------- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-05-14 00:02 Message: Logged In: YES user_id=251431 The important messages are printed before this error. It will say some thing like "blah is not allowed here" The second issue about DTDs in IE is an known IE bug just download the file and read it directly. ---------------------------------------------------------------------- Comment By: Jeff DeLong (jeffdelong) Date: 2002-05-13 22:48 Message: Logged In: YES user_id=531609 The problem may be attributable to the lack of DTD reference at the top of the jbosscmp-jdbc.xml file, however when I put <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp- jdbc_3_0.dtd"> I get the following: org.jboss.deployment.DeploymentException: error in create of EjbModule: file:/G: /jboss-3.0.0RC2/server/default/deploy/organization.jar; - nested throwable: (org .jboss.deployment.DeploymentException: Invalid XML: file=file:/G:/jboss-3.0.0RC2 /server/default/tmp/deploy/server/default/deploy/organizatio n.jar/87.organizatio n.jar!/META-INF/jbosscmp-jdbc.xml) Also when I try to access http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd I get Cannot have a DTD declaration outside of a DTD. Line 13, Position 11 <!ELEMENT jbosscmp-jdbc (defaults?, enterprise-beans?, relationships?, ----------^ ---------------------------------------------------------------------- Comment By: Jeff DeLong (jeffdelong) Date: 2002-05-13 13:23 Message: Logged In: YES user_id=531609 If I change my standardjbosscmp-jdbc.xml file's DefaultDS to set remove-table to true, and recycle JBoss, then the table is first deleted and then created: 12:19:43,050 INFO [GroupEJB] Created table 'ORG_GROUP' successfully. 12:19:43,431 INFO [UserEJB] Created table 'ORG_USER' successfully. 12:19:43,531 INFO [UserEJB] Created table 'GROUPEJB_USERS_USEREJB_GROUPS' succe ssfully. 12:19:43,541 INFO [EjbModule] Started however it still does not appear in the Oracle table space. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=555556&group_id=22866 _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
