[JBoss JIRA] (TEIID-4891) Fix and cleanup JDG quickstarts
by Van Halbert (JIRA)
Van Halbert created TEIID-4891:
----------------------------------
Summary: Fix and cleanup JDG quickstarts
Key: TEIID-4891
URL: https://issues.jboss.org/browse/TEIID-4891
Project: Teiid
Issue Type: Task
Components: JDG Connector, Quick Starts
Affects Versions: 9.3, 8.12.x-6.4
Reporter: Van Halbert
Assignee: Van Halbert
Fix and clean up the JDG related quickstarts that include:
- update instructions
- update CLI scripts
- update vdb's
- update module dependencies
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4887) Domain mode configuration fails with CNF
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4887?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4887:
----------------------------------
Fix Version/s: (was: 9.1.5)
Affects Version/s: 9.2
(was: 9.1)
Looks like this only affects 9.2+
> Domain mode configuration fails with CNF
> ----------------------------------------
>
> Key: TEIID-4887
> URL: https://issues.jboss.org/browse/TEIID-4887
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 9.2
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 9.3, 9.2.3
>
>
> domain script fails to run to the finish with a exception
> {code}
> [Server:server-one] 12:15:52,763 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 62) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]): java.lang.NoClassDefFoundError: org/wildfly/clustering/jgroups/spi/service/ProtocolStackServiceName
> [Server:server-one] at org.teiid.jboss.TeiidAdd.initilaizeTeiidEngine(TeiidAdd.java:314)
> [Server:server-one] at org.teiid.jboss.TeiidAdd.performRuntime(TeiidAdd.java:215)
> [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler.performRuntime(AbstractAddStepHandler.java:337)
> [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler$1.execute(AbstractAddStepHandler.java:151)
> [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:890)
> [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:659)
> [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)
> [Server:server-one] at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)
> [Server:server-one] at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:39
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4887) Domain mode configuration fails with CNF
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4887?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4887:
----------------------------------
Fix Version/s: 9.1.5
> Domain mode configuration fails with CNF
> ----------------------------------------
>
> Key: TEIID-4887
> URL: https://issues.jboss.org/browse/TEIID-4887
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 9.1
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 9.3, 9.1.5, 9.2.3
>
>
> domain script fails to run to the finish with a exception
> {code}
> [Server:server-one] 12:15:52,763 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 62) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]): java.lang.NoClassDefFoundError: org/wildfly/clustering/jgroups/spi/service/ProtocolStackServiceName
> [Server:server-one] at org.teiid.jboss.TeiidAdd.initilaizeTeiidEngine(TeiidAdd.java:314)
> [Server:server-one] at org.teiid.jboss.TeiidAdd.performRuntime(TeiidAdd.java:215)
> [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler.performRuntime(AbstractAddStepHandler.java:337)
> [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler$1.execute(AbstractAddStepHandler.java:151)
> [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:890)
> [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:659)
> [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)
> [Server:server-one] at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)
> [Server:server-one] at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:39
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4890) DatabaseMetadata Procedure Columns order is incorrect
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4890:
-------------------------------------
Summary: DatabaseMetadata Procedure Columns order is incorrect
Key: TEIID-4890
URL: https://issues.jboss.org/browse/TEIID-4890
Project: Teiid
Issue Type: Bug
Components: JDBC Driver, Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 9.3, 9.1.5, 9.2.3
Parameters should be ordered by position - with the return first, but are ordered instead by type.
Also the return parameter should have an ordinal of 0.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4889) Separate commons-net and mongo-java-driver from api module
by Kylin Soong (JIRA)
Kylin Soong created TEIID-4889:
----------------------------------
Summary: Separate commons-net and mongo-java-driver from api module
Key: TEIID-4889
URL: https://issues.jboss.org/browse/TEIID-4889
Project: Teiid
Issue Type: Quality Risk
Components: Build/Kits
Affects Versions: 9.3
Reporter: Kylin Soong
Assignee: Kylin Soong
Fix For: 9.3
{code}
file/api/
└── main
├── commons-net-3.5.jar
├── file-api-9.3.0.Beta2-SNAPSHOT.jar
└── module.xml
mongodb/api/
└── main
├── module.xml
├── mongodb-api-9.3.0.Beta2-SNAPSHOT.jar
└── mongo-java-driver-2.13.1.jar
{code}
As above snippets, commons-net and mongo-java-driver are packaged together with api module, some times feel confused if set up auto-detect and create module in runtime.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4883) Teiid Excel Translator should filter blank cells from header row
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4883?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-4883.
---------------------------------
Resolution: Done
Thanks [~dvilaverde] for the contribution.
> Teiid Excel Translator should filter blank cells from header row
> ----------------------------------------------------------------
>
> Key: TEIID-4883
> URL: https://issues.jboss.org/browse/TEIID-4883
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: David Vilaverde
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.3
>
> Attachments: fr-demo1-sample-data.xls
>
>
> The teiid translator for excel will throw a duplicate column name exception when using a spreadsheet that has 2 or more columns where the header row doesn't specify a header name. In the attached spreadsheet it's difficult to see that rows E-H should be deleted from the dataset.
> The proposed enhancement is to allow the translator for excel to exclude any trailing columns where there is no column name defined.
> I took a shot at making this enhancement and created a PR at https://github.com/teiid/teiid/pull/951
> If this PR is not going to be accepted, can the methods in the ExcelMetadataProcessor me changed from private to protected so that the processor can be extended easily?
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4883) Teiid Excel Translator should filter blank cells from header row
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4883?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-4883:
--------------------------------
Fix Version/s: 9.3
(was: Open To Community)
> Teiid Excel Translator should filter blank cells from header row
> ----------------------------------------------------------------
>
> Key: TEIID-4883
> URL: https://issues.jboss.org/browse/TEIID-4883
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: David Vilaverde
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.3
>
> Attachments: fr-demo1-sample-data.xls
>
>
> The teiid translator for excel will throw a duplicate column name exception when using a spreadsheet that has 2 or more columns where the header row doesn't specify a header name. In the attached spreadsheet it's difficult to see that rows E-H should be deleted from the dataset.
> The proposed enhancement is to allow the translator for excel to exclude any trailing columns where there is no column name defined.
> I took a shot at making this enhancement and created a PR at https://github.com/teiid/teiid/pull/951
> If this PR is not going to be accepted, can the methods in the ExcelMetadataProcessor me changed from private to protected so that the processor can be extended easily?
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4888) Support for SetQueryLimit
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4888?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4888:
----------------------------------
Fix Version/s: 10.0
> Support for SetQueryLimit
> -------------------------
>
> Key: TEIID-4888
> URL: https://issues.jboss.org/browse/TEIID-4888
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Connector
> Reporter: German Tejero
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 10.0
>
>
> OpenEdge RDBMS not support fetch/offset in a set query. For example, the generated SQL:
> SELECT
> g_1.ejer AS c_0
> FROM PUB.modpre AS g_1
> UNION ALL
> SELECT
> g_0.ejer AS c_0
> FROM PUB.modesp AS g_0
> FETCH NEXT 100 ROWS ONLY
> For the view:
> CREATE VIEW Modificaciones(
> ejercicio INTEGER
> )AS SELECT T.ejercicio
> FROM(
> SELECT M.ejercicio,
> FROM sipbas.modesp AS M
> UNION ALL
> SELECT M.ejercicio
> FROM sipbas.modpre AS M) AS T;
> It is necessary to be able to indicate SetQueryLimit in the same way as with SetQueryOrderBy.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4888) Support for SetQueryLimit
by German Tejero (JIRA)
German Tejero created TEIID-4888:
------------------------------------
Summary: Support for SetQueryLimit
Key: TEIID-4888
URL: https://issues.jboss.org/browse/TEIID-4888
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Reporter: German Tejero
Assignee: Steven Hawkins
Priority: Minor
OpenEdge RDBMS not support fetch/offset in a set query. For example, the generated SQL:
SELECT
g_1.ejer AS c_0
FROM PUB.modpre AS g_1
UNION ALL
SELECT
g_0.ejer AS c_0
FROM PUB.modesp AS g_0
FETCH NEXT 100 ROWS ONLY
For the view:
CREATE VIEW Modificaciones(
ejercicio INTEGER
)AS SELECT T.ejercicio
FROM(
SELECT M.ejercicio,
FROM sipbas.modesp AS M
UNION ALL
SELECT M.ejercicio
FROM sipbas.modpre AS M) AS T;
It is necessary to be able to indicate SetQueryLimit in the same way as with SetQueryOrderBy.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months