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]
