Re: [openejb-user] Multiple databases under OpenEJB

Mon, 15 Aug 2005 09:59:32 -0700

Ok, so I am replying to this email twice as I want to discuss some 1.0 stuff in relation to your apps without confusing things (life in 0.9.2 vs. 1.0).
So if I understand your situation correctly, you have two webapps and two ejb jars running in Tomcat 5.0.x and OpenEJB 0.9.2. In essence, you have two unrelated apps; GetIMG and NPhoneCard. In the 0.9.2 you have to smush the ejbs together into the same openejb.conf because there is only one OpenEJB instance for all of Tomcat and webapps. But in the 1.0 code you could actually have two separately managed OpenEJB instances, which seems like what you were trying to do. 

How would a setup like the following suit your needs?

webapps/
    GetIMG/
        META-INF/ejb-jar.xml
        META-INF/openejb.xml
        META-INF/openejb-jar.xml
        META-INF/postgresql.cmp_global_database.xml
        META-INF/postgresql.cmp_local_database.xml
        META-INF/postgresql.cmp_or_mapping.xml
        WEB-INF/web.xml
        WEB-INF/lib/openejb-loader-1.0.jar
        WEB-INF/classes/<all your servlet and ejb classes>

    NPhoneCard
        META-INF/ejb-jar.xml
        META-INF/openejb.xml
        META-INF/openejb-jar.xml
        META-INF/postgresql.cmp_global_database.xml
        META-INF/postgresql.cmp_local_database.xml
        META-INF/postgresql.cmp_or_mapping.xml
        WEB-INF/web.xml
        WEB-INF/lib/openejb-loader-1.0.jar
        WEB-INF/classes/<all your servlet and ejb classes>


The idea expressed here is that each app is an independent mix of  
servlets and ejbs.  Tomcat manages the serlvets and OpenEJB manages  
the ejbs.  You might think of each app as a "collapsed" ear; ejbs and  
servlets packaged together in the same archive and run in the same  
classloader.  I'm not sure if we can get Castor to play nice with  
having the mapping files in your webapp, but the rest is possible.



I'm working on code now to allow for this exact setup and looking for  
someone to try it out.  Seems you have a great use-case.



1) Is this close to what you are trying to do and 2) are you  
interested in trying this out?


-David

On Aug 12, 2005, at 4:58 PM, Maurice Yarrow wrote:


Hello OpenEJB users

I am an OpenEJB user and have a Single-sign-on site with 7 tables.
There are, in essence, three applications currently and it would

make sense to have these 7 tables organized into 3 separate  
databases. When I had originally tried to write the configurations  
to do this,

only the first Castor mapping to be accessed was observed by the
OpenEJB, and subsequently accessing the tables in the second database
was errored.  Does anyone have an example of openejb.conf and
postgresql.cmp.global-database.xml
postgresql.cmp.local-database.xml
postgresql.cmp.or-mapping.xml
(or equivalent for some other db) that accesses two or more
OpenEJB jars?

Below is the context of a message I sent in March, but which
evidently slipped throught the cracks and went unanswered.
It contains (almost) all details.

Thanks much

Maurice Yarrow


Hello User-help

I have had no problem configuring and using 0.9.2
for one jar deployment.  But two bean jar deployments
is problematic.
I am running tomcat on linux, using postgresql.
Have added appropriate container and connector elements
to the openejb.conf in the conf dir.  The beans in the
jar each map to a database with three tables.

I set up my second web app bean configuration to
look like the first, with appropriate attribute
changes.

Am running openejb-0.9.2 as embedded VM server.
Using tomcat 5.0.28

Beans deployed using deploy tool successfully, etc.

When I restart tomcat, whichever of the two
web apps that I test first runs and queries the
database just fine.  But when I then test the second
web app, as soon as it tries to query its appropriate
table in its database, it gets the following message
below:  (this error is symmetrical with respect to
the other EJB jar and its respective tables when app
starting sequence is reversed after restarting tomcat.)
Also note that after tomcat is restarted, there are no
errors indicated either in the tomcat log file or the
openejb.log file, and all beans appear to have been
appropriately deployed by the openejb container system,
as indicated in the openejb.log.

