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-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>
</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
