Hi,
I'm not familiar with CMP and Oracle 8.1.5,
but since this is read-only, and you are
using Minerva, it should be possible to find
out what is wrong here.
Since read-only, you know what is in the DB
at all times.
I would check the expression ccTx.getReferenceTx()
that you use to create a primary key for the
second finder. Does it return the expected value?
If that turns out OK, try adding some
System.err.println(...) to the ejbLoad(...) method
of your entity bean. Create this method if it does
not already exist. Print the primary key from the
bean context, and all the CMP fields.
Whenever your bean instance is synchronized from the
DB, the container will call ejbLoad() right after.
Do the right bean instances get loaded from the DB?
Does the context primary key match the primary key
field in your bean? (If not, you found a bad bug.)
Do other field have the values you would expect?
Hope this helps.
Best Regards,
Ole Husgaard.
Luis Ochoa wrote:
>
> Thanks for your reply.
>
> -Jboss is 2.0 FINAL
> -The code below executes in a session bean (part of a 1 session bean and 2
> entity beans app, all with "Required" transactional attributes)
> -I'm using CMP
> -Database is Oracle8.1.5 using Minerva pools with the 1.1.1 Oracle JDBC
> drivers (thus not using JDBC extensions).
>
> -----Original Message-----
> From: Ole Husgaard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 5:19 PM
> To: jBoss
> Subject: Re: [jBoss-User] Nested findBys on the same Home interface
> don'twork WAS RE: Finders
>
> Hi,
>
> If the code snippet below executes on the
> client, in another VM, I don't think it is
> a transactional issue, as the two finder
> methods execute in different transactions.
>
> But otherwise it might be.
>
> Which JBoss version?
> CMP ot BMP?
> Which database, and how is it set up in
> JBoss?
>
> Best Regards,
>
> Ole Husgaard.
>
> Luis Ochoa wrote:
> >
> > Sorry to bother so often, but could this be a transactional issue?
> > Any takers?
> >
> > Thanks
> >
> > -----Original Message-----
> > From: Luis Ochoa [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 31, 2001 9:48 AM
> > To: 'jBoss'
> > Subject: [jBoss-User] Nested findBys on the same Home interface don't
> > work WAS RE: Fin ders
> >
> > OK, mistake in my previous post. It's actually (on the else branch):
> >
> > CCTransaction refTx = txHome.findByPrimaryKey(new
> > CCTransactionPK(ccTx.getReferenceTx()));
> >
> > What I have is a table with an integer field (referenceTx) that refers to
> > the same table. So basically I'm looking up records that meet a certain
> > criteria (findBySendBatch) and then, for each one of them, I'm testing if
> > the field txCode is 30. If it isn't, that means that they have a reference
> > (again in referenceTx, an integer) to another record in the table. So at
> > that point, I get another CCTransaction refTx =
> txHome.findByPrimaryKey(new
> > CCTransactionPK(ccTx.getReferenceTx())); and that is what's blowing the
> > server up, not literally, but giving me values inconsistent with what the
> > database holds. So again, this is how the code looks:
> >
> > Object objTxHome = jndiContext.lookup("CCTransactionHome");
> > CCTransactionHome txHome = (CCTransactionHome)
> > PortableRemoteObject.narrow(objTxHome, CCTransactionHome.class);
> > Collection coll = txHome.findBySendBatch(); //group of rows that meet the
> > "SendBatch" criteria
> > Iterator it = coll.iterator();
> > while (it.hasNext()) { //loop through the collection
> > CCTransaction ccTx = (CCTransaction) it.next();
> > if (ccTx.getFieldX().equals("30")) {
> > ... //all works good as long as all the records go
> through
> > this branch
> > } else {
> > //same home interface as the findBySendBatch, just now
> > findByPrimaryKey, should give me another row in the table
> > CCTransaction refTx = txHome.findByPrimaryKey(new
> > CCTransactionPK(ccTx.getReferenceTx()));
> > String foo = refTx.getFieldY(); // is coming up null, even
> > when there's something on the DB
> > }
> > }
> >
> > Sorry for the earlier mix-up, I guess I have to be really accurate in what
> I
> > post if I expect anyone to help me. :-)
> >
> > Thanks, Luis.
> >
> > -----Original Message-----
> > From: Ingo Bruell [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 31, 2001 5:28 AM
> > To: jboss-user
> > Subject: Re: [jBoss-User] RE: Finders
> >
> > > Object objTxHome = jndiContext.lookup("CCTransactionHome");
> > > CCTransactionHome txHome = (CCTransactionHome)
> > > PortableRemoteObject.narrow(objTxHome, CCTransactionHome.class);
> > > Collection coll = txHome.findBySendBatch();
> > > Iterator it = coll.iterator();
> > > while (it.hasNext()) {
> > > CCTransaction ccTx = (CCTransaction) it.next();
> > > if (ccTx.getFieldX().equals("30")) {
> > > ...
> > > } else {
> > > CCTransaction refTx =
> > > txHome.findByPrimaryKey(ccTx.getReferenceTx());
> > > refTx.getFieldY() <-- is coming up null, even when there's
> > > something on the DB
> > > }
> > > }
> >
> > It is not possible to find an EntityBean with a reference.
> >
> > Is ccTx != ccTx.getReferenceTx() ?
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > List Help?: [EMAIL PROTECTED]
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > List Help?: [EMAIL PROTECTED]
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
