[jboss-jira] [JBoss JIRA] (WFLY-7018) Valid Wildfly 10.0.0.Final DataSource fails in Wildfly 10.1.0.Final

[Arnie Morein (JIRA)]

    [ https://issues.jboss.org/browse/WFLY-7018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13348743#comment-13348743 ] 

Arnie Morein commented on WFLY-7018:
------------------------------------

The main web site only has 1.2.7.Final (http://www.ironjacamar.org/download.html). Where is 1.4.0? WildFly 10.1.0 ships with 1.3.4.Final. The data source in question is:

{code:java}
<datasource jta="true" jndi-name="java:jboss/datasources/txg_pme_tracking"
	pool-name="txg_pme_tracking" enabled="true" use-ccm="true">
	<connection-url>jdbc:mysql://server-name:3306/txg_pme_tracking</connection-url>
	<connection-property name="databaseName">
		txg_pme_tracking
	</connection-property>
	<driver>mysql</driver>
	<new-connection-sql>select * from sys_parameter where 0 = 1</new-connection-sql>
	<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
	<pool>
		<min-pool-size>5</min-pool-size>
		<initial-pool-size>5</initial-pool-size>
		<max-pool-size>10</max-pool-size>
		<prefill>true</prefill>
		<flush-strategy>Gracefully</flush-strategy>
	</pool>
	<security>
		<user-name>username</user-name>
		<password>password</password>
	</security>
	<validation>
		<valid-connection-checker
			class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker" />
		<check-valid-connection-sql>select * from sys_parameter where 0 = 1</check-valid-connection-sql>
		<background-validation>true</background-validation>
		<exception-sorter
			class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter" />
	</validation>
</datasource>
{code}


> Valid Wildfly 10.0.0.Final DataSource fails in Wildfly 10.1.0.Final
> -------------------------------------------------------------------
>
>                 Key: WFLY-7018
>                 URL: https://issues.jboss.org/browse/WFLY-7018
>             Project: WildFly
>          Issue Type: Bug
>          Components: JCA
>    Affects Versions: 10.1.0.Final
>            Reporter: Mark S
>            Assignee: Lin Gao
>             Fix For: 11.0.0.Alpha1
>
>
> My current Wildfly 10.0.0.Final (Non-XA) Datasource configuration will not work for Wildfly 10.1.0.Final. See the "Steps to Reproduce" section.
> The stacktrace points to here:
> * https://source.jboss.org/browse/IronJacamar/adapters/src/main/java/org/jboss/jca/adapters/jdbc/local/LocalManagedConnectionFactory.java?hb=true#to108
> * https://github.com/ironjacamar/ironjacamar/blob/ironjacamar-1.3.4.Final/adapters/src/main/java/org/jboss/jca/adapters/jdbc/local/LocalManagedConnectionFactory.java#L108
> h3. The work-around
> h3. Wildfly 10.1.0.Final Datasource configuration via CLI
> {code}
> 	# No parameter to set a connection property value.
> {code}
> h3.  Wildfly 10.1.0.Final Datasource configuration via XML (standalone-full.xml)
> Note the addition of {{<connection-property name="databaseName">myapp</connection-property>}}
> {code:xml}
> <subsystem xmlns="urn:jboss:domain:datasources:4.0">
> 	<datasources>
> 		<datasource jndi-name="java:/MY_APP_DS" pool-name="Postgres_MY_APP_DS">
> 			<connection-url>jdbc:postgresql://localhost:5432/myapp</connection-url>
> 			<connection-property name="databaseName">myapp</connection-property>
> 			<driver>postgres</driver>
> 			<security>
> 				<user-name>myapp</user-name>
> 				<password>myapp</password>
> 			</security>
> 			<validation>
> 				<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>
> 				<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>
> 			</validation>
> 		</datasource>
> 		<drivers>
> 			<driver name="postgres" module="org.postgres">
> 				<driver-class>org.postgresql.Driver</driver-class>
> 				<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
> 				<datasource-class>org.postgresql.ds.PGSimpleDataSource</datasource-class>
> 			</driver>
> 		</drivers>
> 	</datasources>
> </subsystem>
> {code}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)