Yumani Ranaweera wrote:
Chathura,
I built 14311 of registry 14327 of Mashups. Building process with test
set to false was successful.
But, now the Mashup server startup reports the error below. (BTW,
instead of DEPENDENCY_MANAGEMENT table the DB had a table called
DEPENDENCY)
There are two tables in the latest database schema. DEPENDENCY and
DEPENDENCY_MANAGEMENT. Missing the DEPENDENCY_MANAGEMENT table means you
are using the old script. Check with the latest script in the svn.
Thanks,
Chathura
ERROR [2008-02-29 10:19:05,796] Could not initialize the JDBCRegistry.
ERROR 42X05: Table 'DEPENDENCY_MANAGEMENT' does not exist.
at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at
org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(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:204)
at
org.wso2.registry.jdbc.dao.VersionedResourceDAO.getLatestVersion(VersionedResourceDAO.java:422)
at org.wso2.registry.jdbc.JDBCRegistry.init(JDBCRegistry.java:148)
at
org.wso2.registry.jdbc.JDBCRegistry.<init>(JDBCRegistry.java:99)
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:165)
at
org.wso2.registry.jdbc.JDBCRegistry.<init>(JDBCRegistry.java:99)
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)
Thanks,
Yumani
Chathura C. Ekanayake wrote:
Hi,
Can you get the latest check out of the registry source and build it.
I think you are using the latest database scripts with older code.
If you are using the latest check out, can you verify that the
DEPENDENCY_MANAGEMENT table is created.
Thanks,
Chathura
Yumani Ranaweera wrote:
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
