-
1. Re: WildFly-14: Oracle Url is invalid
claudio4j Aug 31, 2018 3:01 PM (in response to mayerw01)I created a oracle datasource with: jdbc:oracle:thin:@localhost:1521:orcalesid222 and it worked, then edited and saved with no problem.
If you upgraded wildfly, it may be possible the HAL javascript code is cached, in this case, can you clean your browser cache and try again ?
-
2. Re: WildFly-14: Oracle Url is invalid
mayerw01 Sep 2, 2018 5:33 AM (in response to claudio4j)Claudio did you also test the connection?
I cleaned the browser cache and the issue with the '@' character disappeared.
But the connection does still not work. And now I realized that following message is logged at startup:
12:48:09,894 WARN [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer] (MSC service thread 1-4) IJ020020: Connection Properties for DataSource: 'java:jboss/datasources/OracleTicket2RockDS' is empty, try to use driver-class: 'oracle.jdbc.driver.OracleDriver' and connection-url: 'jdbc:oracle:thin:@gigabyte:1521:xe' to connect database
The test connection logs another message:
12:59:35,673 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (External Management Request Threads -- 2) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
It looks like the <connection-url> and <driver-class> parameters are ignored at all.
When I add the Connection Properties the IJ020020 message is gone but 2 other exceptions are thrown:
Caused by: javax.resource.ResourceException: IJ031089: Failed to load datasource: oracle.jdbc.pool.OracleDataSource
at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getDataSource(LocalManagedConnectionFactory.java:654)
at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:313)
... 35 more
Caused by: java.lang.NoSuchMethodException: Method setDriver-class not found
at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.util.Injection.inject(Injection.java:139)
at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.util.Injection.inject(Injection.java:68)
I then tried to add a datasource for Postgres. It shows the same IJ020020 and IJ000604 messages.
But the connection to MySql astonishly is working properly.
What wonders me even more is that the XA connections for Oracle and Postgres work properly. So this issue seems to be related to non XA.
When I choose "Custom" to specify my own settings the connection works.
So there seems to be an issue with the predefined templates!
-
3. Re: WildFly-14: Oracle Url is invalid
claudio4j Sep 4, 2018 9:48 AM (in response to mayerw01)Can you paste the result of /subsystem=datasources//data-source=myds:read-resource ?
-
4. Re: WildFly-14: Oracle Url is invalid
mayerw01 Sep 4, 2018 11:06 AM (in response to claudio4j)I am not quite sure what you want me to do. The datatasource 'myds' does not exist in my environment.
And the other datasources are now working since I used the 'Custom' option for the set up.
But here is the output of '/subsystem=datasources/data-source=OracleTicket2RockDS:read-resource instead'
{
"outcome" => "success",
"result" => {
"allocation-retry" => undefined,
"allocation-retry-wait-millis" => undefined,
"allow-multiple-users" => false,
"authentication-context" => undefined,
"background-validation" => undefined,
"background-validation-millis" => undefined,
"blocking-timeout-wait-millis" => undefined,
"capacity-decrementer-class" => undefined,
"capacity-decrementer-properties" => undefined,
"capacity-incrementer-class" => undefined,
"capacity-incrementer-properties" => undefined,
"check-valid-connection-sql" => undefined,
"connectable" => false,
"connection-listener-class" => undefined,
"connection-listener-property" => undefined,
"connection-url" => "jdbc:oracle:thin:@gigabyte:1521:XE",
"credential-reference" => undefined,
"datasource-class" => undefined,
"driver-class" => "oracle.jdbc.driver.OracleDriver",
"driver-name" => "oracle",
"elytron-enabled" => false,
"enabled" => true,
"enlistment-trace" => false,
"exception-sorter-class-name" => undefined,
"exception-sorter-properties" => undefined,
"flush-strategy" => undefined,
"idle-timeout-minutes" => undefined,
"initial-pool-size" => undefined,
"jndi-name" => "java:jboss/datasources/OracleTicket2RockDS",
"jta" => true,
"max-pool-size" => undefined,
"mcp" => "org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool",
"min-pool-size" => undefined,
"new-connection-sql" => undefined,
"password" => "ticket2rock",
"pool-fair" => undefined,
"pool-prefill" => undefined,
"pool-use-strict-min" => undefined,
"prepared-statements-cache-size" => undefined,
"query-timeout" => undefined,
"reauth-plugin-class-name" => undefined,
"reauth-plugin-properties" => undefined,
"security-domain" => undefined,
"set-tx-query-timeout" => false,
"share-prepared-statements" => false,
"spy" => false,
"stale-connection-checker-class-name" => undefined,
"stale-connection-checker-properties" => undefined,
"statistics-enabled" => false,
"track-statements" => "NOWARN",
"tracking" => false,
"transaction-isolation" => undefined,
"url-delimiter" => undefined,
"url-selector-strategy-class-name" => undefined,
"use-ccm" => true,
"use-fast-fail" => false,
"use-java-context" => true,
"use-try-lock" => undefined,
"user-name" => "ticket2rock",
"valid-connection-checker-class-name" => undefined,
"valid-connection-checker-properties" => undefined,
"validate-on-match" => undefined,
"connection-properties" => undefined,
"statistics" => {
"jdbc" => undefined,
"pool" => undefined
}
}
}
-
5. Re: WildFly-14: Oracle Url is invalid
claudio4j Sep 10, 2018 6:44 PM (in response to mayerw01)Sorry to take so long to get back, is the problem still persists ?
-
6. Re: WildFly-14: Oracle Url is invalid
mayerw01 Sep 11, 2018 4:00 AM (in response to claudio4j)The problem persists in so far that the templates are erroneous.
When choosing "custom" erverything seems to be working
-
7. Re: WildFly-14: Oracle Url is invalid
claudio4j Sep 13, 2018 5:16 PM (in response to mayerw01)Can you post the "oracle" jdbc-driver configuration ?
/subsystem=datasources/jdbc-driver=oracle:read-resource
-
8. Re: WildFly-14: Oracle Url is invalid
mayerw01 Sep 14, 2018 3:56 AM (in response to claudio4j)<driver name="oracle" module="com.oracle">
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
{
"outcome" => "success",
"result" => {
"deployment-name" => undefined,
"driver-class-name" => "oracle.jdbc.driver.OracleDriver",
"driver-datasource-class-name" => undefined,
"driver-major-version" => undefined,
"driver-minor-version" => undefined,
"driver-module-name" => "com.oracle",
"driver-name" => "oracle",
"driver-xa-datasource-class-name" => "oracle.jdbc.xa.client.OracleXADataSource",
"jdbc-compliant" => undefined,
"module-slot" => undefined,
"profile" => undefined,
"xa-datasource-class" => undefined
}
}
-
9. Re: WildFly-14: Oracle Url is invalid
claudio4j Sep 14, 2018 1:17 PM (in response to mayerw01)I could test it now, the Oracle template wrongly uses the oracle.jdbc.pool.OracleDataSource as datasource-class, but the correct value should be oracle.jdbc.datasource.OracleDataSource.
You can use the "Custom" template or use the Oracle template and later clear the datasource-class attribute of the datasource entry.
Thanks for reporting this error.
-
10. Re: WildFly-14: Oracle Url is invalid
claudio4j Sep 14, 2018 2:20 PM (in response to claudio4j)I just confused the tests locally, the oracle jdbc datasource oracle.jdbc.pool.OracleDataSource is correct. The oracle.jdbc.datasource.OracleDataSource is a interface and will not work.
Setting the datasource-class and testing it, thows URL Oracle invalid: OracleDataSource.makeURL. To fix it just remove the datasource-class from the datasource entry.