Fix 'Not supported by BasicDataSource' Setup or Startup Error
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When running Tomcat 6, connecting to the database using a Tomcat-configured DataSource, Confluence will not start. During setup you see the following error message:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Setup Datasource Database Failed
Setting up datasource database instance failed. You can either try it again
or or go back to the database selection page:
Restart Database Setup
Setup Datasource Database Again
The following error(s) occurred:
Configuring the database failed. Couldn't create the database schema.
Could not open Hibernate Session for transaction; nested exception is
java.lang.UnsupportedOperationException: Not supported by BasicDataSource
Context initialization failed: Could not open Hibernate Session for
transaction; nested exception is java.lang.UnsupportedOperationException:
Not supported by BasicDataSource
---------------------
Or, during start-up the following stack-trace is logged:
1
2
3
4
5
6
7
8
9
10
org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction;
nested exception is java.lang.UnsupportedOperationException: Not supported by BasicDataSource
Caused by: java.lang.UnsupportedOperationException: Not supported by BasicDataSource
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:899)
at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection
(DatasourceConnectionProvider.java:56)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
Cause
Tomcat 6 does not allow applications to authenticate DataSource connections. You must make sure that you have supplied a username and password in the DataSource configuration in your Tomcat config files, for example:
1
2
3
4
5
6
<Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"
username="cmiller"
password="mysecret"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost/t6test"
maxActive="20"/>
Resolution
Shut down Confluence
Open the
confluence.cfg.xmlfile in your Confluence Home directory in a text editorDeletethe following lines if you find them:
<property name="hibernate.connection.password">your-password</property>
<property name="hibernate.connection.username">your-username</property>
Save the modified file
Restart Confluence
Was this helpful?