Results 1 to 4 of 4

Thread: Oracle Connection Error

Hybrid View

  1. #1
    Join Date
    Feb 2011
    Location
    Bangalore
    Posts
    19

    Question 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. #2
    Join Date
    Aug 2004
    Location
    UK
    Posts
    108

    Default

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

  3. #3
    Join Date
    Feb 2011
    Location
    Bangalore
    Posts
    19

    Default

    No space in between. It is just a typo here.

  4. #4

    Default 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •