[JBoss JIRA] Created: (TEIID-929) Virtual Procedure - IllegalArgumentException: Expected argument to be an instance of org.teiid.connector.metadata.runtime.Table; was instance of org.teiid.connector.metadata.runtime.ProcedureRecordImpl
by Warren Gibson (JIRA)
Virtual Procedure - IllegalArgumentException: Expected argument to be an instance of org.teiid.connector.metadata.runtime.Table; was instance of org.teiid.connector.metadata.runtime.ProcedureRecordImpl
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIID-929
URL: https://jira.jboss.org/jira/browse/TEIID-929
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.0
Reporter: Warren Gibson
Assignee: Steven Hawkins
They following virtual procedure is failing with an IllegalArumentException. Does "Expected argument to be an instance of org.teiid.connector.metadata.runtime.Table; was instance of org.teiid.connector.metadata.runtime.ProcedureRecordImpl" mean anything to you? This query does run in Designer.
SELECT DNT FROM VirtProcs.vDate_n_Time WHERE intkey_in = 2"
2010-01-12 12:49:12,387 ERROR [Worker7_QueryProcessorQueue0] org.teiid.DQP - Unexpected exception for request 0.0
java.lang.IllegalArgumentException: Expected argument to be an instance of org.teiid.connector.metadata.runtime.Table; was instance of org.teiid.connector.metadata.runtime.ProcedureRecordImpl
at com.metamatrix.core.util.ArgCheck.isInstanceOf(ArgCheck.java:353)
at com.metamatrix.core.util.ArgCheck.isInstanceOf(ArgCheck.java:337)
at org.teiid.metadata.TransformationMetadata.isXMLGroup(TransformationMetadata.java:701)
at com.metamatrix.query.metadata.TempMetadataAdapter.isXMLGroup(TempMetadataAdapter.java:429)
at com.metamatrix.query.metadata.TempMetadataAdapter.isXMLGroup(TempMetadataAdapter.java:429)
at com.metamatrix.query.metadata.TempMetadataAdapter.isXMLGroup(TempMetadataAdapter.java:429)
at com.metamatrix.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:297)
at com.metamatrix.query.sql.lang.UnaryFromClause.acceptVisitor(UnaryFromClause.java:82)
at com.metamatrix.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61)
at com.metamatrix.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
at com.metamatrix.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:246)
at com.metamatrix.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:431)
at com.metamatrix.query.sql.lang.From.acceptVisitor(From.java:143)
at com.metamatrix.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61)
at com.metamatrix.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:177)
at com.metamatrix.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:94)
at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:176)
at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:128)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:905)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:635)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:553)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:516)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:393)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:144)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:109)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:470)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:556)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:336)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:176)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211)
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] Created: (TEIID-753) MySQL translator issues
by Steven Hawkins (JIRA)
MySQL translator issues
-----------------------
Key: TEIID-753
URL: https://jira.jboss.org/jira/browse/TEIID-753
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 6.2.0
MySQL does not change the autocommit flag to false when running in a global transaction, however the current autocommit detection logic does not take whether we're in an xa transaction into account.
Also the timestamp literal format TIMESTAMP(...) actually produces a null value. This should be changed to either the jdbc escape syntax or simply the string literal form.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] Resolved: (TEIID-1200) Non-parsable SQL in transformation provides no help to user - NPE in stack trace
by Steve Hawkins (JIRA)
[ https://jira.jboss.org/browse/TEIID-1200?page=com.atlassian.jira.plugin.s... ]
Steve Hawkins resolved TEIID-1200.
----------------------------------
Fix Version/s: 7.1
Resolution: Done
Updated the null check to be on the user command, rather than the symbol map.
> Non-parsable SQL in transformation provides no help to user - NPE in stack trace
> --------------------------------------------------------------------------------
>
> Key: TEIID-1200
> URL: https://jira.jboss.org/browse/TEIID-1200
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.0
> Environment: Fedora 12, OpenJDK, Designer 6/28
> Reporter: Paul Nittel
> Assignee: Steve Hawkins
> Fix For: 7.1
>
> Attachments: E2eUpdateVirtualGroupsTestScript.odt, UpdatesProject.zip
>
>
> Neither the error nor the stack trace provides the user with any assistance in correcting their SQL error. (BTW, in MMx 554, this parsed.)
> While attempting the Update Virtual Groups modeling, I ran into this problem defining the Update procedure for UpdateProduct. After pasting in the SQL text, I validated the SQL and received:
> The query is not parsable.
> Error encountered while validating the transformation.
> The message log shows:
> Error 2010-06-30 11:32:04.784 Error encountered while validating the transformation.
> Please check the Message log for exceptions
> java.lang.NullPointerException
> at org.teiid.query.validator.ValidationVisitor.validateTranslateCriteria(ValidationVisitor.java:536)
> at org.teiid.query.validator.ValidationVisitor.visit(ValidationVisitor.java:479)
> at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:53)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:125)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:461)
> at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:475)
> at org.teiid.query.sql.lang.Update.acceptVisitor(Update.java:157)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:158)
> at org.teiid.query.sql.proc.AssignmentStatement.acceptVisitor(AssignmentStatement.java:133)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
> at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:289)
> at org.teiid.query.sql.proc.IfStatement.acceptVisitor(IfStatement.java:147)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
> at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:218)
> at org.teiid.query.sql.proc.CreateUpdateProcedureCommand.acceptVisitor(CreateUpdateProcedureCommand.java:144)
> at org.teiid.query.validator.Validator.executeValidation(Validator.java:93)
> at org.teiid.query.validator.Validator.validate(Validator.java:55)
> at org.teiid.query.validator.Validator.validate(Validator.java:41)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateCommand(TransformationValidator.java:389)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateSql(TransformationValidator.java:297)
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.validateSql(QueryDisplayComponent.java:263)
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.setText(QueryDisplayComponent.java:178)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:421)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel$4.run(SqlEditorPanel.java:464)
> at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
> at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:470)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:495)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.validate(SqlEditorPanel.java:526)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanelWrapper.validate(SqlEditorPanelWrapper.java:138)
> at com.metamatrix.query.internal.ui.sqleditor.actions.Validate.doRun(Validate.java:52)
> at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1176)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3493)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3112)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] Assigned: (TEIID-1200) Non-parsable SQL in transformation provides no help to user - NPE in stack trace
by Steve Hawkins (JIRA)
[ https://jira.jboss.org/browse/TEIID-1200?page=com.atlassian.jira.plugin.s... ]
Steve Hawkins reassigned TEIID-1200:
------------------------------------
Assignee: Steve Hawkins
> Non-parsable SQL in transformation provides no help to user - NPE in stack trace
> --------------------------------------------------------------------------------
>
> Key: TEIID-1200
> URL: https://jira.jboss.org/browse/TEIID-1200
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.0
> Environment: Fedora 12, OpenJDK, Designer 6/28
> Reporter: Paul Nittel
> Assignee: Steve Hawkins
> Attachments: E2eUpdateVirtualGroupsTestScript.odt, UpdatesProject.zip
>
>
> Neither the error nor the stack trace provides the user with any assistance in correcting their SQL error. (BTW, in MMx 554, this parsed.)
> While attempting the Update Virtual Groups modeling, I ran into this problem defining the Update procedure for UpdateProduct. After pasting in the SQL text, I validated the SQL and received:
> The query is not parsable.
> Error encountered while validating the transformation.
> The message log shows:
> Error 2010-06-30 11:32:04.784 Error encountered while validating the transformation.
> Please check the Message log for exceptions
> java.lang.NullPointerException
> at org.teiid.query.validator.ValidationVisitor.validateTranslateCriteria(ValidationVisitor.java:536)
> at org.teiid.query.validator.ValidationVisitor.visit(ValidationVisitor.java:479)
> at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:53)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:125)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:461)
> at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:475)
> at org.teiid.query.sql.lang.Update.acceptVisitor(Update.java:157)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:158)
> at org.teiid.query.sql.proc.AssignmentStatement.acceptVisitor(AssignmentStatement.java:133)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
> at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:289)
> at org.teiid.query.sql.proc.IfStatement.acceptVisitor(IfStatement.java:147)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
> at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:218)
> at org.teiid.query.sql.proc.CreateUpdateProcedureCommand.acceptVisitor(CreateUpdateProcedureCommand.java:144)
> at org.teiid.query.validator.Validator.executeValidation(Validator.java:93)
> at org.teiid.query.validator.Validator.validate(Validator.java:55)
> at org.teiid.query.validator.Validator.validate(Validator.java:41)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateCommand(TransformationValidator.java:389)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateSql(TransformationValidator.java:297)
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.validateSql(QueryDisplayComponent.java:263)
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.setText(QueryDisplayComponent.java:178)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:421)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel$4.run(SqlEditorPanel.java:464)
> at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
> at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:470)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:495)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.validate(SqlEditorPanel.java:526)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanelWrapper.validate(SqlEditorPanelWrapper.java:138)
> at com.metamatrix.query.internal.ui.sqleditor.actions.Validate.doRun(Validate.java:52)
> at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1176)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3493)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3112)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] Moved: (TEIID-1200) Non-parsable SQL in transformation provides no help to user - NPE in stack trace
by Steve Hawkins (JIRA)
[ https://jira.jboss.org/browse/TEIID-1200?page=com.atlassian.jira.plugin.s... ]
Steve Hawkins moved TEIIDDES-489 to TEIID-1200:
-----------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-1200 (was: TEIIDDES-489)
Affects Version/s: 7.0
(was: 7.0)
Component/s: Query Engine
(was: Transformations)
> Non-parsable SQL in transformation provides no help to user - NPE in stack trace
> --------------------------------------------------------------------------------
>
> Key: TEIID-1200
> URL: https://jira.jboss.org/browse/TEIID-1200
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.0
> Environment: Fedora 12, OpenJDK, Designer 6/28
> Reporter: Paul Nittel
> Attachments: E2eUpdateVirtualGroupsTestScript.odt, UpdatesProject.zip
>
>
> Neither the error nor the stack trace provides the user with any assistance in correcting their SQL error. (BTW, in MMx 554, this parsed.)
> While attempting the Update Virtual Groups modeling, I ran into this problem defining the Update procedure for UpdateProduct. After pasting in the SQL text, I validated the SQL and received:
> The query is not parsable.
> Error encountered while validating the transformation.
> The message log shows:
> Error 2010-06-30 11:32:04.784 Error encountered while validating the transformation.
> Please check the Message log for exceptions
> java.lang.NullPointerException
> at org.teiid.query.validator.ValidationVisitor.validateTranslateCriteria(ValidationVisitor.java:536)
> at org.teiid.query.validator.ValidationVisitor.visit(ValidationVisitor.java:479)
> at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:53)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:125)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:461)
> at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:475)
> at org.teiid.query.sql.lang.Update.acceptVisitor(Update.java:157)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:158)
> at org.teiid.query.sql.proc.AssignmentStatement.acceptVisitor(AssignmentStatement.java:133)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
> at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:289)
> at org.teiid.query.sql.proc.IfStatement.acceptVisitor(IfStatement.java:147)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
> at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
> at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:218)
> at org.teiid.query.sql.proc.CreateUpdateProcedureCommand.acceptVisitor(CreateUpdateProcedureCommand.java:144)
> at org.teiid.query.validator.Validator.executeValidation(Validator.java:93)
> at org.teiid.query.validator.Validator.validate(Validator.java:55)
> at org.teiid.query.validator.Validator.validate(Validator.java:41)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateCommand(TransformationValidator.java:389)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateSql(TransformationValidator.java:297)
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.validateSql(QueryDisplayComponent.java:263)
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.setText(QueryDisplayComponent.java:178)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:421)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel$4.run(SqlEditorPanel.java:464)
> at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
> at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:470)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:495)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.validate(SqlEditorPanel.java:526)
> at com.metamatrix.query.ui.sqleditor.SqlEditorPanelWrapper.validate(SqlEditorPanelWrapper.java:138)
> at com.metamatrix.query.internal.ui.sqleditor.actions.Validate.doRun(Validate.java:52)
> at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1176)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3493)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3112)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] Updated: (TEIID-1192) JDBC driver doesn't accept underscores _ in server names
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-1192?page=com.atlassian.jira.plugin.s... ]
Ramesh Reddy updated TEIID-1192:
--------------------------------
Summary: JDBC driver doesn't accept underscores _ in server names (was: metamatrix jdbc driver doesn't accept underscores _ in server names)
Description:
DBC driver does not support underscored in the server name. So
jdbc:metamatrix:FederatedSearch_VDB@mm://127.0.0.1:31000;version=2 will work but its names counterpart
jdbc:metamatrix:FederatedSearch_VDB@mm://sup_mm:31000;version=2 does not will not.
was:
MetaMatrix JDBC driver does not support underscored in the server name. So
jdbc:metamatrix:AFP_FederatedSearch_VDB@mm://10.195.209.138:31000;version=2 will work but its names counterpart
jdbc:metamatrix:AFP_FederatedSearch_VDB@mm://sup_mm:31000;version=2 does not will not.
> JDBC driver doesn't accept underscores _ in server names
> --------------------------------------------------------
>
> Key: TEIID-1192
> URL: https://jira.jboss.org/browse/TEIID-1192
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 7.0
> Reporter: Debbie Steigner
> Priority: Minor
>
> DBC driver does not support underscored in the server name. So
> jdbc:metamatrix:FederatedSearch_VDB@mm://127.0.0.1:31000;version=2 will work but its names counterpart
> jdbc:metamatrix:FederatedSearch_VDB@mm://sup_mm:31000;version=2 does not will not.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months