Re: Re: pool properties of "jonas-ra.xml" not setted/ignored

Pool parameters are not set using config-property elements.
They have a dedicated pool configuration element:

<pool-params>
       <pool-init>0</pool-init>
       <pool-min>0</pool-min>
       <pool-max>100</pool-max>
       <pool-max-age>0</pool-max-age>
       <pstmt-max>20</pstmt-max>
     </pool-params>


Cheers
--G

Le 12/01/2011 12:05, Stefano Arosio a écrit :
>
>
> Hello.
> I'm using jonas 5.1.2 and I have a configuration problem with a XA 
> "JDBC Resource Adapters".
>
> The parameter setted in jonas-ra.xml like "mapperName"*,*"user" and 
> "password" are configured properly, but all pool parameters are 
> ignored. Under here i copy the |jonas-ra.xml and |the "jadmin web 
> page" where you can see that the pool properties are not setted.
>
> What is the problem?
>
> thank you,
> Stefano Arosio
>
> *JADMIN WEB PAGE*
>
> Resource Adapter
> *Name* 		db_mainDbRa_XA
> *JNDI Name* 		jdbcmps
> *File* 		db_mainDbRa_XA.rar
> *Path* 		/mydir/deploy/db_mainDbRa_XA.rar
>
> Properties
>
> *databaseName* 		
> *dbSpecificMethods* 		
> *description* 		
> *dsClass* 		oracle.jdbc.xa.client.OracleXADataSource
> *isolationLevel* 		
> *loginTimeout* 		0
> *logTopic* 		
> *mapperName* 		rdb.oracle
> *password* 		mypassword
> *portNumber* 		12345
> *serverName* 		server1
> *user* 		myuser
>
> Pool properties
>
> *Maximum age* 		0
> 	Connection maximum age (Value in minutes)
> *Maximum open time* 		0
> 	Connection maximum open time (Value in minutes)
> *Pool initial size* 		0 	Initial size of the connection pool
> *Pool minimum* 		0
> 	Minimum size of the connection pool
> *Pool maximum* 		-1
> 	Maximum size of the connection pool (-1 = no max)
> *Max Wait Time* 		10
> 	Maximum time in seconds to wait for a Connection (0 = no wait)
> *Max Waiters* 		0
> 	Maximum number of concurrent waiters for a Connection
> *Sampling Period* 		30
> 	Sampling Period in seconds
>
>
>
> *jonas-ra.xml*
>
> <?xml version = "1.0" encoding = "UTF-8"?>
> <jonas-connector xmlns="http://www.objectweb.org/jonas/ns"
>  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>  xsi:schemaLocation="http://www.objectweb.org/jonas/ns
> http://www.objectweb.org/jonas/ns/jonas-connector_4_2.xsd" >
>
>
> <jndi-name>jdbcmps</jndi-name>
> <rarlink>JOnASJDBC_XA</rarlink>
> <jonas-config-property>
> <jonas-config-property-name>dsClass</jonas-config-property-name>
> <jonas-config-property-value>
>                       oracle.jdbc.xa.client.OracleXADataSource
> </jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>mapperName</jonas-config-property-name>
> <jonas-config-property-value>
>                       rdb.oracle
> </jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>dbSpecificMethods</jonas-config-property-name>
> <jonas-config-property-value></jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>serverName</jonas-config-property-name>
> <jonas-config-property-value>server1</jonas-config-property-value>
> </jonas-config-property>
>
> <jonas-config-property>
> <jonas-config-property-name>portNumber</jonas-config-property-name>
> <jonas-config-property-value>12345</jonas-config-property-value>
> </jonas-config-property>
>
> <jonas-config-property>
> <jonas-config-property-name>user</jonas-config-property-name>
> <jonas-config-property-value>myuser</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>password</jonas-config-property-name>
> <jonas-config-property-value>mypassword</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-max-age-minutes</jonas-config-property-name>
> <jonas-config-property-value>30</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-max-opentime</jonas-config-property-name>
> <jonas-config-property-value>60</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>jdbc-check-level</jonas-config-property-name>
> <jonas-config-property-value>1</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>jdbc-test-statement</jonas-config-property-name>
> <jonas-config-property-value>
>                      select * from dual
> </jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-min</jonas-config-property-name>
> <jonas-config-property-value>1</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-max</jonas-config-property-name>
> <jonas-config-property-value>30</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-sampling-period</jonas-config-property-name>
> <jonas-config-property-value>30</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-max-waittime</jonas-config-property-name>
> <jonas-config-property-value>5</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pool-max-waiters</jonas-config-property-name>
> <jonas-config-property-value>100</jonas-config-property-value>
> </jonas-config-property>
> <jonas-config-property>
> <jonas-config-property-name>pstmt-max</jonas-config-property-name>
> <jonas-config-property-value>0</jonas-config-property-value>
> </jonas-config-property>
>
> </jonas-connector>
>
>

begin:vcard
fn:Guillaume Sauthier
n:Sauthier;Guillaume
org:<a href="http://www.ow2.org"><img title="OW2" alt="OW2 Consortium" border="0" src="http://www.ow2.org/xwiki/bin/skin/XWiki/DefaultSkin/logoOW2.png" /></a>
adr:;;;;;;France
email;internet:[email protected]
title:<a href="http://jonas.ow2.org">JOnAS Application Server</a>
url:http://jonas.ow2.org
version:2.1
end:vcard