Do you have the DOCTYPE XML header at the top of your files? This will also
help in placement and accidental misspellings tags. I learned that one the hard
way! :)
--
-bk
Quoting "Gary S. Cuozzo" <[EMAIL PROTECTED]>:
> To: Christofer Sandberg
>
> I would like to personally thank you for helping me out. I just got a
> chance to give this a look and guess what? IT WORKED!!!!!!!!!!! The
> only other things I had to fix were
> <table-key-fields> --> <key-fields>
> <table-key-field> --> <key-field>
>
> So, now that I have many-to-many relationships working, I can really
> make some progress...
>
> Thanks again, this list is really great.
>
> I hope someday to return the favor to somebody else. :-)
>
> gary.
>
>
> Christofer Sandberg wrote:
>
> >I think the table mapping xml tags are named diffrently and are in another
>
> >structure then the one you supplied assuming you are running JBoss 3.0
> >something.
> >
> >Try replacing the relationships part in your jbosscmp-jdbc.xml with the
> >following:
> >
> ><relationships>
> > <ejb-relation>
> > <ejb-relation-name>Client-Acl</ejb-relation-name>
> > <relation-table-mapping>
> > <table-name>client_acl</table-name>
> > </relation-table-mapping>
> > <create-table>false</create-table>
> > <remove-table>false</remove-table>
> > <ejb-relationship-role>
> > <ejb-relationship-role-name>client-has-acls</ejb-relationship-role-name>
> > <table-key-fields>
> > <table-key-field>
> > <field-name>id</field-name>
> > <column-name>client_id</column-name>
> > </table-key-field>
> > </table-key-fields>
> > </ejb-relationship-role>
> > <ejb-relationship-role>
> > <ejb-relationship-role-name>acl-has-clients</ejb-relationship-role-name>
> > <table-key-fields>
> > <table-key-field>
> > <field-name>id</field-name>
> > <column-name>acl_id</column-name>
> > </table-key-field>
> > </table-key-fields>
> > </ejb-relationship-role>
> > </ejb-relation>
> ></relationships>
> >
> >
> >/Christofer
> >
> >On Saturday 08 June 2002 03.02, you wrote:
> >
> >>I left out the entity bean stuff as it is pretty long. Let me know if
> you
> >>see my problem or if you want to see other files.
> >>gary.
> >>
> >>
> >><?xml version="1.0" encoding="UTF-8"?>
> >>
> >><!--
> =====================================================================
> >>--> <!--
>
> >> --> <!-- Standard JBossCMP-JDBC Configuration
>
> >> --> <!--
>
> >> --> <!--
> >>===================================================================== -->
> >>
> >><!-- $Id: jbosscmp-jdbc.xml,v 1.1 2002/04/07 06:22:31 gary Exp $ -->
> >>
> >><jbosscmp-jdbc>
> >> <defaults>
> >> <datasource>java:/ISG_DS</datasource>
> >> <type-mapping>PostgreSQL</type-mapping>
> >> <debug>true</debug>
> >> <create-table>false</create-table>
> >> <remove-table>false</remove-table>
> >> <read-only>false</read-only>
> >> <time-out>300</time-out>
> >> <pk-constraint>true</pk-constraint>
> >> <fk-constraint>false</fk-constraint>
> >> <row-locking>false</row-locking>
> >> <select-for-update>false</select-for-update>
> >> <relation-mapping-style>foreign-key</relation-mapping-style>
> >> <read-ahead>
> >>
<strategy>on-load</strategy>
> >>
<page-size>1000</page-size>
> >>
<eager-load-group>*</eager-load-group>
> >> </read-ahead>
> >> <list-cache-max>1000</list-cache-max>
> >> <alias-header-prefix>t</alias-header-prefix>
> >> </defaults>
> >> <relationships>
> >> <ejb-relation>
> >>
<ejb-relation-name>Client-Acl</ejb-relation-name>
> >>
<table-mapping>
> >>
<table-name>client_acl</table-name>
> >>
<create-table>false</create-table>
> >>
<remove-table>false</remove-table>
> >>
<ejb-relationship-role>
> >>
<ejb-relationship-role-name>client-has-acls</ejb-relationship-role-nam
> >>e> <table-key-fields>
> >>
<table-key-field>
> >>
<field-name>id</field-name>
> >>
<column-name>client_id</column-name>
> >>
</table-key-field>
> >>
</table-key-fields>
> >>
</ejb-relationship-role>
> >>
<ejb-relationship-role>
> >>
<ejb-relationship-role-name>acl-has-clients</ejb-relationship-role-nam
> >>e> <table-key-fields>
> >>
<table-key-field>
> >>
<field-name>id</field-name>
> >>
<column-name>acl_id</column-name>
> >>
</table-key-field>
> >>
</table-key-fields>
> >>
</ejb-relationship-role>
> >>
</table-mapping>
> >> </ejb-relation>
> >> </relationships>
> >></jbosscmp-jdbc>
> >>
> >>Arthur Wang wrote:
> >>
> >>>please post your many-to-many relationship defination in
> >>>jbosscmp-jdbc.xml.
> >>>
> >>>-----Original Message-----
> >>>
> >>From: Gary S. Cuozzo [mailto:[EMAIL PROTECTED]]
> >>
> >>>Sent: Friday, June 07, 2002 5:21 PM
> >>>To: [EMAIL PROTECTED]
> >>>Subject: Re: [JBoss-user] Auto created relationship table name.
> >>>
> >>>
> >>>This seems similar to the problem that I am seeing. I am not
> >>>auto-creating the table, but instead have an existing table that I want
> >>>to use.
> >>>
> >>>When I try to use my many-to-many relationship, I get exceptions because
> >>>the table (that jboss is trying to use) doesn't exist. I have no idea
> >>>what I am doing wrong, but am looking at the recently posted cmr-example
> >>>right now.
> >>>
> >>>Currently, I have never gotten a table-mapped relationship to work.
> >>>
> >>>Anybody seen this problem & fixed it? I actually posted a report a few
> >>>nights ago, but did not get any responses.
> >>>
> >>>I'll be sure to let you know if/when I figure this out.
> >>>
> >>>gary.
> >>>
> >>>Arthur Wang wrote:
> >>>
> >>>>I set create-table as true in my jbosscmp-jdbc.xml, so the jboss will
> >>>>
> >>>create
> >>>
> >>>>table for me, but the name of relation table created is like
> 'A-Bs-B-As",
> >>>>
> >>>it
> >>>
> >>>>is not the name I specified in relation-table-mapping of
> >>>>jbosscmp-jdbc.xml.
> >>>>
> >>>>-----Original Message-----
> >>>>From: Dain Sundstrom [mailto:[EMAIL PROTECTED]]
> >>>>Sent: Friday, June 07, 2002 4:27 PM
> >>>>To: [EMAIL PROTECTED]
> >>>>Subject: Re: [JBoss-user] Auto created relationship table name.
> >>>>
> >>>>Arthur Wang wrote:
> >>>>
> >>>>>Hi ,
> >>>>>
> >>>>>I have a many to many relationship betwen two beans, and I specify the
> >>>>>relation table in the ejb-jar.xml file, but when set the create-table
> as
> >>>>>true in jbosscmp-jdbc.xml, the created relation table has a different
> >>>>>name as the one I specified in the relationship defination, this
> should
> >>>>>not be
> >>>>>
> >>>>a
> >>>>
> >>>>>problem if I use existing table, but in this case(create table when
> >>>>>
> >>>>deploy),
> >>>>
> >>>>>many to many relationship may not working. Any idea on it?
> >>>>>
> >>>>I don't understand you. Can you be more specific?
> >>>>
> >>>>-dain
> >>>>
> >>>>
> >>>>
> >>>>_______________________________________________________________
> >>>>
> >>>>Don't miss the 2002 Sprint PCS Application Developer's Conference
> >>>>August 25-28 in Las Vegas -
> >>>>http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
> >>>>
> >>>>_______________________________________________
> >>>>JBoss-user mailing list
> >>>>[EMAIL PROTECTED]
> >>>>https://lists.sourceforge.net/lists/listinfo/jboss-user
> >>>>
> >>>>_______________________________________________________________
> >>>>
> >>>>Don't miss the 2002 Sprint PCS Application Developer's Conference
> >>>>August 25-28 in Las Vegas -
> >>>>
> >>>http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
> >>>
> >>>>_______________________________________________
> >>>>JBoss-user mailing list
> >>>>[EMAIL PROTECTED]
> >>>>https://lists.sourceforge.net/lists/listinfo/jboss-user
> >>>>
> >>>_______________________________________________________________
> >>>
> >>>Don't miss the 2002 Sprint PCS Application Developer's Conference
> >>>August 25-28 in Las Vegas -
> >>>http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
> >>>
> >>>_______________________________________________
> >>>JBoss-user mailing list
> >>>[EMAIL PROTECTED]
> >>>https://lists.sourceforge.net/lists/listinfo/jboss-user
> >>>
> >>>_______________________________________________________________
> >>>
> >>>Don't miss the 2002 Sprint PCS Application Developer's Conference
> >>>August 25-28 in Las Vegas -
> >>>http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
> >>>
> >>>_______________________________________________
> >>>JBoss-user mailing list
> >>>[EMAIL PROTECTED]
> >>>https://lists.sourceforge.net/lists/listinfo/jboss-user
> >>>
> >>_______________________________________________________________
> >>
> >>Don't miss the 2002 Sprint PCS Application Developer's Conference
> >>August 25-28 in Las Vegas -
> >>http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
> >>
> >>_______________________________________________
> >>JBoss-user mailing list
> >>[EMAIL PROTECTED]
> >>https://lists.sourceforge.net/lists/listinfo/jboss-user
> >>
> >
> >_______________________________________________________________
> >
> >Don't miss the 2002 Sprint PCS Application Developer's Conference
> >August 25-28 in Las Vegas -
> http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
> >
> >_______________________________________________
> >JBoss-user mailing list
> >[EMAIL PROTECTED]
> >https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
>
>
>
> _______________________________________________________________
>
> Multimillion Dollar Computer Inventory
> Live Webcast Auctions Thru Aug. 2002 -
> http://www.cowanalexander.com/calendar
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________________________
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
