Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JBoss User »

RE: [JBoss-user] Oracle Connection Pooling in 3.2.2

Alastair Rodgers

2004-01-07

Replies:

Out of interest, what happens if you omit min-pool-size/max-pool-size? Does this mean connections are not pooled, or does JBoss still use a pool but with some default settings instead? If the latter, where do the defaults come from?

Al.


> -----Original Message-----
> From: jboss-user-admin@(protected)
> [mailto:jboss-user-admin@(protected)
> Adrian Brock
> Sent: 07 January 2004 13:19
> To: jboss-user@(protected)
> Subject: RE: [JBoss-user] Oracle Connection Pooling in 3.2.2
>
>
> Check docs/dtd/jboss-ds_1_0.dtd for the possible configurations.
>
> For your specific question you want something like:
>
>     <min-pool-size>10</min-pool-size>
>     <max-pool-size>100</max-pool-size>
>
> Regards,
> Adrian
>
> On Wed, 2004-01-07 at 12:48, Mridul Jain wrote:
> > My file looks like this and works fine. But still I
> > don't know how to specify MaxSize and MinSize,
> > although I can see classes like
> > XAOracleManageConnection in jboss-xa-jdbc.rar etc.
> >
> >
> ----------------------------------------------------------------------
> > --------------
> > <datasources>
> >  <xa-datasource>
> >   <jndi-name>XAOracleDS</jndi-name>
> >  
> > <track-connection-by-tx>true</track-connection-by-tx>
> >  
> > <isSameRM-override-value>false</isSameRM-override-value>
> >  
> >
> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource<
> /xa-datasource-class>
> >   <xa-datasource-property
> >
> name="URL">jdbc:oracle:thin:@(protected)
> source-property>
> >   <xa-datasource-property
> name="User">scott</xa-datasource-property>
> >   <xa-datasource-property
> > name="Password">tiger</xa-datasource-property>
> >  
> >  
> >
> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.v
> endor.OracleExceptionSorter</exception-sorter-class-name>
> >  </xa-datasource>
> >
> >  <mbean
> >
> code="org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionForma
> > tter"
> >
> >      
> > name="jboss.jca:service=OracleXAExceptionFormatter">
> >   <depends
> >
> optional-attribute-name="TransactionManagerService">jboss:serv
ice=TransactionManager</depends>
> >  </mbean>
> >    
> > </datasources>
> >
> ----------------------------------------------------------------------
> > ----------------------------------
> >
> > MJ
> > --- Cor Hofman <chofman@(protected):
> > > Could you post your Oracle bit of your configuration
> > > as an example?
> > > I have to upgrade to 3.2.x fairly soon and also use
> > > Oracle.
> > > I would like to avoid making te same mistakes.
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> > http://hotjobs.sweepstakes.yahoo.com/signingbonus
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: IBM Linux Tutorials. Become an
> > expert in LINUX or just sharpen your skills. Sign up for
> IBM's Free
> > Linux Tutorials. Learn everything from the bash shell to
> sys admin.
> > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > _______________________________________________
> > JBoss-user mailing list
> > JBoss-user@(protected)
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> --
> xxxxxxxxxxxxxxxxxxxxxxxx
> Adrian Brock
> Director of Support
> Back Office
> JBoss Group, LLC
> xxxxxxxxxxxxxxxxxxxxxxxx
>
>


-------------------------------------------------------
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fast Software Configuration Management System offering
advanced branching capabilities and atomic changes on 50+ platforms.
Free Eval! http://www.perforce.com/perforce/loadprog.html
_______________________________________________
JBoss-user mailing list
JBoss-user@(protected)
https://lists.sourceforge.net/lists/listinfo/jboss-user


©2008 junlu.com - Jax Systems, LLC, U.S.A.