java.sql.SQLRecoverableException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • It would be useful if the "Configure SQL for Confluence" screen offered a facility to test datasources as they are added or modified. eg, a test button per data source. The documentation does provide a mechanism for testing: {noformat} ..create a page and use Insert -> Markup to add the following wiki markup : {sql-query:dataSource=example} select 1 {sql-query} {noformat} ...but this necessitates switching back and forth, etc, and is a bit more fiddly, and (most importantly) does not display the actual error message. To explain, in my tests I get logged exceptions that are really useful but Confluence does not display this: {noformat} 2015-08-11 14:37:49,767 ERROR [http-bio-8090-exec-241] [swift.confluence.sql.SqlDataHelper] getDatabaseConnectionFromDriverManager Exception: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441) 2015-08-11 14:37:49,777 WARN [http-bio-8090-exec-241] [xhtml.view.macro.ViewMacroMarshaller] marshalInternal Exception executing macro: sql-query, with message: Unable to connect to database using jdbc:oracle:thin:@xxxxx:9999:XE with user YYYYY -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent {noformat} In other words, the "ORA-01033: ORACLE initialization or shutdown in progress" is *much* more interesting that the "Unable to connect to database..." that is displayed by the macro.
    via by Mark Symons,
  • It would be useful if the "Configure SQL for Confluence" screen offered a facility to test datasources as they are added or modified. eg, a test button per data source. The documentation does provide a mechanism for testing: {noformat} ..create a page and use Insert -> Markup to add the following wiki markup : {sql-query:dataSource=example} select 1 {sql-query} {noformat} ...but this necessitates switching back and forth, etc, and is a bit more fiddly, and (most importantly) does not display the actual error message. To explain, in my tests I get logged exceptions that are really useful but Confluence does not display this: {noformat} 2015-08-11 14:37:49,767 ERROR [http-bio-8090-exec-241] [swift.confluence.sql.SqlDataHelper] getDatabaseConnectionFromDriverManager Exception: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441) 2015-08-11 14:37:49,777 WARN [http-bio-8090-exec-241] [xhtml.view.macro.ViewMacroMarshaller] marshalInternal Exception executing macro: sql-query, with message: Unable to connect to database using jdbc:oracle:thin:@xxxxx:9999:XE with user YYYYY -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent {noformat} In other words, the "ORA-01033: ORACLE initialization or shutdown in progress" is *much* more interesting that the "Unable to connect to database..." that is displayed by the macro.
    via by Mark Symons,
    • java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441)

    Users with the same issue

    tomthomas
    1 times, last one,
    Michael
    3 times, last one,