October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3685) org.teiid.padSpace does not affect to the "IN" operator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3685?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3685. --------------------------------- > org.teiid.padSpace does not affect to the "IN" operator > ------------------------------------------------------- > > Key: TEIID-3685 > URL: https://issues.jboss.org/browse/TEIID-3685 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Environment: JBoss DV 6.1.2 > Reporter: hisao furuichi > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.4 > > Attachments: datasert.csv, INTERNAL_TEST.zip > > > org.teiid.padSpace does affect to "=" operator. But does not affect to "IN" operator. > [data for a column named "id"] > {noformat} > "test1 " > {noformat} > ["=" operator] I can get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id ='TEST1'; > {noformat} > ["IN" operator] I can not get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN ('TEST1', 'TEST2'); > {noformat} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3629) Teiid DDL columns options for Salesforce column have wrong name for "Calculated" property

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3629?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3629. --------------------------------- > Teiid DDL columns options for Salesforce column have wrong name for "Calculated" property > ----------------------------------------------------------------------------------------- > > Key: TEIID-3629 > URL: https://issues.jboss.org/browse/TEIID-3629 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.8 > Reporter: Andrej Šmigala > Priority: Minor > Fix For: 8.12 > > Attachments: sfDDL.ddl > > > Back in 2014, Teiid & Teiid Designer synched our Salesforce constants/extension properties to facilitate DDL import. However, it appears that the teiid_sf:calculated constant wasn't converted properly to *teiid_sf:Calculated*. https://github.com/teiid/teiid/commit/88781c220e1afc79c889cfc5d7c1c3e5d8e... > I'm able to import the attached DDL if I change *teiid_sf:calculated* to *teiid_sf:Calculated*. > The following is logged in the error log multiple times when importing Salesforce from Teiid Connection. The imported model appears to work ok (tried previewing a couple tables). > {quote} > java.lang.Exception: The property definition "salesforce:calculated" could not be found. > at org.teiid.designer.core.extension.EmfModelObjectExtensionAssistant.setPropertyValue(EmfModelObjectExtensionAssistant.java:485) > at org.teiid.designer.ddl.importer.node.EmfModelGenerator.setPropertyValue(EmfModelGenerator.java:1203) > at org.teiid.designer.ddl.importer.node.EmfModelGenerator.processExtensionProperties(EmfModelGenerator.java:1110) > at org.teiid.designer.ddl.importer.node.EmfModelGenerator.execute(EmfModelGenerator.java:219) > at org.teiid.designer.ddl.importer.DdlImporter.save(DdlImporter.java:324) > at org.teiid.designer.teiidimporter.ui.wizard.TeiidImportManager$2.run(TeiidImportManager.java:802) > at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:466) > at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:374) > at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:527) > at org.teiid.designer.teiidimporter.ui.wizard.TeiidImportManager.saveUsingDdlDiffReport(TeiidImportManager.java:795) > at org.teiid.designer.teiidimporter.ui.wizard.TeiidImportWizard.finish(TeiidImportWizard.java:197) > at org.teiid.designer.ui.common.wizard.AbstractWizard.performFinish(AbstractWizard.java:356) > at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:853) > at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:438) > at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619) > at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4454) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1388) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1412) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1397) > at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1182) > at org.jboss.reddeer.swt.handler.WidgetHandler$4.run(WidgetHandler.java:333) > at org.jboss.reddeer.swt.util.Display$VoidResultRunnable.run(Display.java:184) > at org.jboss.reddeer.swt.util.Display$VoidResultRunnable.run(Display.java:1) > at org.jboss.reddeer.swt.util.Display$ErrorHandlingRunnable.run(Display.java:150) > at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) > at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136) > at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3774) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3412) > at org.eclipse.jface.window.Window.runEventLoop(Window.java:832) > at org.eclipse.jface.window.Window.open(Window.java:808) > at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:158) > at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:290) > at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:294) > at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90) > 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:606) > at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55) > at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:247) > at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:229) > at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132) > at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:149) > at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499) > at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508) > at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210) > at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:343) > at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:159) > at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595) > at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511) > at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:420) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4454) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1388) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1412) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1397) > at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1182) > at org.jboss.reddeer.swt.handler.MenuHandler$5.run(MenuHandler.java:116) > at org.jboss.reddeer.swt.util.Display$VoidResultRunnable.run(Display.java:184) > at org.jboss.reddeer.swt.util.Display$VoidResultRunnable.run(Display.java:1) > at org.jboss.reddeer.swt.util.Display$ErrorHandlingRunnable.run(Display.java:150) > at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) > at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136) > at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3774) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3412) > at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151) > at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) > at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032) > at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148) > at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636) > at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) > at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579) > at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150) > at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135) > at org.jboss.reddeer.eclipse.core.UITestApplication.start(UITestApplication.java:47) > at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) > at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134) > at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104) > at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380) > at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235) > 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:606) > at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648) > at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603) > at org.eclipse.equinox.launcher.Main.run(Main.java:1465) > at org.eclipse.equinox.launcher.Main.main(Main.java:1438) > {quote} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3592) XMLFOREST returns source rather than view column names

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3592?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3592. --------------------------------- > XMLFOREST returns source rather than view column names > ------------------------------------------------------ > > Key: TEIID-3592 > URL: https://issues.jboss.org/browse/TEIID-3592 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.0 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.2 > > > When querying a REST procedure built off of a virtual table, it returns the physical source column name instead of the virtual table column name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3640) Improper initialization when memory buffer size is over 2 GB.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3640?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3640. --------------------------------- > Improper initialization when memory buffer size is over 2 GB. > ------------------------------------------------------------- > > Key: TEIID-3640 > URL: https://issues.jboss.org/browse/TEIID-3640 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.12, 8.11.3, 8.7.5 > > > When the memory buffer size is over 2 GB, the initialization will not be correct as the number of segments is determined by a number that has been narrowed to an int. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1928) PSQL emulation layer has problems converting timestamp '0000

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1928?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1928: --------------------------------------- zeroDateTimeBehavior is a mysql connection property - https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configurat... So it needs to be set on your mysql source. If you are not using mysql, then you are seeing a different issue. > PSQL emulation layer has problems converting timestamp '0000 > ------------------------------------------------------------ > > Key: TEIID-1928 > URL: https://issues.jboss.org/browse/TEIID-1928 > Project: Teiid > Issue Type: Bug > Affects Versions: 7.6 > Environment: java version "1.6.0_20" > OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64) > OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) > on > Red Hat Enterprise Linux Server > Teiid 7.6 > Perl client running on either Fedora 16 or RHEL 5.7 > Using perl-DBD-Pg-2.18.0-3.fc16.x86_64 > Reporter: Graeme Gillies > Assignee: Steven Hawkins > > When we attempt to run the following query against our teiid 7.6 install we get an error about converting timestamps. Note this only seems to affect the PSQL emulation layer, jdbc layer is fine > {noformat} > EngVDBF=> select * from orgchart2s.history; > ERROR: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP. > DETAIL: org.teiid.jdbc.TeiidSQLException: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP. > EngVDBF=> > {noformat} > It looks like there is a problem converting a timestamp of '0000-00-00 00:00:00' -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1928) PSQL emulation layer has problems converting timestamp '0000

