11 Replies Latest reply on Jan 30, 2007 6:39 PM by weston.price

Prefill Pool for XA Datasource?

alrubinger Jan 30, 2007 3:09 PM

Is there a way to configure XA Datasource Pools to prefill?

On the first run of Unit Tests for my application, occasionally one test will fail with "Cannot obtain connection" as the rout cause; I'm guessing that too many requests at once for connections from my database is flooding it. Anyone else get this? This hunch sound correct?

S,
ALR

1. Re: Prefill Pool for XA Datasource?

alrubinger Jan 30, 2007 3:10 PM (in response to alrubinger)

*root* cause, of course. :)

S,
ALR
Actions
2. Re: Prefill Pool for XA Datasource?

weston.price Jan 30, 2007 3:16 PM (in response to alrubinger)

From the JBoss Wiki:

<prefill> - whether to attempt to prefill the connection pool to the minimum number of connections. NOTE: only supporting pools (OnePool?) support this feature. A warning can be found in the logs if the pool does not support this. This feature will appear in JBoss 4.0.5.

http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources
Actions
3. Re: Prefill Pool for XA Datasource?

alrubinger Jan 30, 2007 5:25 PM (in response to alrubinger)
Thanks, Weston, saw that.

But according to the DTD:

<!DOCTYPE datasources PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN" "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">

..."prefill" is not a valid option. I originally thought that "prefill" might have only been for local-tx, but a quick glance at the DTD shows that "prefill" isn't allowed anywhere.

Am I using the wrong version of the DTD? Should I toss it away completely?

JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)

S,
ALR
Actions
4. Re: Prefill Pool for XA Datasource?

weston.price Jan 30, 2007 5:56 PM (in response to alrubinger)

Ugh...I forgot to update the DTD when I implemented the feature. The feature works, it's just not in there. I will file a JIRA request. Thanks for bringing it to my attention.
Actions
5. Re: Prefill Pool for XA Datasource?

alrubinger Jan 30, 2007 5:56 PM (in response to alrubinger)

And thank you for your help.

S,
ALR
Actions
6. Re: Prefill Pool for XA Datasource?

alrubinger Jan 30, 2007 6:01 PM (in response to alrubinger)

Actually...send me a link to the JIRA task? I gotta get this working for myself anyway, so I'll fix and commit it.

S,
ALR
Actions
7. Re: Prefill Pool for XA Datasource?

weston.price Jan 30, 2007 6:09 PM (in response to alrubinger)

Just the DTD needs updating. Not the actual code.
Actions
8. Re: Prefill Pool for XA Datasource?

weston.price Jan 30, 2007 6:12 PM (in response to alrubinger)
Hmmm...looking at the 1.5 DTD I may have put it in.

 <!ELEMENT prefill (#PCDATA) >
Actions
9. Re: Prefill Pool for XA Datasource?

weston.price Jan 30, 2007 6:15 PM (in response to alrubinger)

Note, as per the Wiki. You can only prefill connection pools that do not require a subject or username/password (ie ConnectionRequestInfo). This information must be known upfront prior to filling the pool. It's fairly limited in that respect at this point.
Actions
10. Re: Prefill Pool for XA Datasource?

alrubinger Jan 30, 2007 6:32 PM (in response to alrubinger)
Yep, was going to offer to just change the DTD.

DTD in $JBOSS_HOME/docs/dtd looks good.

The public version online is probably just out-of-date:

http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd

From "docs" in my installation:
$Id: jboss-ds_1_5.dtd 45250 2006-05-25 21:35:10Z wprice $

Online:
$Id: jboss-ds_1_5.dtd,v 1.1.2.10 2005/09/05 05:11:51 starksm Exp

Thanks again for looking into this.

S,
ALR
Actions
11. Re: Prefill Pool for XA Datasource?

weston.price Jan 30, 2007 6:39 PM (in response to alrubinger)

No problem man, thank you for your offer of support. Any of those outstanding JIRA tasks you want to take a crack at...please feel free ;-)
Actions

Go to original post