javax.ejb.FinderException: Castor JDO could not execute query for
this finder method.

QueryException: Could not find mapping for class  
nphonecard.beans.userdata.UserDataBean
    at  
org.openejb.alt.containers.castor_cmp11.CastorCMP11_EntityContainer.fi 
ndEJBObject(CastorCMP11_EntityContainer.java:1103)
    at  
org.openejb.alt.containers.castor_cmp11.CastorCMP11_EntityContainer.in 
voke(CastorCMP11_EntityContainer.java:524)
    at org.openejb.core.entity.EntityEjbHomeHandler.findX 
(EntityEjbHomeHandler.java:125)
    at org.openejb.core.ivm.EjbHomeProxyHandler._invoke 
(EjbHomeProxyHandler.java:152)
    at org.openejb.core.ivm.BaseEjbProxyHandler.invoke 
(BaseEjbProxyHandler.java:327)
    at org.openejb.util.proxy.Jdk13InvocationHandler.invoke 
(Jdk13InvocationHandler.java:89)

    at $Proxy1.findByUserName(Unknown Source)

    at nphonecard.servlets.PassWordCheckServlet.doPost 
(PassWordCheckServlet.java:128)


etc...


Before we go any further: *many*, *many* thanks to anyone who  
attemps to

tackle this problem!


Now, certainly, it would be impossible for anyone to help me  
diagnose this error I am getting without including the appropriate  
configuration
and resource files.  And this, of course, is where this letter will  
get
to be a little bit of a mess, because there are a bunch of these  
files.


However, here they are:
(Note that the mozilla mailer is forcing some newlines into these
included texts, but the actual files do not contain these)

(Note:  If I have ommitted from this letter any file that is important
for diagnosing the indicated problem, do not hesitate to send a
request to me for this information.)


There are two bean jars:  nphonecardEJB.jar and getimgEJB.jar

The openejb.xml for nphonecardEJB.jar:

<!-- ------------------------------------------------------------ -->
<openejb xmlns="http://www.openejb.org/System/Configuration";>
  <Container id="nphonecardEJB CMP Container" ctype="CMP_ENTITY">

    Global_TX_Database /home/yarrow/NPhoneCard/src/nphonecard/beans/ 
conf/postgresql.cmp_global_database.xml
    Local_TX_Database /home/yarrow/NPhoneCard/src/nphonecard/beans/ 
conf/postgresql.cmp_local_database.xml

  </Container>
  <Deployments jar="beans/nphonecardEJB.jar"/>
  <Connector id="nphonecardEJB JDBC Database">
    JdbcDriver org.postgresql.Driver
    JdbcUrl jdbc:postgresql://localhost/nphonecard?compatible=7.1
    UserName yarrow
    Password ""
  </Connector>
  <SecurityService id="Default Security Service"/>
  <TransactionService id="Default Transaction Manager"/>
</openejb>
<!-- ------------------------------------------------------------ -->


The openejb.xml for getimgEJB.jar:

<!-- ------------------------------------------------------------ -->
<openejb xmlns="http://www.openejb.org/System/Configuration";>

  <Container id="getimgEJB CMP Container" ctype="CMP_ENTITY">

    Global_TX_Database /home/yarrow/GetImg/src/getimg/beans/conf/ 
postgresql.cmp_global_database.xml
    Local_TX_Database /home/yarrow/GetImg/src/getimg/beans/conf/ 
postgresql.cmp_local_database.xml

  </Container>
  <Deployments jar="beans/getimgEJB.jar"/>
  <Connector id="getimgEJB JDBC Database">
    JdbcDriver org.postgresql.Driver
    JdbcUrl jdbc:postgresql://localhost/getimg?compatible=7.1
    UserName yarrow
    Password ""
  </Connector>
  <SecurityService id="Default Security Service"/>
  <TransactionService id="Default Transaction Manager"/>
</openejb>
<!-- ------------------------------------------------------------ -->


