[
https://issues.jboss.org/browse/WFLY-7018?page=com.atlassian.jira.plugin....
]
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/jb...
*
https://github.com/ironjacamar/ironjacamar/blob/ironjacamar-1.3.4.Final/a...
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)