org.springframework.transaction. CannotCreateTransactionExcepti on: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception. GenericJDBCException: Unable to acquire JDBC Connection
at org.springframework.orm.hibernate5. HibernateTransactionManager. doBegin( HibernateTransactionManager. java:598)
at org.springframework.transaction.support. AbstractPlatformTransactionMan ager.startTransaction( AbstractPlatformTransactionMan ager.java:400)
at org.springframework.transaction.support. AbstractPlatformTransactionMan ager.getTransaction( AbstractPlatformTransactionMan ager.java:373)
at org.springframework.transaction.interceptor. TransactionAspectSupport. createTransactionIfNecessary( TransactionAspectSupport.java: 595)
at org.springframework.transaction.interceptor. TransactionAspectSupport. invokeWithinTransaction( TransactionAspectSupport.java: 382)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([TibcoSoftware][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied
../Nimsoft/probes/service/wasp/webapps/cabijs/META-INF/context.xml is not properly updated
Follow steps below on the CABI robot
1. Stop the wasp probe
2, Backup the /opt/nimsoft/probes/service/wasp/webapps/cabijs/META-INF/context.xml file outside the original path.
3. Open the context.xml file and replace all the Oracle SID parameters with serviceName
In this example the Oracle servicename is PDB:
<Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="tibcosoftware.jdbc.oracle.OracleDriver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserverAudit" password="<encrypted password>" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:tibcosoftware:oracle://<oracleservername>:1521;serviceName=<pdb>" username="cauim" validationQuery="SELECT 1 FROM DUAL"/>
4. Save the changes and activate the probe.
5. Login directly to CABIJS portal with superuser and validate if the Home Page renders