RE: Oracle on Orion

[Arved Sandstrom]

What is the nature of the console errors? That is, when you run Orion the first time around, you'll get your auto-create messages, success or failure. Should be quite revealing.

 

I initially suspected table name length, but some of those that you say succeed seem to be no shorter than some that fail, so without an idea of what the messages say...

 

FWIW we routinely use Oracle, and some of the tables are autocreated. Works OK.

 

Arved Sandstrom

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Evans
Sent: Wednesday, October 18, 2000 7:15 PM
To: Orion-Interest
Subject: Oracle on Orion

Hey,

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