2.01 error with Oracle

Your connection settings are okay.. Otherwise you will not be able to create the schemas using -Dsetup option. But the error log indicate that registry couldn't find the registry DB. (we have already improved this error message for next release). Can you restart the server without -Dsetup option and try again. Please specify your RH version. Then I could check this on the specific env . Thanks, Krishantha.

Hi, our Linux version is Red Hat Enterprise Linux Server release 5.3 (Tikanga). We started again from scratch: new installation + new database made with .sql script and not with -Dsetup option. It doesn't work, you can see the result at the end of the post. Even with snapshot 380 we have the same problem. Note that the Registry works fine with Derby, MySql and MsSqlServer. Thanks, B.Laho. - - - - - - [2009-05-12 10:24:45,799] DEBUG - Creating the root collection of the Registry. {org.wso2.carbon.registry.core.jdbc.JDBCRegistry} [2009-05-12 10:24:45,849] ERROR - Failed to check the existence of the resource /. ORA-00904: "REG_PATH": invalid identifier {org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO} java.sql.SQLException: ORA-00904: "REG_PATH": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:911) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1121) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:962) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1243) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3459) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.resourceExists(ResourceDAO.java:233) at org.wso2.carbon.registry.core.jdbc.JDBCRegistry.addRootCollection(JDBCRegistry.java:767) at org.wso2.carbon.registry.core.jdbc.JDBCRegistry.init(JDBCRegistry.java:174) at org.wso2.carbon.registry.core.jdbc.JDBCRegistry.(JDBCRegistry.java:97) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.configure(EmbeddedRegistry.java:132) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.(EmbeddedRegistry.java:76) at org.wso2.carbon.registry.core.internal.Activator.getEmbbedRegistryService(Activator.java:156) at org.wso2.carbon.registry.core.internal.Activator.start(Activator.java:78) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) [2009-05-12 10:24:45,850] FATAL - Failed to add the root collection to the registry. {org.wso2.carbon.registry.core.jdbc.JDBCRegistry} org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to check the existence of the resource /. ORA-00904: "REG_PATH": invalid identifier at org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.resourceExists(ResourceDAO.java:239) at org.wso2.carbon.registry.core.jdbc.JDBCRegistry.addRootCollection(JDBCRegistry.java:767) at org.wso2.carbon.registry.core.jdbc.JDBCRegistry.init(JDBCRegistry.java:174) at org.wso2.carbon.registry.core.jdbc.JDBCRegistry.(JDBCRegistry.java:97) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.configure(EmbeddedRegistry.java:132) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.(EmbeddedRegistry.java:76) at org.wso2.carbon.registry.core.internal.Activator.getEmbbedRegistryService(Activator.java:156) at org.wso2.carbon.registry.core.internal.Activator.start(Activator.java:78) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: java.sql.SQLException: ORA-00904: "REG_PATH": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:911) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1121) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:962) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1243) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3459) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.resourceExists(ResourceDAO.java:233) ... 20 more

?

I am facing the same issue now and get the exact same error as you did, so I am wondering whether you ever have got this issue resolved and what was the solution for it? Any help is appreciate! thanks Kelly

I'm disappointed, it works with Sql Server, MySql, Derby but not with Oracle. Oracle is *the* enterprise database and there are other guys with the same problem reported in this forum; from Wso2 we have no answers. We are waiting for 3.0 stable, if it doesn't works we will switch to another Reg/Rep. Bye, B.Laho.

Hello, looks like -Dsetup option is not working for Oracle database in the Registry version I am using (2.0.1), so I clean up all the tables, triggers, sequences generated by setup option and run the sql script instead, after this, registry is working now with Oracle 10g. Hope this helpful for you. Kelly

