Announcement Announcement Module
Collapse
No announcement yet.
Oracle Connection Error Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle Connection Error

    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

  • #2
    Is there a space in your port number between 152 and 1?

    Comment


    • #3
      No space in between. It is just a typo here.

      Comment


      • #4
        missing a backslash?

        Should there be another backslash at between the IP and port? You've got all the other ones escaped, but not that one.

        Comment

        Working...
        X