here are the relevant portions of the jbosscmp-jdbc.xml file
| <entity> | <ejb-name>StoryEJB</ejb-name> | <create-table>true</create-table> | <remove-table>true</remove-table> | <pk-constraint>true</pk-constraint> | <table-name>nuke_news_stories</table-name> | | <cmp-field> | <field-name>allowComments</field-name> | <column-name>allow_comments</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>state</field-name> | <column-name>state</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>storyAdminNotes</field-name> | <column-name>admin_notes</column-name> | | </cmp-field> | <cmp-field> | <field-name>storyID</field-name> | <column-name>story_id</column-name> | <not-null/> | | <jdbc-type>INTEGER</jdbc-type> | <sql-type>SERIAL</sql-type> | | <auto-increment/> | <dbindex/> | </cmp-field> | <cmp-field> | <field-name>storySummary</field-name> | <column-name>summary</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>storyText</field-name> | <column-name>ext_text</column-name> | | </cmp-field> | <cmp-field> | <field-name>storyTitle</field-name> | <column-name>title</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>views</field-name> | <column-name>views</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>creationDate</field-name> | <column-name>create_date</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>IP</field-name> | <column-name>ip_addr</column-name> | <not-null/> | | </cmp-field> | | <!-- finders removed --> | <entity-command name="nukes-entity-command"> | </entity-command> | </entity> | | <entity> | <ejb-name>TopicEJB</ejb-name> | <create-table>true</create-table> | <remove-table>true</remove-table> | <pk-constraint>true</pk-constraint> | <table-name>nuke_news_topics</table-name> | | <cmp-field> | <field-name>state</field-name> | <column-name>state</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>topicID</field-name> | <column-name>topic_id</column-name> | <not-null/> | | <jdbc-type>INTEGER</jdbc-type> | <sql-type>SERIAL</sql-type> | | <auto-increment/> | <dbindex/> | </cmp-field> | <cmp-field> | <field-name>topicImage</field-name> | <column-name>image</column-name> | | </cmp-field> | <cmp-field> | <field-name>topicName</field-name> | <column-name>name</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>topicText</field-name> | <column-name>text</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>views</field-name> | <column-name>views</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>creationDate</field-name> | <column-name>create_date</column-name> | <not-null/> | | </cmp-field> | <cmp-field> | <field-name>IP</field-name> | <column-name>ip_addr</column-name> | <not-null/> | | </cmp-field> | | <!-- finders removed> | <entity-command name="nukes-entity-command"> | </entity-command> | </entity> | | <ejb-relation> | <ejb-relation-name>Topic-Story</ejb-relation-name> | | <ejb-relationship-role> | <ejb-relationship-role-name>Story-belongsto-Topic</ejb-relationship-role-name> | <key-fields/> | | </ejb-relationship-role> | <ejb-relationship-role> | <ejb-relationship-role-name>Topic-has-Stories</ejb-relationship-role-name> | <key-fields> | <key-field> | <field-name>topicID</field-name> | <column-name>topic_id</column-name> | </key-field> | </key-fields> | | </ejb-relationship-role> | </ejb-relation> | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835383#3835383 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835383 ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user