Liferay 5.2.2 working with Oracel database problem

[Vesselina Bakalov, modificado hace 15 años.]

I have a problem to run Liferay 5.2.2, the Tomcat 6 bundle with Oracle 9i. It created the tables but could not get connection through Hibernate later.

I did the following steps:

1) I added the following entry into portal-ext.properties:

jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@server:1521:SID
jdbc.default.username=uname
jdbc.default.password=password
hibernate.dialect=org.hibernate.dialect.Oracle9iDialect

2) I copied ojdbc14.jar to lib/ext folder under Tomcat

3) I added into ROOT.xml

<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@server:1521:SID"
username="xxx"
password="yz"
maxActive="20"
/>

It seems like tables are successfully created but I get the error below:

2009-04-09 15:18:02,753 INFO [main] util.PortalImpl - Portal lib directory /C:/LiferayTomcat6/liferay-portal-5.2.2/tomcat-6.0.18/webapps/ROOT/WEB-INF/lib/
2009-04-09 15:18:46,190 INFO [main] sql.DBUtil - Using dialect org.hibernate.dialect.Oracle9iDialect
2009-04-09 15:19:28,097 ERROR [main] transaction.JDBCTransaction - JDBC begin failed
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTarge

Please help if you can.Thanks.