java.lang.UnsupportedOperationException: Not supported by BasicDataSource-白红宇

org.springframework.transaction.CannotCreateTransactionException:        Could not open Hibernate Session for transaction;        nested exception is java.lang.UnsupportedOperationException: Not supported by BasicDataSourceCaused 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:

Shut down Confluence

Open the confluence-cfg.xml file in your Confluence Home directory in a text editor

Delete the 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

本文转自yunlielai51CTO博客，原文链接：http://blog.51cto.com/4925054/1117453，如需转载请自行联系原作者