Here is the main openejb/conf/openejb.conf file:  (default definitions
have been deleted in this included copy for brevity's sake)

<!-- ------------------------------------------------------------ -->
  <Container id="getimgEJB CMP Container" ctype="CMP_ENTITY">

    Global_TX_Database /home/yarrow/GetImg/src/getimg/beans/conf/ 
postgresql.cmp_global_database.xml
    Local_TX_Database /home/yarrow/GetImg/src/getimg/beans/conf/ 
postgresql.cmp_local_database.xml

  </Container>

  <Container id="nphonecardEJB CMP Container" ctype="CMP_ENTITY">

    Global_TX_Database /home/yarrow/NPhoneCard/src/nphonecard/beans/ 
conf/postgresql.cmp_global_database.xml
    Local_TX_Database /home/yarrow/NPhoneCard/src/nphonecard/beans/ 
conf/postgresql.cmp_local_database.xml

  </Container>

  <Connector id="getimgEJB JDBC Database">
    JdbcDriver org.postgresql.Driver
    JdbcUrl jdbc:postgresql://localhost/getimg?compatible=7.1
    UserName yarrow
    Password ""
  </Connector>

  <Connector id="nphonecardEJB JDBC Database">
    JdbcDriver org.postgresql.Driver
    JdbcUrl jdbc:postgresql://localhost/nphonecard?compatible=7.1
    UserName yarrow
    Password ""
  </Connector>
<!-- ------------------------------------------------------------ -->



Next, I am including the various postgresql.cmp_{global,local} 
_database.xml files:

The nphonecardEJB postgresql.cmp_global_database.xml:

<!-- ------------------------------------------------------------ -->
<?xml version="1.0"?>
<database name="Global_TX_Database" engine="postgresql">
  <jndi name="java:comp/env/jdbc/nphonecard" />

  <mapping href="/home/yarrow/NPhoneCard/src/nphonecard/beans/conf/ 
postgresql.cmp_or_mapping.xml" />

</database>
<!-- ------------------------------------------------------------ -->


The nphonecardEJB postgresql.cmp_local_database.xml:

<!-- ------------------------------------------------------------ -->
<?xml version="1.0"?>
<database name="Local_TX_Database" engine="postgresql">

  <driver class-name="org.postgresql.Driver" url="jdbc:postgresql:// 
localhost/nphonecard?compatible=7.1">

    <param name="user" value="yarrow"/>
    <param name="password" value=""/>
  </driver>

  <mapping href="/home/yarrow/NPhoneCard/src/nphonecard/beans/conf/ 
postgresql.cmp_or_mapping.xml"/>

</database>
<!-- ------------------------------------------------------------ -->


The nphonecardEJB postgresql.cmp_or_mapping.xml:

<!-- ------------------------------------------------------------ -->
<?xml version="1.0"?>

         <mapping>


           <class  
name="nphonecard.beans.phonecardlist.PhoneCardListBean"

         identity="PCLId"
         key-generator="SEQUENCE">
    <map-to table="phonecardlist"/>
<!-- (Note: cache-type none goes along with Blob type) -->
    <cache-type type="none" />
    <field name="PCLId" type="integer" direct="true">
      <sql name="pcl_id" type="integer"/>
    </field>
    <field name="UserName" type="string" direct="true">
      <sql name="user_name" type="varchar" dirty="check"/>
    </field>
    <field name="AccountID" type="string" direct="true">
      <sql name="account_id" type="varchar" dirty="check"/>
    </field>
    <field name="CreateDate" type="string" direct="true">
      <sql name="create_date" type="varchar" dirty="check"/>
    </field>
    <field name="ChangeDate" type="string" direct="true">
      <sql name="change_date" type="varchar" dirty="check"/>
    </field>
    <field name="PCLName" type="string" direct="true">
      <sql name="pcl_name" type="varchar" dirty="check"/>
    </field>
    <field name="PCLBlob" type="bytes" direct="true">
      <sql name="pcl_blob" type="blob" dirty="ignore"/>
    </field>
  </class>

  <class name="nphonecard.beans.userdata.UserDataBean"
         identity="UDId"
         key-generator="SEQUENCE">
    <map-to table="userdata"/>
    <field name="UDId" type="integer" direct="true">
      <sql name="ud_id" type="integer"/>
    </field>
    <field name="UserName" type="string" direct="true">
      <sql name="user_name" type="varchar" dirty="check"/>
    </field>
    <field name="PassWord" type="string" direct="true">
      <sql name="pass_word" type="varchar" dirty="check"/>
    </field>
    <field name="AccountID" type="string" direct="true">
      <sql name="account_id" type="varchar" dirty="check"/>
    </field>
    <field name="CreditCardNumber" type="string" direct="true">
      <sql name="credit_card_number" type="varchar" dirty="check"/>
    </field>
    <field name="CreditCardIssuer" type="string" direct="true">
      <sql name="credit_card_issuer" type="varchar" dirty="check"/>
    </field>
    <field name="CreditCardExp" type="string" direct="true">
      <sql name="credit_card_exp" type="varchar" dirty="check"/>
    </field>
    <field name="FirstName" type="string" direct="true">
      <sql name="first_name" type="varchar" dirty="check"/>
    </field>
    <field name="LastName" type="string" direct="true">
      <sql name="last_name" type="varchar" dirty="check"/>
    </field>
    <field name="MidInitial" type="string" direct="true">
      <sql name="mid_initial" type="varchar" dirty="check"/>
    </field>
    <field name="Title" type="string" direct="true">
      <sql name="title" type="varchar" dirty="check"/>
    </field>
    <field name="WholeName" type="string" direct="true">
      <sql name="whole_name" type="varchar" dirty="check"/>
    </field>
    <field name="HomePhoneNumber" type="string" direct="true">
      <sql name="home_phone_number" type="varchar" dirty="check"/>
    </field>
    <field name="WorkPhoneNumber" type="string" direct="true">
      <sql name="work_phone_number" type="varchar" dirty="check"/>
    </field>
    <field name="HomeAddress" type="string" direct="true">
      <sql name="home_address" type="varchar" dirty="check"/>
    </field>
    <field name="CityName" type="string" direct="true">
      <sql name="city_name" type="varchar" dirty="check"/>
    </field>
    <field name="CSZString" type="string" direct="true">
      <sql name="csz_string" type="varchar" dirty="check"/>
    </field>
    <field name="State" type="string" direct="true">
      <sql name="state" type="varchar" dirty="check"/>
    </field>
    <field name="ZipCode" type="string" direct="true">
      <sql name="zip_code" type="varchar" dirty="check"/>
    </field>
    <field name="EMail" type="string" direct="true">
      <sql name="email" type="varchar" dirty="check"/>
    </field>
    <field name="Extra1" type="string" direct="true">
      <sql name="extra1" type="varchar" dirty="check"/>
    </field>
    <field name="Extra2" type="string" direct="true">
      <sql name="extra2" type="varchar" dirty="check"/>
    </field>
  </class>

  <class name="nphonecard.beans.userlist.UserListBean"
         identity="PCLId"
         key-generator="SEQUENCE">
    <map-to table="phonecardlist"/>
<!-- (Note: cache-type none goes along with Blob type) -->
    <cache-type type="none" />
    <field name="PCLId" type="integer" direct="true">
      <sql name="pcl_id" type="integer"/>
    </field>
    <field name="UserName" type="string" direct="true">
      <sql name="user_name" type="varchar" dirty="check"/>
    </field>
    <field name="PCLName" type="string" direct="true">
      <sql name="pcl_name" type="varchar" dirty="check"/>
    </field>
  </class>

</mapping>
<!-- ------------------------------------------------------------ -->


Now, the appropriate such files for the getimgEJB.jar

<!-- ------------------------------------------------------------ -->
<database name="Global_TX_Database" engine="postgresql">
  <jndi name="java:comp/env/jdbc/getimg" />

  <mapping href="/home/yarrow/GetImg/src/getimg/beans/conf/ 
postgresql.cmp_or_mapping.xml" />

</database>

<database name="Local_TX_Database" engine="postgresql">

  <driver class-name="org.postgresql.Driver" url="jdbc:postgresql:// 
localhost/getimg?compatible=7.1">

    <param name="user" value="yarrow"/>
    <param name="password" value=""/>
  </driver>

  <mapping href="/home/yarrow/GetImg/src/getimg/beans/conf/ 
postgresql.cmp_or_mapping.xml"/>

</database>

<mapping>

  <class name="getimg.beans.pcuserdata.PCUserDataBean"
         identity="UDId"
         key-generator="SEQUENCE">
    <map-to table="pcuserdata"/>
    <field name="UDId" type="integer" direct="true">
      <sql name="ud_id" type="integer"/>
    </field>
    <field name="UserName" type="string" direct="true">
      <sql name="user_name" type="varchar" dirty="check"/>
    </field>
    <field name="PassWord" type="string" direct="true">
      <sql name="pass_word" type="varchar" dirty="check"/>
    </field>
    <field name="AccountID" type="string" direct="true">
      <sql name="account_id" type="varchar" dirty="check"/>
    </field>
    <field name="CreditCardNumber" type="string" direct="true">
      <sql name="credit_card_number" type="varchar" dirty="check"/>
    </field>
    <field name="CreditCardIssuer" type="string" direct="true">
      <sql name="credit_card_issuer" type="varchar" dirty="check"/>
    </field>
    <field name="CreditCardExp" type="string" direct="true">
      <sql name="credit_card_exp" type="varchar" dirty="check"/>
    </field>
    <field name="FirstName" type="string" direct="true">
      <sql name="first_name" type="varchar" dirty="check"/>
    </field>
    <field name="LastName" type="string" direct="true">
      <sql name="last_name" type="varchar" dirty="check"/>
    </field>
    <field name="MidInitial" type="string" direct="true">
      <sql name="mid_initial" type="varchar" dirty="check"/>
    </field>
    <field name="Title" type="string" direct="true">
      <sql name="title" type="varchar" dirty="check"/>
    </field>
    <field name="WholeName" type="string" direct="true">
      <sql name="whole_name" type="varchar" dirty="check"/>
    </field>
    <field name="HomePhoneNumber" type="string" direct="true">
      <sql name="home_phone_number" type="varchar" dirty="check"/>
    </field>
    <field name="WorkPhoneNumber" type="string" direct="true">
      <sql name="work_phone_number" type="varchar" dirty="check"/>
    </field>
    <field name="HomeAddress" type="string" direct="true">
      <sql name="home_address" type="varchar" dirty="check"/>
    </field>
    <field name="CityName" type="string" direct="true">
      <sql name="city_name" type="varchar" dirty="check"/>
    </field>
    <field name="CSZString" type="string" direct="true">
      <sql name="csz_string" type="varchar" dirty="check"/>
    </field>
    <field name="State" type="string" direct="true">
      <sql name="state" type="varchar" dirty="check"/>
    </field>
    <field name="ZipCode" type="string" direct="true">
      <sql name="zip_code" type="varchar" dirty="check"/>
    </field>
    <field name="EMail" type="string" direct="true">
      <sql name="email" type="varchar" dirty="check"/>
    </field>
    <field name="Extra1" type="string" direct="true">
      <sql name="extra1" type="varchar" dirty="check"/>
    </field>
    <field name="Extra2" type="string" direct="true">
      <sql name="extra2" type="varchar" dirty="check"/>
    </field>
  </class>

  <class name="getimg.beans.photoclubdata.PhotoClubDataBean"
         identity="PCId"
         key-generator="SEQUENCE">
    <map-to table="photoclubdata"/>
    <field name="PCId" type="integer" direct="true">
      <sql name="pc_id" type="integer"/>
    </field>
    <field name="PhotoClub" type="string" direct="true">
      <sql name="photo_club" type="varchar" dirty="check"/>
    </field>
    <field name="UserName" type="string" direct="true">
      <sql name="user_name" type="varchar" dirty="check"/>
    </field>
    <field name="CreateDate" type="string" direct="true">
      <sql name="create_date" type="varchar" dirty="check"/>
    </field>
  </class>

  <class name="getimg.beans.clubuserdata.ClubUserDataBean"
         identity="CUId"
         key-generator="SEQUENCE">
    <map-to table="clubuserdata"/>
    <field name="CUId" type="integer" direct="true">
      <sql name="cu_id" type="integer"/>
    </field>
    <field name="PhotoClub" type="string" direct="true">
      <sql name="photo_club" type="varchar" dirty="check"/>
    </field>
    <field name="UserName" type="string" direct="true">
      <sql name="user_name" type="varchar" dirty="check"/>
    </field>
  </class>

</mapping>
<!-- ------------------------------------------------------------ -->


This is the nphonecardEJB META-INF/ejb-jar.xml:

<!-- ------------------------------------------------------------ -->
<?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>
      <ejb-name>PhoneCardListBean</ejb-name>
      <home>nphonecard.beans.phonecardlist.PhoneCardListHome</home>
      <remote>nphonecard.beans.phonecardlist.PhoneCardList</remote>


 <ejb-class>nphonecard.beans.phonecardlist.PhoneCardListBean</ejb- 
class>

      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.Integer</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-field>
        <field-name>PCLId</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>UserName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>AccountID</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>CreateDate</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>ChangeDate</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>PCLName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>PCLBlob</field-name>
      </cmp-field>
      <primkey-field>PCLId</primkey-field>
      <resource-ref>
        <res-ref-name>jdbc/postgresql</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
      </resource-ref>
    </entity>


    <entity>
      <ejb-name>UserDataBean</ejb-name>
      <home>nphonecard.beans.userdata.UserDataHome</home>
      <remote>nphonecard.beans.userdata.UserData</remote>
      <ejb-class>nphonecard.beans.userdata.UserDataBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.Integer</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-field>
        <field-name>UDId</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>UserName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>PassWord</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>AccountID</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>CreditCardNumber</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>CreditCardIssuer</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>CreditCardExp</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>FirstName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>LastName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>MidInitial</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>Title</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>WholeName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>HomePhoneNumber</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>WorkPhoneNumber</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>HomeAddress</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>CityName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>CSZString</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>State</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>ZipCode</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>EMail</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>Extra1</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>Extra2</field-name>
      </cmp-field>
      <primkey-field>UDId</primkey-field>
      <resource-ref>
        <res-ref-name>jdbc/postgresql</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
      </resource-ref>
    </entity>

    <entity>
      <ejb-name>UserListBean</ejb-name>
      <home>nphonecard.beans.userlist.UserListHome</home>
      <remote>nphonecard.beans.userlist.UserList</remote>
      <ejb-class>nphonecard.beans.userlist.UserListBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.Integer</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-field>
        <field-name>PCLId</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>UserName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>PCLName</field-name>
      </cmp-field>
      <primkey-field>PCLId</primkey-field>
      <resource-ref>
        <res-ref-name>jdbc/postgresql</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
      </resource-ref>
    </entity>

  </enterprise-beans>

  <assembly-descriptor>

    <container-transaction>
      <method>
        <ejb-name>PhoneCardListBean</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Supports</trans-attribute>
    </container-transaction>

    <container-transaction>
      <method>
        <ejb-name>UserDataBean</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Supports</trans-attribute>
    </container-transaction>

    <container-transaction>
      <method>
        <ejb-name>UserListBean</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Supports</trans-attribute>
    </container-transaction>

  </assembly-descriptor>

</ejb-jar>
<!-- ------------------------------------------------------------ -->

At this point, I am refraining from including the openejb-jar.xml's
that are produced by the deploy tool for the two beans jar sets
because they include no linefeeds and are very difficult to scan
visually.  However, I did peruse them carefully and see no evident
errors in them.  The embedded SQL SELECTs in them are appropriate
for the findByUserName, etc that are indicated by the bean Home files.


Maurice Yarrow






























					Reply via email to