February 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3355) Improve recommendations so that they translate to configuring server

by Van Halbert (JIRA)

Van Halbert created TEIID-3355: ---------------------------------- Summary: Improve recommendations so that they translate to configuring server Key: TEIID-3355 URL: https://issues.jboss.org/browse/TEIID-3355 Project: Teiid Issue Type: Enhancement Components: Sizing Application Reporter: Van Halbert Assignee: Steven Hawkins Improve the answers so that any configuration recommendations are provided. This might include (not all encompassing): - teiid max threads - teiid max plans - data source connection max pool size ?? The goal here being that this information can be directly translated for configuring the server that we're recommending. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1741) Record level audit trail in teiid log files

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-1741?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-1741: ------------------------------------- I think I am missing the point you are trying to make. How can one write a custom logger when the details are not put in logger to begin with? > Record level audit trail in teiid log files > ------------------------------------------- > > Key: TEIID-1741 > URL: https://issues.jboss.org/browse/TEIID-1741 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Reporter: Monika Ahuja > Fix For: 8.11, Open To Community > > > In order to track the audit trail for patient identified information access, we would like to track the executed queries, results as well as the timestamps for each user's query and its result. Essentially we need a report providing the list of Medical Record Numbers accessed by each user id and I think we can use the Logs to track that (unless you suggest a better way). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1741) Record level audit trail in teiid log files

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1741?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1741: --------------------------------------- I'm saying that I would add a record level logger as a sandbox or a quickstart rather than as a proper part of the project. > Record level audit trail in teiid log files > ------------------------------------------- > > Key: TEIID-1741 > URL: https://issues.jboss.org/browse/TEIID-1741 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Reporter: Monika Ahuja > Fix For: 8.11, Open To Community > > > In order to track the audit trail for patient identified information access, we would like to track the executed queries, results as well as the timestamps for each user's query and its result. Essentially we need a report providing the list of Medical Record Numbers accessed by each user id and I think we can use the Logs to track that (unless you suggest a better way). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1741) Record level audit trail in teiid log files

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-1741?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-1741: ------------------------------------- Are you suggesting above after we add the trace logging for additional items? > Record level audit trail in teiid log files > ------------------------------------------- > > Key: TEIID-1741 > URL: https://issues.jboss.org/browse/TEIID-1741 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Reporter: Monika Ahuja > Fix For: 8.11, Open To Community > > > In order to track the audit trail for patient identified information access, we would like to track the executed queries, results as well as the timestamps for each user's query and its result. Essentially we need a report providing the list of Medical Record Numbers accessed by each user id and I think we can use the Logs to track that (unless you suggest a better way). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1741) Record level audit trail in teiid log files

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1741?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1741: --------------------------------------- For this I would either like to introduce by a quick start or sandbox, so that something exists as a reference but not a fully supported option. Opinions? > Record level audit trail in teiid log files > ------------------------------------------- > > Key: TEIID-1741 > URL: https://issues.jboss.org/browse/TEIID-1741 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Reporter: Monika Ahuja > Fix For: 8.11, Open To Community > > > In order to track the audit trail for patient identified information access, we would like to track the executed queries, results as well as the timestamps for each user's query and its result. Essentially we need a report providing the list of Medical Record Numbers accessed by each user id and I think we can use the Logs to track that (unless you suggest a better way). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3291) Support Amazon Relational Database Service (RDS) as a data source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3291?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3291. ----------------------------------- Resolution: Done Marking as resolved based upon Kylin's investigation and the RDS docs. Also made a few update to the docs. > Support Amazon Relational Database Service (RDS) as a data source > ----------------------------------------------------------------- > > Key: TEIID-3291 > URL: https://issues.jboss.org/browse/TEIID-3291 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.10 > Reporter: Van Halbert > Assignee: Kylin Soong > Fix For: Open To Community > > > Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3121) Teiid Standalone Server

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3121: ----------------------------------- I updated the Maven build to package the server zip. The end result should be the same as what the install.sh created. Hoping the server zip can be published as part of the release process. Also I updated and tested with the docker image. https://github.com/teiid/teiid/pull/414 Misc notes: * Docker CMD was wrong (tokenization issue, sh is fun...). * build/pom.xml had two different lists of assemblies to run. * To build server zip I use Maven dependency plugin to extract JBoss EAP dist and Teiid Web Console. The teiid-jboss-dist assembly leaves unpacked version in build folder. Server assembly pulls everything together and zips it up. > Teiid Standalone Server > ----------------------- > > Key: TEIID-3121 > URL: https://issues.jboss.org/browse/TEIID-3121 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Reporter: Tom Arnold > Fix For: Open To Community > > > Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss. > * Teiid Runtime > * Teiid Web Console > * JBoss EAP 6.1 Alpha > * Resteasy JAX-RS Patch > End result would simplify the installation process to: > 1. Unzip Teiid server. > 2. Run `bin/add-user.sh` script. > 3. Deploy custom translators, VDB, etc. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3121) Teiid Standalone Server

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3121: ------------------------------ Git Pull Request: https://github.com/teiid/teiid/pull/441 (was: https://github.com/teiid/teiid/pull/337) > Teiid Standalone Server > ----------------------- > > Key: TEIID-3121 > URL: https://issues.jboss.org/browse/TEIID-3121 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Reporter: Tom Arnold > Fix For: Open To Community > > > Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss. > * Teiid Runtime > * Teiid Web Console > * JBoss EAP 6.1 Alpha > * Resteasy JAX-RS Patch > End result would simplify the installation process to: > 1. Unzip Teiid server. > 2. Run `bin/add-user.sh` script. > 3. Deploy custom translators, VDB, etc. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3352) Can't cast from decimal to boolean in postgresql

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3352?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3352. ----------------------------------- Fix Version/s: 8.10 (was: 8.11) Resolution: Done Updated to use val <> 0 for each of the non-integral types. > Can't cast from decimal to boolean in postgresql > ------------------------------------------------ > > Key: TEIID-3352 > URL: https://issues.jboss.org/browse/TEIID-3352 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > We can't cast directly to boolean in postgresql from decimal. The Teiid conversion assume anything that isn't 0 is true (matches h2 and other handling). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3353) In SQL Server INSERT ... VALUES clause UUID is not substituted

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3353?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3353. ----------------------------------- Fix Version/s: 8.10 Resolution: Done updated the logic to better handle non-deterministic functions in the pushdown command. > In SQL Server INSERT ... VALUES clause UUID is not substituted > -------------------------------------------------------------- > > Key: TEIID-3353 > URL: https://issues.jboss.org/browse/TEIID-3353 > Project: Teiid > Issue Type: Bug > Reporter: Nicholas D > Assignee: Steven Hawkins > Fix For: 8.10 > > > Teiid 8.4, SQL Server 2012 Express > I'm inserting into table with uniqueidentifier field > {code:sql} > INSERT INTO SOME_TABLE(some_uuid, some_ts) > VALUES (uuid(), now()) > {code} > and get something like > bq. 195 Remote org.teiid.translator.jdbc.JDBCExecutionException: 195 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-24 21:02:23.803'}] SQL: INSERT INTO "DS"."dbo"."SOME_TABLE" ("SOME_UUID", "SOME_TS") VALUES (uuid(), ?)] > However if i use INSERT ... SELECT clause it's substituted normally: > {code:sql} > INSERT INTO SOME_TABLE(some_uuid, some_ts) > SELECT uuid(), now() > FROM SOME_OTHER_TABLE > LIMIT 1 > {code} -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2015