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.

  • Import application - 500 server error (4.2.4)
    via by swesley_perth,
  • 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-00028: your session has been killed at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4C7Ocommoncall.processError(T4C7Ocommoncall.java:100) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:80) at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:659) at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:5081) at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:5098) at org.identityconnectors.dbcommon.DatabaseConnection.commit(DatabaseConnection.java:183) at org.identityconnectors.dbcommon.DatabaseConnection.test(DatabaseConnection.java:104) at org.identityconnectors.dbum.DBUMConnector.checkAlive(DBUMConnector.java:98) at org.identityconnectors.framework.impl.api.local.ConnectorPoolManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:105) at org.identityconnectors.framework.impl.api.local.ConnectorPoolManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:74) at org.identityconnectors.framework.impl.api.local.ObjectPool.borrowObject(ObjectPool.java:229) at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:83) at com.sun.proxy.$Proxy504.search(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:107) at com.sun.proxy.$Proxy504.search(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:162)

    Users with the same issue

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