Has anybody been successful in deploying EJBs on Orion to an Oracle database? I'm having trouble getting Orion to auto create tables in Oracle. It seems to skip certain table names in the ejb-jar.xml file I use. The tables it creates consistently are Category, Item and Note.
Here's the file:
<?xml version="1.0"?>
<!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN' 'http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd'>
<ejb-jar>
<enterprise-beans>
<entity>
<description>Generates globally unique identifiers by combining the
identity of a given GUIDFactory with a generated value unique among all
values generated by the given GUIDFactory.</description>
<display-name>GUID_Factory_Component</display-name>
<ejb-name>GUIDFactory</ejb-name>
<home>com.canlink.components.base.GUIDFactoryHome</home>
<remote>com.canlink.components.base.GUIDFactory</remote>
<ejb-class>com.canlink.components.base.GUIDFactoryBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.canlink.components.base.GUIDFactoryPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>factoryID</field-name>
</cmp-field>
<cmp-field>
<field-name>currentObjectID</field-name>
</cmp-field>
</entity>
<entity>
<description>Persistent Business Object representing an ordered list
of products</description>
<display-name>Catalog_Component</display-name>
<ejb-name>Catalog</ejb-name>
<home>com.canlink.components.entities.catalog.CatalogHome</home>
<remote>com.canlink.components.entities.catalog.Catalog</remote>
<ejb-class>com.canlink.components.entities.catalog.CatalogBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.canlink.components.base.EntityPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>identity</field-name>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
</cmp-field>
<cmp-field>
<field-name>organizationIdentity</field-name>
</cmp-field>
<cmp-field>
<field-name>ownerIdentity</field-name>
</cmp-field>
<cmp-field>
<field-name>creationDate</field-name>
</cmp-field>
<cmp-field>
<field-name>layout</field-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
</cmp-field>
<ejb-ref>
<ejb-ref-name>ejb/GUIDFactory</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<home>com.canlink.components.base.GUIDFactoryHome</home>
<remote>com.canlink.components.base.GUIDFactory</remote>
<ejb-link>GUIDFactory</ejb-link>
</ejb-ref>
</entity>
<entity>
<description>Persistent Business Object representing a grouping of catalog
entries</description>
<display-name>Category_Component</display-name>
<ejb-name>Category</ejb-name>
<home>com.canlink.components.entities.category.CategoryHome</home>
<remote>com.canlink.components.entities.category.Category</remote>
<ejb-class>com.canlink.components.entities.category.CategoryBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.canlink.components.base.EntityPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>identity</field-name>
</cmp-field>
<cmp-field>
<field-name>title</field-name>
</cmp-field>
<cmp-field>
<field-name>description</field-name>
</cmp-field>
<cmp-field>
<field-name>extendedDescription</field-name>
</cmp-field>
<cmp-field>
<field-name>image</field-name>
</cmp-field>
<cmp-field>
<field-name>thumbnail</field-name>
</cmp-field>
<cmp-field>
<field-name>creationDate</field-name>
</cmp-field>
</entity>
<entity>
<description>Persistent Business Object representing a products Note</description>
<display-name>Note_Component</display-name>
<ejb-name>Note</ejb-name>
<home>com.canlink.components.entities.note.NoteHome</home>
<remote>com.canlink.components.entities.note.Note</remote>
<ejb-class>com.canlink.components.entities.note.NoteBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.canlink.components.entities.note.NotePK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>title</field-name>
</cmp-field>
<cmp-field>
<field-name>description</field-name>
</cmp-field>
<cmp-field>
<field-name>creationDate</field-name>
</cmp-field>
</entity>
<entity>
<description>Persistent Business Object representing a productItem</description>
<display-name>Item_Component</display-name>
<ejb-name>Item</ejb-name>
<home>com.canlink.components.entities.item.ItemHome</home>
<remote>com.canlink.components.entities.item.Item</remote>
<ejb-class>com.canlink.components.entities.item.ItemBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.canlink.components.entities.item.ItemPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>productCode</field-name>
</cmp-field>
<cmp-field>
<field-name>productTitle</field-name>
</cmp-field>
<cmp-field>
<field-name>description</field-name>
</cmp-field>
<cmp-field>
<field-name>extendedDescription</field-name>
</cmp-field>
<cmp-field>
<field-name>costOfGoods</field-name>
</cmp-field>
<cmp-field>
<field-name>basePrice</field-name>
</cmp-field>
<cmp-field>
<field-name>weight</field-name>
</cmp-field>
<cmp-field>
<field-name>inventory</field-name>
</cmp-field>
<cmp-field>
<field-name>GST</field-name>
</cmp-field>
<cmp-field>
<field-name>PST</field-name>
</cmp-field>
<cmp-field>
<field-name>largeImage</field-name>
</cmp-field>
<cmp-field>
<field-name>thumbnailImage</field-name>
</cmp-field>
</entity>
<entity>
<description>Persistent Business Object representing an Organization</description>
<display-name>Organization_Component</display-name>
<ejb-name>Organization</ejb-name>
<home>com.canlink.components.entities.party.OrganizationHome</home>
<remote>com.canlink.components.entities.party.Organization</remote>
<ejb-class>com.canlink.components.entities.party.OrganizationBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.canlink.components.entities.party.OrganizationPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-field>
<field-name>identity</field-name>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
</cmp-field>
<cmp-field>
<field-name>creationDate</field-name>
</cmp-field>
<ejb-ref>
<ejb-ref-name>ejb/GUIDFactory</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<home>com.canlink.components.base.GUIDFactoryHome</home>
<remote>com.canlink.components.base.GUIDFactory</remote>
<ejb-link>GUIDFactory</ejb-link>
</ejb-ref>
</entity>
<session>
<description>Use Case controller for producers</description>
<display-name>ProducerServices</display-name>
<ejb-name>ProducerServices</ejb-name>
<home>com.canlink.components.services.ProducerServicesHome</home>
<remote>com.canlink.components.services.ProducerServices</remote>
<ejb-class>com.canlink.components.services.ProducerServicesBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<ejb-ref>
<description>Catalog Component that Producers wotk with</description>
<ejb-ref-name>ejb/Catalog</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<home>com.canlink.components.entities.catalog.CatalogHome</home>
<remote>com.canlink.components.entities.catalog.Catalog</remote>
<ejb-link>Catalog</ejb-link>
</ejb-ref>
</session>
</enterprise-beans>
<assembly-descriptor>
<security-role>
<description>Customer Service
Representative</description>
<role-name>CSR</role-name>
</security-role>
<method-permission>
<description>Restricted</description>
<role-name>CSR</role-name>
<method>
<ejb-name>com.canlink.components.services.ProducerServices</ejb-name>
<method-name>*</method-name>
</method>
</method-permission>
<container-transaction>
<method>
<description>Generates globally unique identifiers by combining the
identity of a given GUIDFactory with a generated value unique among all
values generated by the given GUIDFactory.</description>
<ejb-name>GUIDFactory</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>NotSupported</trans-attribute>
</container-transaction>
</assembly-descriptor>
</ejb-jar>
Any help would be appreciated as I am at a loss......
Thx......
