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)

Fixing the Error

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:
< 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" />
You should then:
  1. Shut down Confluence
  2. Open the confluence-cfg.xml file in your Confluence Home directory in a text editor
  3. Delete the following lines if you find them:
    • <property name="hibernate.connection.password">your-password</property>
    • <property name="hibernate.connection.username">your-username</property>
  4. Save the modified file
  5. Restart Confluence