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

[Lin Gao (JIRA)]

Lin Gao created WFLY-7216:
-----------------------------

             Summary: Valid Wildfly 10.0.0.Final DataSource fails in Wildfly 10.1.0.Final
                 Key: WFLY-7216
                 URL: https://issues.jboss.org/browse/WFLY-7216
             Project: WildFly
          Issue Type: Bug
          Components: JCA
    Affects Versions: 10.1.0.Final
            Reporter: Lin Gao
            Assignee: Lin Gao


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
(v6.4.11#64026)