[JBoss JIRA] (TEIIDDES-2888) Default value is not correctly parsed
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2888?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2888:
-----------------------------------
Fix Version/s: 11.2
(was: 11.0.2)
> Default value is not correctly parsed
> --------------------------------------
>
> Key: TEIIDDES-2888
> URL: https://issues.jboss.org/browse/TEIIDDES-2888
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Dynamic VDBs
> Affects Versions: 10.0.1
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 11.2
>
> Attachments: ProductProject.zip, screenshot1.png, screenshot2.png
>
>
> When I want preview data from my table (productdata in the project which is in the attachment), server shows me this error:
> TEIID31100 Parsing error: Encountered ") DEFAULT '('[*]Stock[*]')' OPTIONS"
> In one column I have default value ('Stock') (screenshot1)
> I am not sure whether it is the correct form of default value or not but in the old version of teiid designer preview this table works fine. I think that ddl parser is not able to parse this. (screenshot2)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
6 years, 9 months
[JBoss JIRA] (TEIIDDES-2755) No Quick fix offered after importing VDB with same models
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2755?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2755:
-----------------------------------
Fix Version/s: 11.2
> No Quick fix offered after importing VDB with same models
> ---------------------------------------------------------
>
> Key: TEIIDDES-2755
> URL: https://issues.jboss.org/browse/TEIIDDES-2755
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 11.2
>
> Attachments: QT_Greenplum_Push.vdb, QT_MySql50_Push.vdb, Screen Shot 2016-01-12 at 9.57.25 (2).png, Screen Shot 2016-01-12 at 9.57.48 (2).png, Screen Shot 2016-01-12 at 9.58.00 (2).png
>
>
> I have 2 VDBs with models that have same names. After importing the first one and extracting the models, TD doesn't offer this option for the second VDB in second project.
> I can see that the warning says that models are not in +workspace+, but I think TD should check if models are in the +project folder+ not in workspace.
> In the screenshots, you can see that there is no warning for NewProject2.
> VDBs attached.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
6 years, 9 months
[JBoss JIRA] (TEIIDDES-2755) No Quick fix offered after importing VDB with same models
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2755?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2755:
-----------------------------------
Fix Version/s: (was: 11.0.2)
> No Quick fix offered after importing VDB with same models
> ---------------------------------------------------------
>
> Key: TEIIDDES-2755
> URL: https://issues.jboss.org/browse/TEIIDDES-2755
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 11.2
>
> Attachments: QT_Greenplum_Push.vdb, QT_MySql50_Push.vdb, Screen Shot 2016-01-12 at 9.57.25 (2).png, Screen Shot 2016-01-12 at 9.57.48 (2).png, Screen Shot 2016-01-12 at 9.58.00 (2).png
>
>
> I have 2 VDBs with models that have same names. After importing the first one and extracting the models, TD doesn't offer this option for the second VDB in second project.
> I can see that the warning says that models are not in +workspace+, but I think TD should check if models are in the +project folder+ not in workspace.
> In the screenshots, you can see that there is no warning for NewProject2.
> VDBs attached.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
6 years, 9 months
[JBoss JIRA] (TEIIDDES-3069) odata4 fails to return data on top of mongoDB view model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3069?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3069:
-----------------------------------
Fix Version/s: 11.2
(was: 11.0.2)
> odata4 fails to return data on top of mongoDB view model
> ---------------------------------------------------------
>
> Key: TEIIDDES-3069
> URL: https://issues.jboss.org/browse/TEIIDDES-3069
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Environment: Noticed in JDV 6.3.4
> Reporter: Michael Echevarria
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 11.2
>
> Attachments: Screenshot from 2017-03-28 15-38-25.png, Screenshot from 2017-03-28 15-38-32.png, Screenshot from 2017-03-28 15-38-46.png, Screenshot from 2017-03-28 15-38-56.png, designer-length-added.png, mongo-view-error.png, odata2-works.png, odata4-error.png, odata4-with-length-changed.png
>
>
> Description of problem:
> Accessing either an exclusive view model or combined view model for a mongoDB datasource via odata4 results in an error.
> The data returns via odata2, jdbc and preview in the designer
> Version-Release number of selected component (if applicable):
> JDV 6.3.4
> Actual results:
> Property mapping error
> Expected results:
> Model data
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
6 years, 10 months
[JBoss JIRA] (TEIIDDES-2686) Source Model created via Teiid Connection Import from SalesForce source doesn't work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2686?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2686:
-----------------------------------
Fix Version/s: 11.2
(was: 11.0.2)
> Source Model created via Teiid Connection Import from SalesForce source doesn't work
> ------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2686
> URL: https://issues.jboss.org/browse/TEIIDDES-2686
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Environment: MAC OS
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 11.2
>
>
> When I am trying to import from SalesForce using Teiid Connection Import, resulting model doesn't work properly. Querying VDB that includes this model results in:
> {noformat}
> java.sql.SQLException: org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: null
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:729)
> at org.teiid.jdbc.StatementImpl.access$2(StatementImpl.java:715)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:566)
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:134)
> at org.teiid.client.util.ResultsFuture.access$3(ResultsFuture.java:130)
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:78)
> at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:263)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:301)
> at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:109)
> at com.sun.proxy.$Proxy52.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:400)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:575)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:444)
> at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:378)
> at org.eclipse.datatools.connectivity.sqm.internal.core.connection.StatementAdapter.executeQuery(StatementAdapter.java:73)
> at org.eclipse.datatools.sqltools.data.internal.core.editor.TableDataImpl.<init>(TableDataImpl.java:158)
> at org.eclipse.datatools.sqltools.data.internal.ui.editor.TableDataEditor.createPartControl(TableDataEditor.java:110)
> at org.eclipse.ui.internal.e4.compatibility.CompatibilityPart.createPartControl(CompatibilityPart.java:141)
> at org.eclipse.ui.internal.e4.compatibility.CompatibilityEditor.createPartControl(CompatibilityEditor.java:99)
> at org.eclipse.ui.internal.e4.compatibility.CompatibilityPart.create(CompatibilityPart.java:327)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)
> at org.eclipse.e4.core.internal.di.InjectorImpl.processAnnotated(InjectorImpl.java:888)
> at org.eclipse.e4.core.internal.di.InjectorImpl.processAnnotated(InjectorImpl.java:869)
> at org.eclipse.e4.core.internal.di.InjectorImpl.inject(InjectorImpl.java:120)
> at org.eclipse.e4.core.internal.di.InjectorImpl.internalMake(InjectorImpl.java:337)
> at org.eclipse.e4.core.internal.di.InjectorImpl.make(InjectorImpl.java:258)
> at org.eclipse.e4.core.contexts.ContextInjectionFactory.make(ContextInjectionFactory.java:162)
> at org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.createFromBundle(ReflectionContributionFactory.java:104)
> at org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.doCreate(ReflectionContributionFactory.java:73)
> at org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.create(ReflectionContributionFactory.java:55)
> at org.eclipse.e4.ui.workbench.renderers.swt.ContributedPartRenderer.createWidget(ContributedPartRenderer.java:127)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createWidget(PartRenderingEngine.java:983)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:662)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:766)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$2(PartRenderingEngine.java:737)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$7.run(PartRenderingEngine.java:731)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:715)
> at org.eclipse.e4.ui.internal.workbench.PartServiceImpl$1.handleEvent(PartServiceImpl.java:95)
> at org.eclipse.e4.ui.services.internal.events.UIEventHandler$1.run(UIEventHandler.java:40)
> at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:187)
> at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:156)
> at org.eclipse.swt.widgets.Display.syncExec(Display.java:4732)
> at org.eclipse.e4.ui.internal.workbench.swt.E4Application$1.syncExec(E4Application.java:218)
> at org.eclipse.e4.ui.services.internal.events.UIEventHandler.handleEvent(UIEventHandler.java:36)
> at org.eclipse.equinox.internal.event.EventHandlerWrapper.handleEvent(EventHandlerWrapper.java:197)
> at org.eclipse.equinox.internal.event.EventHandlerTracker.dispatchEvent(EventHandlerTracker.java:197)
> at org.eclipse.equinox.internal.event.EventHandlerTracker.dispatchEvent(EventHandlerTracker.java:1)
> at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
> at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
> at org.eclipse.equinox.internal.event.EventAdminImpl.dispatchEvent(EventAdminImpl.java:135)
> at org.eclipse.equinox.internal.event.EventAdminImpl.sendEvent(EventAdminImpl.java:78)
> at org.eclipse.equinox.internal.event.EventComponent.sendEvent(EventComponent.java:39)
> at org.eclipse.e4.ui.services.internal.events.EventBroker.send(EventBroker.java:81)
> at org.eclipse.e4.ui.internal.workbench.UIEventPublisher.notifyChanged(UIEventPublisher.java:59)
> at org.eclipse.emf.common.notify.impl.BasicNotifierImpl.eNotify(BasicNotifierImpl.java:374)
> at org.eclipse.e4.ui.model.application.ui.impl.ElementContainerImpl.setSelectedElement(ElementContainerImpl.java:171)
> at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.showElementInWindow(ModelServiceImpl.java:488)
> at org.eclipse.e4.ui.internal.workbench.ModelServiceImpl.bringToTop(ModelServiceImpl.java:454)
> at org.eclipse.e4.ui.internal.workbench.PartServiceImpl.delegateBringToTop(PartServiceImpl.java:705)
> at org.eclipse.e4.ui.internal.workbench.PartServiceImpl.bringToTop(PartServiceImpl.java:392)
> at org.eclipse.e4.ui.internal.workbench.PartServiceImpl.showPart(PartServiceImpl.java:1145)
> at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:3210)
> at org.eclipse.ui.internal.WorkbenchPage.access$23(WorkbenchPage.java:3125)
> at org.eclipse.ui.internal.WorkbenchPage$9.run(WorkbenchPage.java:3107)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:3102)
> at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:3066)
> at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:3047)
> at org.eclipse.datatools.sqltools.data.internal.ui.editor.EditTableDataAction.run(EditTableDataAction.java:63)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:519)
> 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:4199)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1467)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1490)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1475)
> at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1279)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4042)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3669)
> 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.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:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> 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)
> Caused by: org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: null
> at org.teiid.client.ResultsMessage.readExternal(ResultsMessage.java:278)
> at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1842)
> at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1799)
> at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)
> at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)
> at org.teiid.net.socket.Message.readExternal(Message.java:54)
> at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1842)
> at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1799)
> at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)
> at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)
> at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:118)
> at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:113)
> ... 103 more
> Caused by: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: null
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:194)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:999)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException: Remote java.lang.NullPointerException: null
> at org.teiid.translator.salesforce.execution.visitors.CriteriaVisitor.loadColumnMetadata(CriteriaVisitor.java:380)
> at org.teiid.translator.salesforce.execution.visitors.SelectVisitor.visit(SelectVisitor.java:137)
> at org.teiid.language.NamedTable.acceptVisitor(NamedTable.java:66)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNodes(AbstractLanguageVisitor.java:63)
> at org.teiid.translator.salesforce.execution.visitors.SelectVisitor.visit(SelectVisitor.java:55)
> at org.teiid.language.Select.acceptVisitor(Select.java:103)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:151)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:329)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
> ... 6 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
6 years, 10 months
[JBoss JIRA] (TEIIDDES-1980) Need support to create XA datasource
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1980?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1980:
----------------------------------------
The simple answer is to create a connection profile with a driver definition with the appropriate driver class (i.e. .... XAOracleDriver ) These basic JDBC properties get passed to Teiid when creating a Data Source and end up in the standalone.xml
There are different configuration properties that you can add for pooling and other features, but the connection profile only provides a generic "add/remove" key value properties option would work on that side.
But our data source feature is not yet aware of an *XA* data source and how and what to look for on creation.
The Teiid docs in the kit contain examples of XA -ds.xml files here are the oracle examples:
*Standard*
{code:xml}
<!-- Add the below contents under "datasources" subsystem in the standalone-teiid.xml or deploy as -ds.xml file -->
<datasources>
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:oracle:thin:{host}:1521:orcl</connection-url>
<driver>ojdbc6.jar</driver>
<pool>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>{user}</user-name>
<password>{password}</password>
</security>
</datasource>
</datasources>
{code}
*XA source*
{code:xml}
<!-- Add the below contents under "datasources" subsystem in the standalone-teiid.xml or deploy as -ds.xml file -->
<datasources>
<xa-datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true" use-ccm="true">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:{host}:1521:orcl</xa-datasource-property>
<driver>ojdbc6.jar</driver>
<!--
<new-connection-sql>select * from dual</new-connection-sql>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
-->
<xa-pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>20</max-pool-size>
<is-same-rm-override>true</is-same-rm-override>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
<no-tx-separate-pools/>
</xa-pool>
<security>
<user-name>{user}</user-name>
<password>{password}</password>
<!--
<security-domain>mysecurity-realm</security-domain>
-->
</security>
<!--
<validation>
<check-valid-connection-sql>select * from dual</check-valid-connection-sql>
</validation>
-->
</xa-datasource>
</datasources>
{code}
> Need support to create XA datasource
> ------------------------------------
>
> Key: TEIIDDES-1980
> URL: https://issues.jboss.org/browse/TEIIDDES-1980
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Modeling
> Affects Versions: 7.7, 11.0.1
> Reporter: Hisanobu Okuda
> Assignee: Barry LaFond
> Fix For: 11.2
>
>
> You can create non-XA (local-tx) datasource by right-clicking source model and select "Modeling>Create Data Source" in Teiid Designer. It needs to support to create XA data sources.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
6 years, 10 months