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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Adrian Brock > Sent: 07 January 2004 13:19 > To: [EMAIL 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:@192.168.1.12:1521:mridul</xa-data > 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 <[EMAIL PROTECTED]> wrote: > > > 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 > > [EMAIL 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 [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
