Re: [JBoss-user] Server log in JBOSS3.0RC2
MyISAM Thanks, Michael - Original Message - From: "Stefan Arentz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 4:41 PM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > On Tuesday, May 21, 2002, at 10:27 AM, Michael Delamere wrote: > > > Hi, > > > > again, thanks for your time. Somebody else mentioned the pool size > > when I > > mentioned an error I was getting which said > > > > " The Pool for com.morelogs.guestbook.beans.gbEntryCMP has been > > overloaded. > > You should change pool parameters." > > > > I don´t know what the optimal pool settings are. In my msql- > > service.xml I > > have stated the following: > > What kind of tables are you using in MySQL? InnoDB or MyISAM? > > Stefan > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
On Tuesday, May 21, 2002, at 10:27 AM, Michael Delamere wrote: > Hi, > > again, thanks for your time. Somebody else mentioned the pool size > when I > mentioned an error I was getting which said > > " The Pool for com.morelogs.guestbook.beans.gbEntryCMP has been > overloaded. > You should change pool parameters." > > I don´t know what the optimal pool settings are. In my msql- > service.xml I > have stated the following: What kind of tables are you using in MySQL? InnoDB or MyISAM? Stefan ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: Re[2]: [JBoss-user] Server log in JBOSS3.0RC2
Thanks, I think I?ll have to do _lots_ of reading :) because that file is huge! Regards, Michael - Original Message - From: "Alex Loubyansky" <[EMAIL PROTECTED]> To: "Michael Delamere" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 10:29 AM Subject: Re[2]: [JBoss-user] Server log in JBOSS3.0RC2 > Hello Michael, > > not that pool :) There is a pool for beans. Look at standardjboss.xml. > You'll find container-configuration there for different beans. There > are settings for pool management. Also read online docs. > > alex > > Tuesday, May 21, 2002, 11:27:32 AM, you wrote: > > MD> Hi, > > MD> again, thanks for your time. Somebody else mentioned the pool size when I > MD> mentioned an error I was getting which said > > MD> " The Pool for com.morelogs.guestbook.beans.gbEntryCMP has been overloaded. > MD> You should change pool parameters." > > MD> I don´t know what the optimal pool settings are. In my msql-service.xml I > MD> have stated the following: > > MD> mysql-service.xml === > > MD> > MD> > MD>MD> code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" > MD> name="jboss.jca:service=LocalTxPool,name=ejbGuestb > MD> 0 > MD> 50 > MD> 5000 > MD> 15 > MD> > MD> ByContainer > MD> > MD> > > MD> == > > MD> Would other values be better or am I even looking at the wrong place? > > MD> Thanks, > > MD> Michael > > > > MD> - Original Message - > MD> From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > MD> To: <[EMAIL PROTECTED]> > MD> Sent: Tuesday, May 21, 2002 9:42 AM > MD> Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > >> > yes, at step 6 I see the new object. What´s more peculiar is that when > MD> I > >> > change an exsiting entry using phpMyAdmin that _does_ show up! It´s > MD> only > >> > when adding a _new_ record manually that the change doesn´t appear. > >> > >> from that I'd suggest that you're using commit option B or C (or a very > MD> small pool size). > >> > >> well its definately getting inserted and committed ok... I'm all out of > MD> ideas sorry - but as my other email suggests, I dont think > >> commit option has anything to do with it although if someone wants to > MD> correct my interpretation of the spec, I'd be pleased to > >> see it. > >> > >> cheers > >> dim > >> > >> > >> > >> - Original Message - > >> From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > >> To: <[EMAIL PROTECTED]> > >> Sent: Tuesday, May 21, 2002 8:43 AM > >> Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > >> > >> > >> > and I'm guessing that if you do this: > >> > > >> > 1. start jboss > >> > 2. request jsp (get list of objects) > >> > 3. insert new row > >> > 4. request jsp (dont see new objects) > >> > 5. stop and start jboss > >> > 6. request jsp > >> > > >> > I assume that at step 6 you do see the new object? > >> > > >> > - Original Message - > >> > From: "Michael Delamere" <[EMAIL PROTECTED]> > >> > To: <[EMAIL PROTECTED]> > >> > Sent: Tuesday, May 21, 2002 4:30 PM > >> > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > >> > > >> > > >> > I´m using a mysql-database and inserted the new entry using a php-based > >> tool > >> > called phpMyAdmin. > >> > > >> > Thanks, > >> > > >> > Michael > >> > > >> > - Original Message - > >> > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > >> > To: <[EMAIL PROTECTED]> > >> > Sent: Tuesday, May 21, 2002 4:10 AM > >> > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > >> > > >> > > >> > > that looks fine (to me)... > >> > > > >> > > what database are you using? and what program are you using to insert > >> the > >> > new row(s)? > >> > > > >> > > cheers >
Re[2]: [JBoss-user] Server log in JBOSS3.0RC2
Hello Michael, not that pool :) There is a pool for beans. Look at standardjboss.xml. You'll find container-configuration there for different beans. There are settings for pool management. Also read online docs. alex Tuesday, May 21, 2002, 11:27:32 AM, you wrote: MD> Hi, MD> again, thanks for your time. Somebody else mentioned the pool size when I MD> mentioned an error I was getting which said MD> " The Pool for com.morelogs.guestbook.beans.gbEntryCMP has been overloaded. MD> You should change pool parameters." MD> I don´t know what the optimal pool settings are. In my msql-service.xml I MD> have stated the following: MD> mysql-service.xml === MD> MD> MD>code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" MD> name="jboss.jca:service=LocalTxPool,name=ejbGuestb MD> 0 MD> 50 MD> 5000 MD> 15 MD> MD> ByContainer MD> MD> MD> == MD> Would other values be better or am I even looking at the wrong place? MD> Thanks, MD> Michael MD> - Original Message - MD> From: "Dmitri Colebatch" <[EMAIL PROTECTED]> MD> To: <[EMAIL PROTECTED]> MD> Sent: Tuesday, May 21, 2002 9:42 AM MD> Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 >> > yes, at step 6 I see the new object. What´s more peculiar is that when MD> I >> > change an exsiting entry using phpMyAdmin that _does_ show up! It´s MD> only >> > when adding a _new_ record manually that the change doesn´t appear. >> >> from that I'd suggest that you're using commit option B or C (or a very MD> small pool size). >> >> well its definately getting inserted and committed ok... I'm all out of MD> ideas sorry - but as my other email suggests, I dont think >> commit option has anything to do with it although if someone wants to MD> correct my interpretation of the spec, I'd be pleased to >> see it. >> >> cheers >> dim >> >> >> >> - Original Message - >> From: "Dmitri Colebatch" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Tuesday, May 21, 2002 8:43 AM >> Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 >> >> >> > and I'm guessing that if you do this: >> > >> > 1. start jboss >> > 2. request jsp (get list of objects) >> > 3. insert new row >> > 4. request jsp (dont see new objects) >> > 5. stop and start jboss >> > 6. request jsp >> > >> > I assume that at step 6 you do see the new object? >> > >> > - Original Message - >> > From: "Michael Delamere" <[EMAIL PROTECTED]> >> > To: <[EMAIL PROTECTED]> >> > Sent: Tuesday, May 21, 2002 4:30 PM >> > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 >> > >> > >> > I´m using a mysql-database and inserted the new entry using a php-based >> tool >> > called phpMyAdmin. >> > >> > Thanks, >> > >> > Michael >> > >> > ----- Original Message - >> > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> >> > To: <[EMAIL PROTECTED]> >> > Sent: Tuesday, May 21, 2002 4:10 AM >> > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 >> > >> > >> > > that looks fine (to me)... >> > > >> > > what database are you using? and what program are you using to insert >> the >> > new row(s)? >> > > >> > > cheers >> > > dim >> > > >> > > - Original Message - >> > > From: "Michael Delamere" <[EMAIL PROTECTED]> >> > > To: <[EMAIL PROTECTED]> >> > > Sent: Tuesday, May 21, 2002 11:33 AM >> > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 >> > > >> > > >> > > Yes, it is a finder: >> > > >> > >public java.util.Collection findAll() >> > > throws java.rmi.RemoteException,javax.ejb.FinderException; >> > > >> > > I get my data from my ActionServlet using the following code: >> > > === >> > >// Get a naming context >> > > InitialContext jndiContext = new InitialContext(); >> > > >> > > // Get a reference to a gbEntry Bean >>
Re: [JBoss-user] Server log in JBOSS3.0RC2
Hi, again, thanks for your time. Somebody else mentioned the pool size when I mentioned an error I was getting which said " The Pool for com.morelogs.guestbook.beans.gbEntryCMP has been overloaded. You should change pool parameters." I don´t know what the optimal pool settings are. In my msql-service.xml I have stated the following: mysql-service.xml === 0 50 5000 15 ByContainer == Would other values be better or am I even looking at the wrong place? Thanks, Michael - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 9:42 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > yes, at step 6 I see the new object. What´s more peculiar is that when I > > change an exsiting entry using phpMyAdmin that _does_ show up! It´s only > > when adding a _new_ record manually that the change doesn´t appear. > > from that I'd suggest that you're using commit option B or C (or a very small pool size). > > well its definately getting inserted and committed ok... I'm all out of ideas sorry - but as my other email suggests, I dont think > commit option has anything to do with it although if someone wants to correct my interpretation of the spec, I'd be pleased to > see it. > > cheers > dim > > > > - Original Message - > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 8:43 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > and I'm guessing that if you do this: > > > > 1. start jboss > > 2. request jsp (get list of objects) > > 3. insert new row > > 4. request jsp (dont see new objects) > > 5. stop and start jboss > > 6. request jsp > > > > I assume that at step 6 you do see the new object? > > > > - Original Message - > > From: "Michael Delamere" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 4:30 PM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > I´m using a mysql-database and inserted the new entry using a php-based > tool > > called phpMyAdmin. > > > > Thanks, > > > > Michael > > > > - Original Message - > > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 4:10 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > > that looks fine (to me)... > > > > > > what database are you using? and what program are you using to insert > the > > new row(s)? > > > > > > cheers > > > dim > > > > > > - Original Message - > > > From: "Michael Delamere" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 21, 2002 11:33 AM > > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > > > > Yes, it is a finder: > > > > > >public java.util.Collection findAll() > > > throws java.rmi.RemoteException,javax.ejb.FinderException; > > > > > > I get my data from my ActionServlet using the following code: > > > === > > >// Get a naming context > > > InitialContext jndiContext = new InitialContext(); > > > > > > // Get a reference to a gbEntry Bean > > > Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); > > > > > > // Get a reference from this to the Bean's Home interface > > > gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, > > > gbEntryHome.class); > > >entryCollection = home.findAll(); > > > } > > > == > > > . which works fine except that after hitting refresh, I don´t get > the > > > new entry that I manually entered into the DB. I haven´t managed to get > > > into any depth in terms of "commiting" or "autocommit". I´ll have to do > > > that now and hopefully that is the answer. > > > > > > Thanks, > > > > > > Michael > > > > > > > > > - Original Message - > > > From: "Dmitri
Re: [JBoss-user] Server log in JBOSS3.0RC2
> yes, at step 6 I see the new object. What´s more peculiar is that when I > change an exsiting entry using phpMyAdmin that _does_ show up! It´s only > when adding a _new_ record manually that the change doesn´t appear. from that I'd suggest that you're using commit option B or C (or a very small pool size). well its definately getting inserted and committed ok... I'm all out of ideas sorry - but as my other email suggests, I dont think commit option has anything to do with it although if someone wants to correct my interpretation of the spec, I'd be pleased to see it. cheers dim - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 8:43 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > and I'm guessing that if you do this: > > 1. start jboss > 2. request jsp (get list of objects) > 3. insert new row > 4. request jsp (dont see new objects) > 5. stop and start jboss > 6. request jsp > > I assume that at step 6 you do see the new object? > > - Original Message - > From: "Michael Delamere" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 4:30 PM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > I´m using a mysql-database and inserted the new entry using a php-based tool > called phpMyAdmin. > > Thanks, > > Michael > > - Original Message ----- > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 4:10 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > that looks fine (to me)... > > > > what database are you using? and what program are you using to insert the > new row(s)? > > > > cheers > > dim > > > > - Original Message - > > From: "Michael Delamere" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 11:33 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > Yes, it is a finder: > > > >public java.util.Collection findAll() > > throws java.rmi.RemoteException,javax.ejb.FinderException; > > > > I get my data from my ActionServlet using the following code: > > === > >// Get a naming context > > InitialContext jndiContext = new InitialContext(); > > > > // Get a reference to a gbEntry Bean > > Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); > > > > // Get a reference from this to the Bean's Home interface > > gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, > > gbEntryHome.class); > >entryCollection = home.findAll(); > > } > > == > > . which works fine except that after hitting refresh, I don´t get the > > new entry that I manually entered into the DB. I haven´t managed to get > > into any depth in terms of "commiting" or "autocommit". I´ll have to do > > that now and hopefully that is the answer. > > > > Thanks, > > > > Michael > > > > > > - Original Message - > > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 3:04 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > > how are you getting the array of objects? Is this a finder? > > > > > > how are you inserting into the database? are you sure you're committing > > that tx? this probably depends on what client you are > > > using to insert, and if it has autocommit set to true or not. > > > > > > cheers > > > dim > > > > > > - Original Message - > > > From: "Stephen Coy" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 21, 2002 10:45 AM > > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > > > > I think you need to learn about transactions and commit options. > > > > > > On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > > > > > > > I´ve got a stateless session bean doing a jndi lookup on my entity > bean > > > > and > > > > returning an array of objects. The problem is that the first time I > > > > start > > > > the application ever
Re: Re[2]: [JBoss-user] Server log in JBOSS3.0RC2
> It looks like like you have to set a correct commit option and > transaction type as was stated by Stephen. > > It should help: http://www.jboss.org/online-manual/HTML/ch07s16.html If my understanding is wrong here, I'd appreciate it if someone could correct me but, from the spec (EJB 1.1 - section 9.5.7, figure 37), I read that the container will always search the database when executing finders. So from this I assume (and frequently witness this behaviour) that if I insert a new record directly into the database, and then use a finder, I will see the entity bean that is representing that record. Moving further then, I cant see how commit-options could affect this, as all they do is say when ejbLoad is called. What we're talking about here happens before ejbLoad would be called, so whether ejbLoad is called (option B,C) or not (option A,D), the container will always find new records in the database. cheers dim ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
yes, at step 6 I see the new object. What´s more peculiar is that when I change an exsiting entry using phpMyAdmin that _does_ show up! It´s only when adding a _new_ record manually that the change doesn´t appear. Thanks Michael - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 8:43 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > and I'm guessing that if you do this: > > 1. start jboss > 2. request jsp (get list of objects) > 3. insert new row > 4. request jsp (dont see new objects) > 5. stop and start jboss > 6. request jsp > > I assume that at step 6 you do see the new object? > > - Original Message - > From: "Michael Delamere" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 4:30 PM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > I´m using a mysql-database and inserted the new entry using a php-based tool > called phpMyAdmin. > > Thanks, > > Michael > > - Original Message - > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 4:10 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > that looks fine (to me)... > > > > what database are you using? and what program are you using to insert the > new row(s)? > > > > cheers > > dim > > > > - Original Message - > > From: "Michael Delamere" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 11:33 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > Yes, it is a finder: > > > >public java.util.Collection findAll() > > throws java.rmi.RemoteException,javax.ejb.FinderException; > > > > I get my data from my ActionServlet using the following code: > > === > >// Get a naming context > > InitialContext jndiContext = new InitialContext(); > > > > // Get a reference to a gbEntry Bean > > Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); > > > > // Get a reference from this to the Bean's Home interface > > gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, > > gbEntryHome.class); > >entryCollection = home.findAll(); > > } > > == > > . which works fine except that after hitting refresh, I don´t get the > > new entry that I manually entered into the DB. I haven´t managed to get > > into any depth in terms of "commiting" or "autocommit". I´ll have to do > > that now and hopefully that is the answer. > > > > Thanks, > > > > Michael > > > > > > - Original Message - > > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 3:04 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > > how are you getting the array of objects? Is this a finder? > > > > > > how are you inserting into the database? are you sure you're committing > > that tx? this probably depends on what client you are > > > using to insert, and if it has autocommit set to true or not. > > > > > > cheers > > > dim > > > > > > - Original Message - > > > From: "Stephen Coy" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 21, 2002 10:45 AM > > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > > > > I think you need to learn about transactions and commit options. > > > > > > On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > > > > > > > I´ve got a stateless session bean doing a jndi lookup on my entity > bean > > > > and > > > > returning an array of objects. The problem is that the first time I > > > > start > > > > the application everything works fine and I get all of the data > > > > displayed in > > > > my jsp without a problem. > > > > > > > > After the first call I manually enter a new record into the database. > > > > When > > > > I press refresh in the browser the new
Re[2]: [JBoss-user] Server log in JBOSS3.0RC2
Hello Michael, Tuesday, May 21, 2002, 4:33:40 AM, you wrote: MD> . which works fine except that after hitting refresh, I don´t get the MD> new entry that I manually entered into the DB. I haven´t managed to get MD> into any depth in terms of "commiting" or "autocommit". I´ll have to do MD> that now and hopefully that is the answer. It looks like like you have to set a correct commit option and transaction type as was stated by Stephen. It should help: http://www.jboss.org/online-manual/HTML/ch07s16.html -- Best regards, Alex Loubyansky ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
and I'm guessing that if you do this: 1. start jboss 2. request jsp (get list of objects) 3. insert new row 4. request jsp (dont see new objects) 5. stop and start jboss 6. request jsp I assume that at step 6 you do see the new object? - Original Message - From: "Michael Delamere" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 4:30 PM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 I´m using a mysql-database and inserted the new entry using a php-based tool called phpMyAdmin. Thanks, Michael - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 4:10 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > that looks fine (to me)... > > what database are you using? and what program are you using to insert the new row(s)? > > cheers > dim > > - Original Message - > From: "Michael Delamere" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 11:33 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > Yes, it is a finder: > >public java.util.Collection findAll() > throws java.rmi.RemoteException,javax.ejb.FinderException; > > I get my data from my ActionServlet using the following code: > === >// Get a naming context > InitialContext jndiContext = new InitialContext(); > > // Get a reference to a gbEntry Bean > Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); > > // Get a reference from this to the Bean's Home interface > gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, > gbEntryHome.class); >entryCollection = home.findAll(); > } > == > . which works fine except that after hitting refresh, I don´t get the > new entry that I manually entered into the DB. I haven´t managed to get > into any depth in terms of "commiting" or "autocommit". I´ll have to do > that now and hopefully that is the answer. > > Thanks, > > Michael > > > - Original Message - > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 3:04 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > how are you getting the array of objects? Is this a finder? > > > > how are you inserting into the database? are you sure you're committing > that tx? this probably depends on what client you are > > using to insert, and if it has autocommit set to true or not. > > > > cheers > > dim > > > > - Original Message - > > From: "Stephen Coy" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 10:45 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > I think you need to learn about transactions and commit options. > > > > On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > > > > > I´ve got a stateless session bean doing a jndi lookup on my entity bean > > > and > > > returning an array of objects. The problem is that the first time I > > > start > > > the application everything works fine and I get all of the data > > > displayed in > > > my jsp without a problem. > > > > > > After the first call I manually enter a new record into the database. > > > When > > > I press refresh in the browser the new row isn´t shown. What could the > > > reason for this be? > > > > > > ___ > > > > Don't miss the 2002 Sprint PCS Application Developer's Conference > > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > > > ___ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > ___ > > > > Don't miss the 2002 Sprint PCS Application Developer's Conference > > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > > > ___ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > >
Re: [JBoss-user] Server log in JBOSS3.0RC2
I´m using a mysql-database and inserted the new entry using a php-based tool called phpMyAdmin. Thanks, Michael - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 4:10 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > that looks fine (to me)... > > what database are you using? and what program are you using to insert the new row(s)? > > cheers > dim > > - Original Message - > From: "Michael Delamere" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 11:33 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > Yes, it is a finder: > >public java.util.Collection findAll() > throws java.rmi.RemoteException,javax.ejb.FinderException; > > I get my data from my ActionServlet using the following code: > === >// Get a naming context > InitialContext jndiContext = new InitialContext(); > > // Get a reference to a gbEntry Bean > Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); > > // Get a reference from this to the Bean's Home interface > gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, > gbEntryHome.class); >entryCollection = home.findAll(); > } > == > . which works fine except that after hitting refresh, I don´t get the > new entry that I manually entered into the DB. I haven´t managed to get > into any depth in terms of "commiting" or "autocommit". I´ll have to do > that now and hopefully that is the answer. > > Thanks, > > Michael > > > - Original Message - > From: "Dmitri Colebatch" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 3:04 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > how are you getting the array of objects? Is this a finder? > > > > how are you inserting into the database? are you sure you're committing > that tx? this probably depends on what client you are > > using to insert, and if it has autocommit set to true or not. > > > > cheers > > dim > > > > - Original Message - > > From: "Stephen Coy" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 21, 2002 10:45 AM > > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > > > > I think you need to learn about transactions and commit options. > > > > On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > > > > > I´ve got a stateless session bean doing a jndi lookup on my entity bean > > > and > > > returning an array of objects. The problem is that the first time I > > > start > > > the application everything works fine and I get all of the data > > > displayed in > > > my jsp without a problem. > > > > > > After the first call I manually enter a new record into the database. > > > When > > > I press refresh in the browser the new row isn´t shown. What could the > > > reason for this be? > > > > > > ___ > > > > Don't miss the 2002 Sprint PCS Application Developer's Conference > > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > > > ___ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > ___ > > > > Don't miss the 2002 Sprint PCS Application Developer's Conference > > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > > > ___ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
that looks fine (to me)... what database are you using? and what program are you using to insert the new row(s)? cheers dim - Original Message - From: "Michael Delamere" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 11:33 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 Yes, it is a finder: public java.util.Collection findAll() throws java.rmi.RemoteException,javax.ejb.FinderException; I get my data from my ActionServlet using the following code: === // Get a naming context InitialContext jndiContext = new InitialContext(); // Get a reference to a gbEntry Bean Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); // Get a reference from this to the Bean's Home interface gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, gbEntryHome.class); entryCollection = home.findAll(); } == . which works fine except that after hitting refresh, I don´t get the new entry that I manually entered into the DB. I haven´t managed to get into any depth in terms of "commiting" or "autocommit". I´ll have to do that now and hopefully that is the answer. Thanks, Michael - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 3:04 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > how are you getting the array of objects? Is this a finder? > > how are you inserting into the database? are you sure you're committing that tx? this probably depends on what client you are > using to insert, and if it has autocommit set to true or not. > > cheers > dim > > - Original Message - > From: "Stephen Coy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 10:45 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > I think you need to learn about transactions and commit options. > > On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > > > I´ve got a stateless session bean doing a jndi lookup on my entity bean > > and > > returning an array of objects. The problem is that the first time I > > start > > the application everything works fine and I get all of the data > > displayed in > > my jsp without a problem. > > > > After the first call I manually enter a new record into the database. > > When > > I press refresh in the browser the new row isn´t shown. What could the > > reason for this be? > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
finders are always done against the database so a finder will work. commit options will only after _changed_ rows - not _new_ rows (afaik) cheers dim - Original Message - From: "JD Brennan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 11:01 AM Subject: RE: [JBoss-user] Server log in JBOSS3.0RC2 Perhaps you need to use Commit Option B or C instead of A which assumes there's no one else accessing the database and therefore is free to cache things. JD -Original Message- From: Stephen Coy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 5:46 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 I think you need to learn about transactions and commit options. On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > I´ve got a stateless session bean doing a jndi lookup on my entity bean > and > returning an array of objects. The problem is that the first time I > start > the application everything works fine and I get all of the data > displayed in > my jsp without a problem. > > After the first call I manually enter a new record into the database. > When > I press refresh in the browser the new row isn´t shown. What could the > reason for this be? ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
Yes, it is a finder: public java.util.Collection findAll() throws java.rmi.RemoteException,javax.ejb.FinderException; I get my data from my ActionServlet using the following code: === // Get a naming context InitialContext jndiContext = new InitialContext(); // Get a reference to a gbEntry Bean Object ref = jndiContext.lookup("ejb/guestbook/gbEntry"); // Get a reference from this to the Bean's Home interface gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow (ref, gbEntryHome.class); entryCollection = home.findAll(); } == . which works fine except that after hitting refresh, I don´t get the new entry that I manually entered into the DB. I haven´t managed to get into any depth in terms of "commiting" or "autocommit". I´ll have to do that now and hopefully that is the answer. Thanks, Michael - Original Message - From: "Dmitri Colebatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 3:04 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > how are you getting the array of objects? Is this a finder? > > how are you inserting into the database? are you sure you're committing that tx? this probably depends on what client you are > using to insert, and if it has autocommit set to true or not. > > cheers > dim > > - Original Message - > From: "Stephen Coy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 10:45 AM > Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 > > > I think you need to learn about transactions and commit options. > > On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > > > I´ve got a stateless session bean doing a jndi lookup on my entity bean > > and > > returning an array of objects. The problem is that the first time I > > start > > the application everything works fine and I get all of the data > > displayed in > > my jsp without a problem. > > > > After the first call I manually enter a new record into the database. > > When > > I press refresh in the browser the new row isn´t shown. What could the > > reason for this be? > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ___ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
how are you getting the array of objects? Is this a finder? how are you inserting into the database? are you sure you're committing that tx? this probably depends on what client you are using to insert, and if it has autocommit set to true or not. cheers dim - Original Message - From: "Stephen Coy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 10:45 AM Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 I think you need to learn about transactions and commit options. On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > I´ve got a stateless session bean doing a jndi lookup on my entity bean > and > returning an array of objects. The problem is that the first time I > start > the application everything works fine and I get all of the data > displayed in > my jsp without a problem. > > After the first call I manually enter a new record into the database. > When > I press refresh in the browser the new row isn´t shown. What could the > reason for this be? ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
Title: RE: [JBoss-user] Server log in JBOSS3.0RC2 Thanks, I will look into it. Regards, Michael - Original Message - From: JD Brennan To: '[EMAIL PROTECTED]' Sent: Tuesday, May 21, 2002 3:01 AM Subject: RE: [JBoss-user] Server log in JBOSS3.0RC2 Perhaps you need to use Commit Option B or C instead of A which assumes there's no one else accessing the database and therefore is free to cache things. JD -Original Message- From: Stephen Coy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 5:46 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 I think you need to learn about transactions and commit options. On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > I´ve got a stateless session bean doing a jndi lookup on my entity bean > and > returning an array of objects. The problem is that the first time I > start > the application everything works fine and I get all of the data > displayed in > my jsp without a problem. > > After the first call I manually enter a new record into the database. > When > I press refresh in the browser the new row isn´t shown. What could the > reason for this be? ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] Server log in JBOSS3.0RC2
Title: RE: [JBoss-user] Server log in JBOSS3.0RC2 Perhaps you need to use Commit Option B or C instead of A which assumes there's no one else accessing the database and therefore is free to cache things. JD -Original Message- From: Stephen Coy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 5:46 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Server log in JBOSS3.0RC2 I think you need to learn about transactions and commit options. On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > I´ve got a stateless session bean doing a jndi lookup on my entity bean > and > returning an array of objects. The problem is that the first time I > start > the application everything works fine and I get all of the data > displayed in > my jsp without a problem. > > After the first call I manually enter a new record into the database. > When > I press refresh in the browser the new row isn´t shown. What could the > reason for this be? ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Server log in JBOSS3.0RC2
I think you need to learn about transactions and commit options. On Tuesday, May 21, 2002, at 04:50 AM, Michael Delamere wrote: > I´ve got a stateless session bean doing a jndi lookup on my entity bean > and > returning an array of objects. The problem is that the first time I > start > the application everything works fine and I get all of the data > displayed in > my jsp without a problem. > > After the first call I manually enter a new record into the database. > When > I press refresh in the browser the new row isn´t shown. What could the > reason for this be? ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] Server log in JBOSS3.0RC2
Hi, I´ve got a stateless session bean doing a jndi lookup on my entity bean and returning an array of objects. The problem is that the first time I start the application everything works fine and I get all of the data displayed in my jsp without a problem. After the first call I manually enter a new record into the database. When I press refresh in the browser the new row isn´t shown. What could the reason for this be? Another thing, what do the following lines in the server.log mean? 1) "2002-05-20 16:56:40,209 DEBUG [org.jboss.ejb.plugins.EntityInstancePool] The Pool for com.morelogs.guestbook.beans.gbEntryCMP has been overloaded. You should change pool parameters." 2) "2002-05-20 16:56:40,179 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.guestbook/gbEntry] Executing SQL: SELECT entry_id,author_id, entry_subject, entry_text, entry_date, entry_views FROM gbEntries WHERE (entry_id=?) OR (entry_id=?) OR (entry_id=?)" 3) "2002-05-20 16:56:40,550 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.guestbook/gbEntry] Executing SQL: SELECT author_id, entry_subject, entry_text, entry_date, entry_views FROM gbEntries WHERE (entry_id=?)" 4) "2002-05-20 18:25:13,729 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 45" Is it normal that it is repeating steps 2+3 five times each time along with other sqls containing question marks? I would really appreciate an answer to this as I´m trying to figure out why the jsp isn´t showing the new row! Thanks in advance, Michael ___ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user