Error in database connection string for Oracle

Issue #120 resolved
Marianne Lee (Nagarro) created an issue

Hi,

The database driver for Oracle is configured successfully for Confluence server version 7.3.2. I get this error when I try to create a new profile:

Error creating connection: java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

The connection string returned is in the format: jdbc:oracle:thin:@//<HOST>:<PORT>:<SERVICE>

Should it be “/” instead of “:” as described in Atlassian’s documentation? jdbc:oracle:thin:@//<HOST>:<PORT>/<SERVICE> ref. https://confluence.atlassian.com/doc/database-setup-for-oracle-173821.html

How do I fix the error?

Thanks and regards,
Marianne Lee

Comments (4)

  1. Log in to comment