Error: "Could not initialize the JDBCRegistry" appears when staring mashup
server
---------------------------------------------------------------------------------
Key: MASHUP-699
URL: https://wso2.org/jira/browse/MASHUP-699
Project: WSO2 Mashup Server
Issue Type: Bug
Components: Core
Affects Versions: 1.0
Environment: WinXP, JDK1.5
Mashup svn revision: 14192
Registry svn revision: 14192
Reporter: Yumani Ranaweera
Assignee: Chathura Ekanayake
Priority: Blocker
Fix For: 1.1
Steps to recreate
--------------------
1. Build Registry and Mashup server after the registry's merge with UM.
2. Start Mashup server.
Issue:
-------
Server cannot be started. Its giving the exception stated below at the startup.
INFO [2008-02-26 10:59:25,765] Scheduler
DefaultQuartzScheduler_$_NON_CLUSTERED started.
ERROR [2008-02-26 10:59:28,156] Could not initialize the JDBCRegistry.
ERROR 42X04: Column 'D.DTYPE' is either not in any table in the FROM list or
appears within a join specification and is outside the scope of the join
specification or appears in a HAVING clause and is not in the GROUP BY list. If
this is a CREATE or ALTER TABLE statement then 'D.DTYPE' is not a col
umn in the target table.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown
Source)
at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
at
org.wso2.registry.jdbc.dao.VersionedResourceDAO.getDependencies(VersionedResourceDAO.java:203)
at
org.wso2.registry.jdbc.dao.VersionedResourceDAO.getLatestVersion(VersionedResourceDAO.java:340)
at org.wso2.registry.jdbc.JDBCRegistry.init(JDBCRegistry.java:149)
at org.wso2.registry.jdbc.JDBCRegistry.<init>(JDBCRegistry.java:100)
at org.wso2.mashup.deployer.JSDeployer.initRegistry(JSDeployer.java:761)
at org.wso2.mashup.deployer.JSDeployer.init(JSDeployer.java:116)
at
org.apache.axis2.deployment.DeploymentEngine.initializeDeployers(DeploymentEngine.java:915)
at
org.apache.axis2.deployment.DeploymentEngine.setConfigContext(DeploymentEngine.java:906)
at
org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:72)
at
org.wso2.utils.WSO2ConfigurationContextFactory.createNewConfigurationContext(WSO2ConfigurationContextFactory.java:60)
at org.wso2.wsas.ServerManager.start(ServerManager.java:107)
at org.wso2.wsas.MainServlet.start(MainServlet.java:249)
at org.wso2.mashup.transport.MainServlet.start(MainServlet.java:38)
at org.wso2.wsas.MainServlet.init(MainServlet.java:185)
at org.wso2.mashup.transport.MainServlet.init(MainServlet.java:53)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3915)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4176)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.wso2.wsas.TomcatRepositoryListener.run(TomcatRepositoryListener.java:107)
at java.lang.Thread.run(Thread.java:595)
org.wso2.registry.RegistryException: Could not initialize the JDBCRegistry.
at org.wso2.registry.jdbc.JDBCRegistry.init(JDBCRegistry.java:166)
at org.wso2.registry.jdbc.JDBCRegistry.<init>(JDBCRegistry.java:100)
at org.wso2.mashup.deployer.JSDeployer.initRegistry(JSDeployer.java:761)
at org.wso2.mashup.deployer.JSDeployer.init(JSDeployer.java:116)
at
org.apache.axis2.deployment.DeploymentEngine.initializeDeployers(DeploymentEngine.java:915)
at
org.apache.axis2.deployment.DeploymentEngine.setConfigContext(DeploymentEngine.java:906)
at
org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:72)
at
org.wso2.utils.WSO2ConfigurationContextFactory.createNewConfigurationContext(WSO2ConfigurationContextFactory.java:60)
at org.wso2.wsas.ServerManager.start(ServerManager.java:107)
at org.wso2.wsas.MainServlet.start(MainServlet.java:249)
at org.wso2.mashup.transport.MainServlet.start(MainServlet.java:38)
at org.wso2.wsas.MainServlet.init(MainServlet.java:185)
at org.wso2.mashup.transport.MainServlet.init(MainServlet.java:53)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3915)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4176)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.wso2.wsas.TomcatRepositoryListener.run(TomcatRepositoryListener.java:107)
at java.lang.Thread.run(Thread.java:595)
Caused by: SQL Exception: Column 'D.DTYPE' is either not in any table in the
FROM list or appears within a join specification and is outside the scope
of the join specification or appears in a HAVING clause and is not in the
GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'D.DTYPE'
is not a column in the target table.
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
at
org.wso2.registry.jdbc.dao.VersionedResourceDAO.getDependencies(VersionedResourceDAO.java:203)
at
org.wso2.registry.jdbc.dao.VersionedResourceDAO.getLatestVersion(VersionedResourceDAO.java:340)
at org.wso2.registry.jdbc.JDBCRegistry.init(JDBCRegistry.java:149)
... 21 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev
