...
To avoid the error message, you need to remove the profile from the SQL for Confluence configuration Add-on i.e. from the SQL for Confluence configuration Add-on, go to view and modify Data source profiles and remove the related profile.
Next, you can try using the SQL macro on a test page and enter the Data source name jdbc/confluence and click on the preview.
Error Message
| Code Block |
|---|
"Cannot create PoolableConnectionFactory (IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair)". |
...
| Code Block |
|---|
ERROR [http-nio-8096-exec-25] [confluence.sql.config.DBConnection] globalDSConnection Error finding Datasource : java.sql.SQLException: Cannot create PoolableConnectionFactory (IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair)
|
Cause
| Panel | ||
|---|---|---|
| ||
When you create a new connection, and choose the Data Source name, it seems to be pulling the information from the server.xml file and showing the correct port that is used for the SSL connection. So when created the connection and clicked on "Test Connection", it gives the above error message. |
Solution
The issue is with the tnsnames.ora file in Oracle and the solution would be to review(look for any unbalanced parenthesis) in the tnsnames.ora file and re-create.
| Info |
|---|
If Datasource (with SSL connection ) is included within server.xml, it's not required to configure from the SQL add-on Profile page. |