Hello,
I try to perform a POC to setup an Unsupported Database with Confluence.
I have followed the Article : https://confluence.atlassian.com/doc/configuring-a-datasource-connection-937166084.html
But when I'm trying to test the connection, I have the Following message :
com.atlassian.config.bootstrap.BootstrapException: Could not locate datasource: java:comp/env/jdbc/DefaultDB
The Database i'm trying to connect is HANA.
The JBDBC driver is availaible here : https://tools.hana.ondemand.com/additional/ngdbc-latest.jar
I have copy the file in C:\Program Files\Atlassian\Confluence\lib
In C:\Program Files\Atlassian\Confluence\conf\server.xml
<!-- Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties -->
<Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"
username="my-hana-username"
password="my-hana-password"
driverClassName="com.sap.db.jdbc.Driver"
url="jdbc:sap://myserver:30041"
maxTotal="60"
maxIdle="20"
validationQuery="select 1 from dummy"/>
<Manager pathname=""/>
In C:\Program Files\Atlassian\Confluence\confluence\WEB-INF\web.xml
<resource-ref>
<description>Connection Pool</description>
<res-ref-name>jdbc/confluence</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
I have restarted Confluence and in Datasource name I have put :
java:comp/env/jdbc/confluence, the connection test is OK.
Then I have error 500 issue :
Type Rapport d'exception
message Error creating bean with name 'tenantedTransactionManager' defined in class path resource [databaseSubsystemContext.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedLocalSessionFactoryBean5' defined in class path resource [productionDatabaseContext.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: The configured database supports neither identity nor the sequence generator