Did you try to connect to a database that is not sitting on the same box as your app?  I had the same issue and it works locally but when you move the database to a separate box(not on localhost) and try to connect the app to it, it fails and gives the same message. So again this works with Reg 2.0.1 and 10G ------------------------------------------ <url>jdbc:oracle:thin:@localhost:1521/local db name</url> whereas this does not work -------------------------- <url>jdbc:oracle:thin:@remote server:remote port/remote db sid</url> I get the following error Jun 23, 2009 1:42:19 PM org.wso2.carbon.server.Main main INFO: Starting WSO2 Carbon... Jun 23, 2009 1:42:19 PM org.wso2.carbon.server.Main main INFO: Using Java Home        : C:\jdk1.5.0_16\jre Jun 23, 2009 1:42:19 PM org.wso2.carbon.server.Main main INFO: Using Java Version     : 1.5.0_16 Jun 23, 2009 1:42:19 PM org.wso2.carbon.server.Main main INFO: Using Carbon Home      : C:\Carbon\Registry\tomcat\WSO2RE~1.1\bin\.. Jun 23, 2009 1:42:19 PM org.apache.catalina.startup.Embedded start INFO: Starting tomcat server Jun 23, 2009 1:42:19 PM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5.23 Jun 23, 2009 1:42:20 PM org.apache.catalina.core.StandardHost start INFO: XML validation disabled Jun 23, 2009 1:42:20 PM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-9763 Jun 23, 2009 1:42:20 PM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-9763 Jun 23, 2009 1:42:20 PM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-9443 Jun 23, 2009 1:42:20 PM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-9443 [2009-06-23 13:42:27,102] ERROR -  WSO2 Registry is not available {org.wso2.carbon.core.ServerConfigurator} [2009-06-23 13:42:27,102] FATAL -  Cannot start WSO2 Registry {org.wso2.carbon.core.ServerManager} org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available         at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240)         at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170)         at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j ava:65)         at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte xtFactory.java:79)         at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130)         at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254)         at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190)         at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64)         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142)         at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50)         at org.wso2.carbon.core.internal.Activator.start(Activator.java:58)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)         at java.security.AccessController.doPrivileged(Native Method)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)         at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)         at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)         at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)         at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)         at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) org.wso2.carbon.utils.ServerException: WSO2 Registry startup failed.         at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:286)         at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190)         at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64)         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142)         at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50)         at org.wso2.carbon.core.internal.Activator.start(Activator.java:58)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)         at java.security.AccessController.doPrivileged(Native Method)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)         at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)         at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)         at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)         at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)         at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: org.wso2.carbon.utils.ServerException: Cannot start WSO2 Registry         at org.wso2.carbon.core.ServerManager.start(ServerManager.java:159)         at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254)         ... 18 more Caused by: org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available         at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240)         at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170)         at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j ava:65)         at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte xtFactory.java:79)         at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130)         ... 19 more [2009-06-23 13:42:27,149] FATAL -  Could not start WSO2 Registry {org.wso2.carbon.core.StartupServlet} org.wso2.carbon.utils.ServerException: WSO2 Registry startup failed.         at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:286)         at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190)         at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64)         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142)         at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50)         at org.wso2.carbon.core.internal.Activator.start(Activator.java:58)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)         at java.security.AccessController.doPrivileged(Native Method)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)         at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)         at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)         at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)         at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)         at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: org.wso2.carbon.utils.ServerException: Cannot start WSO2 Registry         at org.wso2.carbon.core.ServerManager.start(ServerManager.java:159)         at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254)         ... 18 more Caused by: org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available         at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240)         at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170)         at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j ava:65)         at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte xtFactory.java:79)         at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130)         ... 19 more [2009-06-23 13:42:27,212] ERROR -  Error initializing org.wso2.core.services component {org.wso2.carbon.core.services.in ternal.Activator} java.lang.NullPointerException         at org.wso2.carbon.core.services.authentication.AuthenticationAdminTrackers.init(AuthenticationAdminTrackers.jav a:26)         at org.wso2.carbon.core.services.internal.Activator.start(Activator.java:20)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)         at java.security.AccessController.doPrivileged(Native Method)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)         at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)         at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)         at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)         at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)         at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) [2009-06-23 13:42:27,243] ERROR -  Failed to start Carbon UI {org.wso2.carbon.ui.internal.Activator} java.lang.Exception: ConfigurationContext Service is not available         at org.wso2.carbon.ui.internal.Activator.start(Activator.java:108)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)         at java.security.AccessController.doPrivileged(Native Method)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)         at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)         at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)         at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)         at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)         at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)         at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)         at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)  

No, My Oracle DB instance are running in a separate machine, I have to configure my database connection like this: jdbc:oracle:thin:@oracleDBHostIP:1521:SID

thanks. I got it to work. The funny thing is that locally I had it working even with a '/' instead of ':' for the SID but I changed it to ':' and it worked.