1 2 Previous Next 16 Replies Latest reply: Nov 17, 2012 9:14 AM by 969237 RSS

    Error Message as 'Master Repo URL is not compatible with the JDBC Driver'

    969237
      Hi,
      I am recieving this error message 'Master Repo URL is not compatible with the JDBC Driver' while testing after filling the Master Repository Database Connection details in my system.I have installed Oracle Express edition 10g in my system and created master and work repositories in it.

      Driver is OracleJDBC Driver and URL is jdbc:orcl:thin:@localhost:1521:ORCL

      Hope it finds the solution ASAP.Any comments.

      Rachin Gupta
        • 1. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
          Bhabani Ranjan
          Your url is wrong. Take this
          jdbc:oracle:thin:@localhost:1521:ORCL
          • 2. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
            Sutirtha Roy
            966234 wrote:
            Hi,
            I am recieving this error message 'Master Repo URL is not compatible with the JDBC Driver' while testing after filling the Master Repository Database Connection details in my system.I have installed Oracle Express edition 10g in my system and created master and work repositories in it.

            Driver is OracleJDBC Driver and URL is jdbc:orcl:thin:@localhost:1521:ORCL
            URL should be

            jdbc:oracle:thin:@<host>:<port>:<sid>


            Hope it finds the solution ASAP.Any comments.

            Rachin Gupta
            • 3. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
              969237
              Now,
              That is resolved.It is saying 'Invalid Repository Connection' on clicking on Test.
              • 4. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                Bhabani Ranjan
                click on the error details and pest the complete error here.
                • 5. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                  969237
                  Now,
                  That is resolved.It is saying 'Invalid Repository Connection' on clicking on Test.
                  • 6. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                    969237
                    THIS IS THE ERROR MESSAGE I AM RECIEVING.


                    oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.     
                    Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                         at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:100)
                         at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
                         at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
                         at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
                         at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:755)
                         at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$4(SnpsDialogLoginDetail.java:743)
                         at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$2.performAction(SnpsDialogLoginDetail.java:287)
                         at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
                         at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                         at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                         at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                         at java.awt.Component.processMouseEvent(Component.java:6267)
                         at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                         at java.awt.Component.processEvent(Component.java:6032)
                         at java.awt.Container.processEvent(Container.java:2041)
                         at java.awt.Component.dispatchEventImpl(Component.java:4630)
                         at java.awt.Container.dispatchEventImpl(Container.java:2099)
                         at java.awt.Component.dispatchEvent(Component.java:4460)
                         at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                         at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                         at java.awt.Container.dispatchEventImpl(Container.java:2085)
                         at java.awt.Window.dispatchEventImpl(Window.java:2478)
                         at java.awt.Component.dispatchEvent(Component.java:4460)
                         at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                         at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
                         at java.awt.Dialog$1.run(Dialog.java:1046)
                         at java.awt.Dialog$3.run(Dialog.java:1098)
                         at java.security.AccessController.doPrivileged(Native Method)
                         at java.awt.Dialog.show(Dialog.java:1096)
                         at java.awt.Component.show(Component.java:1563)
                         at java.awt.Component.setVisible(Component.java:1515)
                         at java.awt.Window.setVisible(Window.java:842)
                         at java.awt.Dialog.setVisible(Dialog.java:986)
                         at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
                         at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
                         at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
                         at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
                         at oracle.odi.ui.LoginFactory.modifyLogin(LoginFactory.java:334)
                         at com.sunopsis.graphical.dialog.SnpsDialogLogin$3.performAction(SnpsDialogLogin.java:185)
                         at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
                         at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                         at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                         at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                         at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                         at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                         at java.awt.Component.processMouseEvent(Component.java:6267)
                         at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                         at java.awt.Component.processEvent(Component.java:6032)
                         at java.awt.Container.processEvent(Container.java:2041)
                         at java.awt.Component.dispatchEventImpl(Component.java:4630)
                         at java.awt.Container.dispatchEventImpl(Container.java:2099)
                         at java.awt.Component.dispatchEvent(Component.java:4460)
                         at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                         at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                         at java.awt.Container.dispatchEventImpl(Container.java:2085)
                         at java.awt.Window.dispatchEventImpl(Window.java:2478)
                         at java.awt.Component.dispatchEvent(Component.java:4460)
                         at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                         at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
                         at java.awt.Dialog$1.run(Dialog.java:1046)
                         at java.awt.Dialog$3.run(Dialog.java:1098)
                         at java.security.AccessController.doPrivileged(Native Method)
                         at java.awt.Dialog.show(Dialog.java:1096)
                         at java.awt.Component.show(Component.java:1563)
                         at java.awt.Component.setVisible(Component.java:1515)
                         at java.awt.Window.setVisible(Window.java:842)
                         at java.awt.Dialog.setVisible(Dialog.java:986)
                         at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
                         at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
                         at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
                         at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
                         at oracle.odi.ui.OdiConnectController.handleEvent(OdiConnectController.java:113)
                         at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)
                         at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:897)
                         at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:501)
                         at oracle.odi.ui.docking.AbstractOdiDockableWindow$1.actionPerformed(AbstractOdiDockableWindow.java:203)
                         at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                         at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                         at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                         at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                         at java.awt.Component.processMouseEvent(Component.java:6267)
                         at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                         at java.awt.Component.processEvent(Component.java:6032)
                         at java.awt.Container.processEvent(Container.java:2041)
                         at java.awt.Component.dispatchEventImpl(Component.java:4630)
                         at java.awt.Container.dispatchEventImpl(Container.java:2099)
                         at java.awt.Component.dispatchEvent(Component.java:4460)
                         at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                         at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                         at java.awt.Container.dispatchEventImpl(Container.java:2085)
                         at java.awt.Window.dispatchEventImpl(Window.java:2478)
                         at java.awt.Component.dispatchEvent(Component.java:4460)
                         at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                         at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                         at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
                         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
                         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
                         at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
                    Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                         at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
                         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
                         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
                         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
                         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
                         at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
                         at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
                         at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
                         at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
                         at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:376)
                         at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78)
                         ... 111 more
                    Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                         at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
                         at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
                         at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
                         at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
                         ... 121 more
                    Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                         at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
                         at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
                         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:943)
                         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873)
                         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
                         at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$DataSourceInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:48)
                         at $Proxy0.getConnection(Unknown Source)
                         at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
                         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
                         at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
                         at java.util.concurrent.FutureTask.run(FutureTask.java:138)
                         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
                         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
                         at java.lang.Thread.run(Thread.java:619)
                    Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                         at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)
                         at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)
                         at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)
                         at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:122)
                         at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1610)
                         at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1446)
                         at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:514)
                         at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.createOnePooledConnection(OracleJDBCConnectionPool.java:129)
                         at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:297)
                         at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:142)
                         at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:157)
                         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:931)
                         ... 14 more

                    Edited by: 966234 on Nov 14, 2012 7:20 AM
                    • 7. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                      JeromeFr
                      Your oracle listener doesn't know the 'ORCL' SID.

                      Could you verify that you have the right informations for connection to your database?
                      • 8. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                        969237
                        Hi,
                        I have used XE instead of ORCL.That too is not working fine.
                        I am using Oracle Database Express Edition 10g for Database Connections.

                        Rachin Gupta
                        • 9. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                          JeromeFr
                          Do you manage to connect to this SID using sqlplus or another SQL tool ?
                          • 10. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                            Sutirtha Roy
                            try to do tnsping <SID> from any command promnt
                            • 11. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                              969237
                              Hi,
                              I am getting the error as 'Invalid Repository Connection' after clicking on Test in Repository Connection Information of ODI.The URL is jdbc:oracle:thin:@localhost:1521:XE.Driver name is Oracle.jdbc.OracleDriver.
                              The error details are:-

                              Hi,
                              I am getting this error message 'Invalid Repository Connection' after filling the Driver URL as jdbc:oracle:thin:@localhost:1521:XE in the Oracle Data Integrator.This message i get after i click on TEST in Repository Connection Information in ODI.This is the error detail:-



                              oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.     
                              Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                              ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                                   at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:100)
                                   at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
                                   at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
                                   at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
                                   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:755)
                                   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$4(SnpsDialogLoginDetail.java:743)
                                   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$2.performAction(SnpsDialogLoginDetail.java:287)
                                   at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
                                   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                                   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                                   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                                   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                                   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                                   at java.awt.Component.processMouseEvent(Component.java:6267)
                                   at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                                   at java.awt.Component.processEvent(Component.java:6032)
                                   at java.awt.Container.processEvent(Container.java:2041)
                                   at java.awt.Component.dispatchEventImpl(Component.java:4630)
                                   at java.awt.Container.dispatchEventImpl(Container.java:2099)
                                   at java.awt.Component.dispatchEvent(Component.java:4460)
                                   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                                   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                                   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                                   at java.awt.Container.dispatchEventImpl(Container.java:2085)
                                   at java.awt.Window.dispatchEventImpl(Window.java:2478)
                                   at java.awt.Component.dispatchEvent(Component.java:4460)
                                   at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                                   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                                   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                                   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
                                   at java.awt.Dialog$1.run(Dialog.java:1046)
                                   at java.awt.Dialog$3.run(Dialog.java:1098)
                                   at java.security.AccessController.doPrivileged(Native Method)
                                   at java.awt.Dialog.show(Dialog.java:1096)
                                   at java.awt.Component.show(Component.java:1563)
                                   at java.awt.Component.setVisible(Component.java:1515)
                                   at java.awt.Window.setVisible(Window.java:842)
                                   at java.awt.Dialog.setVisible(Dialog.java:986)
                                   at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
                                   at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
                                   at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
                                   at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
                                   at oracle.odi.ui.LoginFactory.modifyLogin(LoginFactory.java:334)
                                   at com.sunopsis.graphical.dialog.SnpsDialogLogin$3.performAction(SnpsDialogLogin.java:185)
                                   at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
                                   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                                   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                                   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                                   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                                   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                                   at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                                   at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                                   at java.awt.Component.processMouseEvent(Component.java:6267)
                                   at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                                   at java.awt.Component.processEvent(Component.java:6032)
                                   at java.awt.Container.processEvent(Container.java:2041)
                                   at java.awt.Component.dispatchEventImpl(Component.java:4630)
                                   at java.awt.Container.dispatchEventImpl(Container.java:2099)
                                   at java.awt.Component.dispatchEvent(Component.java:4460)
                                   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                                   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                                   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                                   at java.awt.Container.dispatchEventImpl(Container.java:2085)
                                   at java.awt.Window.dispatchEventImpl(Window.java:2478)
                                   at java.awt.Component.dispatchEvent(Component.java:4460)
                                   at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                                   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                                   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                                   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
                                   at java.awt.Dialog$1.run(Dialog.java:1046)
                                   at java.awt.Dialog$3.run(Dialog.java:1098)
                                   at java.security.AccessController.doPrivileged(Native Method)
                                   at java.awt.Dialog.show(Dialog.java:1096)
                                   at java.awt.Component.show(Component.java:1563)
                                   at java.awt.Component.setVisible(Component.java:1515)
                                   at java.awt.Window.setVisible(Window.java:842)
                                   at java.awt.Dialog.setVisible(Dialog.java:986)
                                   at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
                                   at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
                                   at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
                                   at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
                                   at oracle.odi.ui.OdiConnectController.handleEvent(OdiConnectController.java:113)
                                   at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)
                                   at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:897)
                                   at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:501)
                                   at oracle.odi.ui.docking.AbstractOdiDockableWindow$1.actionPerformed(AbstractOdiDockableWindow.java:203)
                                   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                                   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                                   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                                   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                                   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                                   at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
                                   at java.awt.Component.processMouseEvent(Component.java:6267)
                                   at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                                   at java.awt.Component.processEvent(Component.java:6032)
                                   at java.awt.Container.processEvent(Container.java:2041)
                                   at java.awt.Component.dispatchEventImpl(Component.java:4630)
                                   at java.awt.Container.dispatchEventImpl(Container.java:2099)
                                   at java.awt.Component.dispatchEvent(Component.java:4460)
                                   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                                   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                                   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                                   at java.awt.Container.dispatchEventImpl(Container.java:2085)
                                   at java.awt.Window.dispatchEventImpl(Window.java:2478)
                                   at java.awt.Component.dispatchEvent(Component.java:4460)
                                   at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
                                   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                                   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                                   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
                                   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
                                   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
                                   at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
                              Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                              ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                                   at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
                                   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
                                   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
                                   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
                                   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
                                   at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
                                   at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
                                   at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
                                   at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
                                   at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:376)
                                   at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78)
                                   ... 111 more
                              Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                              ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                                   at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
                                   at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
                                   at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
                                   at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
                                   ... 121 more
                              Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                              ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                                   at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
                                   at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
                                   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:943)
                                   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873)
                                   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
                                   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 oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$DataSourceInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:48)
                                   at $Proxy0.getConnection(Unknown Source)
                                   at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
                                   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
                                   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
                                   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
                                   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
                                   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
                                   at java.lang.Thread.run(Thread.java:619)
                              Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
                              ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

                                   at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)
                                   at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)
                                   at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)
                                   at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:122)
                                   at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1610)
                                   at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1446)
                                   at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:514)
                                   at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.createOnePooledConnection(OracleJDBCConnectionPool.java:129)
                                   at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:297)
                                   at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:142)
                                   at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:157)
                                   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:931)
                                   ... 15 more
                              • 12. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                                JeromeFr
                                The SID you provide is not good, the listinner cannot reach it.
                                • 13. Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                                  969237
                                  Hi,
                                  I am using XE because i have Oracle Express Edition.I have used ORCL also as SID but still it is giving the same error.
                                  In Express edition,i have created two repositories:-Master and Work Repository.

                                  Rachin Gupta
                                  • 14. Re: Error Message as 'Master Repo URL is not compatible with the JDBC Driver'
                                    JeromeFr
                                    Ok but are your sure that your listener know your XE SID ?

                                    What is the content of your TNSNAMES.ora ?
                                    C:\oracle\product\your_version\client\NETWORK\ADMIN\tnsnames.ora


                                    Could you try to run this in a command line ?
                                    tnsping XE
                                    tnsping ORCL
                                    What does this return ?
                                    1 2 Previous Next