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 ======================= <depends optional-attribute-name="ManagedConnectionPool"> <!--embedded mbean--> <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=ejbGuestb <attribute name="MinSize">0</attribute> <attribute name="MaxSize">50</attribute> <attribute name="BlockingTimeoutMillis">5000</attribute> <attribute name="IdleTimeoutMinutes">15</attribute> <!--criteria indicates if Subject (from security domain) or app supplied parameters (such as from getConnection(user, pw)) are used to distinguish connections in the pool. Choices are ByContainerAndApplication (use both), ByContainer (use Subject), ByApplication (use app supplied params only), ByNothing (all connections are equivalent, usually if adapter supports reauthentication)--> <attribute name="Criteria">ByContainer</attribute> </mbean> </depends> ========================================================== 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 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 > > > > > > > > _______________________________________________________________ > > > > 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