[esb-issues] [JBoss JIRA] Commented: (JBESB-3481) ESB 5.0 GA doesn't honor system property for ESB data sources

[Kevin Conner (JIRA)]

    [ https://jira.jboss.org/browse/JBESB-3481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12552155#action_12552155 ] 

Kevin Conner commented on JBESB-3481:
-------------------------------------

This looks like it is a core server issue rather than an ESB issue, which version of the server are you using?

> ESB 5.0 GA doesn't honor system property for ESB data sources
> -------------------------------------------------------------
>
>                 Key: JBESB-3481
>                 URL: https://jira.jboss.org/browse/JBESB-3481
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Application Server
>    Affects Versions: 5.0
>         Environment: RHEL 64bit
>            Reporter: Dave Siracusa
>            Priority: Minor
>             Fix For: 5.0
>
>
> I have changed the esb data sources to use system properties.
> Properties are loaded from a file via jboss-service.xml via
>    <mbean code="org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary"
>       name="jboss.jdbc:service=metadata"/>
>   	<mbean code="org.jboss.varia.property.SystemPropertiesService"
> 	 name="jboss:type=Service,name=MySystemProperties">
>    	<attribute name="URLList">
>       	machine.properties
>    	</attribute>
>    </mbean>
> All properties work, except ESB_ORACLE_POOL_SIZE.
> It doesn't generate an error it simply reverts to minimum pool size value.  
> <datasources>
>   <local-tx-datasource>
>     <jndi-name>JmsDS</jndi-name>
>     <connection-url>${ESB_ORACLE_URL}</connection-url>
>     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
>     <user-name>${ESB_ORACLE_USER}</user-name>
>     <password>${ESB_ORACLE_PWD}</password>
>     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
>     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
>     <min-pool-size>15</min-pool-size>
>     <max-pool-size>${ESB_ORACLE_POOL_SIZE}</max-pool-size>
>     <prepared-statement-cache-size>50</prepared-statement-cache-size>
>     <share-prepared-statements>true</share-prepared-statements>
>     <metadata>
>        <type-mapping>Oracle9i</type-mapping>
>     </metadata>
>   </local-tx-datasource>
> </datasources>
> #ybsoa
> ESB_ORACLE_USER=YBPRDESB
> ESB_ORACLE_PWD=.......
> ESB_ORACLE_URL=jdbc:oracle:thin:@(DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = vip-ybkopracdb04.corp.ybusa.net) (Port = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = vip-ybkopracdb05.corp.ybusa.net)(PORT = 1521)))(CONNECT_DATA=(SERVICE_NAME = ESB)(SERVER = DEDICATED)))
> ESB_ORACLE_POOL_SIZE=100

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira