Hi! When we first deployed our system to a relatively large store autumn
1999 we suddenly started to have a corrupted database. In some way
selects and updates where mixed up by the driver in some strange way.
When one record was updated in db some field could get same values as
the record last read in a select. So DON'T USE that driver is my advice.
It really is a buggy driver :(
/Lennart
Luis Ochoa skrev:
>
> Well, I'll be darned. After doing what you say below, I could see what jboss
> was retrieving from the database, and even though the PK was the same for
> the context and the bean, a lot of fields that were populated in the DB,
> were coming up null in ejbLoad. So I replaced the older classes111.zip
> oracle jdbc drivers, with the latest classes12.zip, and everything started
> to work fine. I guess the old drivers were the culprit.
>
> Thanks,Luis.
>
> -----Original Message-----
> From: Ole Husgaard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 4:28 AM
> To: jBoss
> Subject: Re: [jBoss-User] Nested findBys on the same Home
> interfacedon'tw ork WAS RE: Finders
>
> 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
> > > }
> > > }
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
--
mailto:[EMAIL PROTECTED]
http://www.benefit.se/english
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
