Hi,
I have created a ROO project using database reverse engineering.
Database: Oracle 10g

The project was created successfully. When I click on any link in the UI, It is showing an error

org.hibernate.exception.GenericJDBCException: Cannot open connection; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection

In console it is showing..

ERROR org.hibernate.util.JDBCExceptionReporter – Cannot create PoolableConnectionFactory (Io exception: Invalid number format for port number)

Here is my database.properties file:

database.password=password
database.url=jdbc\:oracle\:thin\:@192.111.2.24:152 1/:xe
database.username=user
database.driverClassName=oracle.jdbc.OracleDriver


I think the error is in connection url.(I tried it without '\'s)

Can anybody help me out.
Regards
Privin