by jie tao (JIRA)

[ https://issues.jboss.org/browse/TEIID-1928?page=com.atlassian.jira.plugin... ] jie tao commented on TEIID-1928: -------------------------------- I have the same problem. Where I shall add this property as I use Teiid designer to create the source model? And: how can I add this property to an existing source model? Thx > PSQL emulation layer has problems converting timestamp '0000 > ------------------------------------------------------------ > > Key: TEIID-1928 > URL: https://issues.jboss.org/browse/TEIID-1928 > Project: Teiid > Issue Type: Bug > Affects Versions: 7.6 > Environment: java version "1.6.0_20" > OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64) > OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) > on > Red Hat Enterprise Linux Server > Teiid 7.6 > Perl client running on either Fedora 16 or RHEL 5.7 > Using perl-DBD-Pg-2.18.0-3.fc16.x86_64 > Reporter: Graeme Gillies > Assignee: Steven Hawkins > > When we attempt to run the following query against our teiid 7.6 install we get an error about converting timestamps. Note this only seems to affect the PSQL emulation layer, jdbc layer is fine > {noformat} > EngVDBF=> select * from orgchart2s.history; > ERROR: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP. > DETAIL: org.teiid.jdbc.TeiidSQLException: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP. > EngVDBF=> > {noformat} > It looks like there is a problem converting a timestamp of '0000-00-00 00:00:00' -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3615. --------------------------------- Resolution: Duplicate Issue > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > * http://localhost:8080/portfoliorest_1/rest/foo > * http://localhost:8080/portfoliorest_1/rest/getAllStocks > * http://localhost:8080/portfoliorest_1/rest/getAllStockById/{id} > * http://localhost:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3676) Remove JwtBearerGrant CXF classes

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3676?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3676: ----------------------------------- > Remove JwtBearerGrant CXF classes > --------------------------------- > > Key: TEIID-3676 > URL: https://issues.jboss.org/browse/TEIID-3676 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Minor > > When CXF version > 3.0.4 remove JwtBearerGrant related CXF classes, and use ones from CXF -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3676) Remove JwtBearerGrant CXF classes

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3676?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3676. --------------------------------- Resolution: Duplicate Issue > Remove JwtBearerGrant CXF classes > --------------------------------- > > Key: TEIID-3676 > URL: https://issues.jboss.org/browse/TEIID-3676 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Minor > > When CXF version > 3.0.4 remove JwtBearerGrant related CXF classes, and use ones from CXF -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3676) Remove JwtBearerGrant CXF classes

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3676?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3676: ----------------------------------- > Remove JwtBearerGrant CXF classes > --------------------------------- > > Key: TEIID-3676 > URL: https://issues.jboss.org/browse/TEIID-3676 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Minor > Fix For: 9.0 > > > When CXF version > 3.0.4 remove JwtBearerGrant related CXF classes, and use ones from CXF -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015