-
15. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
Hi Paul
Thanks for you usual Support.
I did the test under the 13.0.0 Final and it was reproduced, I will do my test under the 14.0.1 Final Version and I will let you know the results.
Thanks and Best Regards
-
16. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
Dear Paul
I did the same JDBC configuration as Wildffly 12.0.0.Final and 13.0.0.Final however i'm receiving the below Exception on Widlfly 14.0.1.Final Kindly advice:
2018-10-03 17:20:49,809 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41) WFLYCTL0013: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("jdbc-driver" => "oracle")
.................................
2018-10-03 17:20:51,563 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "OracleDS")
]) - failure description: {
"WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.oracle"],
"WFLYCTL0180: Services with missing/unavailable dependencies" => [
"jboss.driver-demander.java:jboss/iMALServices is missing [jboss.jdbc-driver.oracle]",
"org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]"
]
}
2018-10-03 17:20:51,565 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "OracleDS")
]) - failure description: {
"WFLYCTL0412: Required services that are not installed:" => [
"jboss.jdbc-driver.oracle",
"jboss.jdbc-driver.oracle"
],
"WFLYCTL0180: Services with missing/unavailable dependencies" => [
"jboss.driver-demander.java:jboss/iMALServices is missing [jboss.jdbc-driver.oracle]",
"org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]",
"org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]"
]
}
2018-10-03 17:20:51,597 INFO [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
WFLYCTL0184: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.oracle (missing) dependents: [service org.wildfly.data-source.OracleDS, service jboss.driver-demander.java:jboss/iMALServices]
Thanks and Best Regards
-
17. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
Can you elaborate on how you've configured your DataSource and setup your module for the oracle JDBC driver?
-
18. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
Dear Paul
Find below the requested:
*Below the content of Standalone.xml (datasource and driver Configuration):
<datasource jta="false" jndi-name="java:jboss/Services12" pool-name="OracleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@//192.168.15.110:1521/ORA12S9</connection-url>
<driver>oracle</driver>
<security>
<user-name>USERNAME</user-name>
<password>PASSWORD</password>
</security>
</datasource>
<drivers>
<driver name="oracle" module="com.oracle">
<xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
</driver>
</drivers>
*Under JBOSS_ROOT\modules\system\layers\base\com\oracle\main we have the following files
- module.xml
- ojdbc7.jar
*Below the content of module.xml :
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.oracle">
<resources>
<resource-root path="ojdbc7.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
Best Regards
-
19. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
oracle.jdbc.OracleDriver implements java.sql.Driver, not javax.sql.xa.XADataSource.
Therefore, your driver definition should look like:
<driver name="oracle" module="com.oracle">
<driver-class>oracle.jdbc.OracleDriver</driver-class>
</driver>
-
20. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
Dear Paul
Thanks for you reply the JDBC is working fine, however the issue still reproduced under Widlfly 14.0.1.Final.
Any idea how to monitor the server Logs?
Best Regards
-
21. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
OK - so I seem to be missing some detail in my reproducer, because I was not able to reproduce it locally. Would you file an issue in jira? - JBoss Issue Tracker
and attach a simplified reproducer (i.e. containing the Book, BookPreview, and TestBean classes)? Once I can reproduce the issue myself, I can find the underlying cause and submit a fix.
-
23. Re: Wildfly 12.0.0 Final Delay in Getting the Value Attributes of the Session Variables (Result in Null Pointer Exception)
Dear pferraro
Be advised; I just set the log level to ALL and below logs was displayed before the NPE; seems like the page is not being Authenticated to retrieve session values:
2019-04-09 13:43:58,991 DEBUG [io.undertow.request.security] (default task-2) Attempting to authenticate /book_store/BookPreview, authentication required: false
2019-04-09 13:43:58,991 DEBUG [io.undertow.request.security] (default task-2) Authentication outcome was NOT_ATTEMPTED with method io.undertow.security.impl.CachedAuthenticatedSessionMechanism@6640b4be for /book_store/BookPreview
2019-04-09 13:43:58,991 DEBUG [io.undertow.request.security] (default task-2) Authentication result was ATTEMPTED for /book_store/BookPreview
Kindly Advice.
Best Regards