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> <depends optional-attribute-name="ManagedConnectionPool">
MD> <!--embedded mbean-->
MD> <mbean
MD> code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
MD> name="jboss.jca:service=LocalTxPool,name=ejbGuestb
MD> <attribute name="MinSize">0</attribute>
MD> <attribute name="MaxSize">50</attribute>
MD> <attribute name="BlockingTimeoutMillis">5000</attribute>
MD> <attribute name="IdleTimeoutMinutes">15</attribute>
MD> <!--criteria indicates if Subject (from security domain) or app
MD> supplied
MD> parameters (such as from getConnection(user, pw)) are used to
MD> distinguish
MD> connections in the pool. Choices are
MD> ByContainerAndApplication (use both),
MD> ByContainer (use Subject),
MD> ByApplication (use app supplied params only),
MD> ByNothing (all connections are equivalent, usually if adapter
MD> supports
MD> reauthentication)-->
MD> <attribute name="Criteria">ByContainer</attribute>
MD> </mbean>
MD> </depends>
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
>> > > Object ref = jndiContext.lookup("ejb/guestbook/gbEntry");
>> > >
>> > > // Get a reference from this to the Bean's Home interface
>> > > gbEntryHome home = (gbEntryHome) PortableRemoteObject.narrow
MD> (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
MD> get
>> > > into any depth in terms of "commiting" or "autocommit". Iīll have to
MD> 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
MD> 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
MD> could
>> > the
>> > > > > reason for this be?
>> > > >
--
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
