Hi,
Mashup-699 is blocking Mashup server testing. Is it possible to fix it ASAP.
JIRA DESCRIPTION IS AS BELOW
-----------------------------------------
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
Thanks,
Yumani
_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev
