December 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-3206 at 12/5/14 6:28 PM: -------------------------------------------------------------- It looks like 1.0.26 are product bits, they will not be available. I say 1.1.0-Final is next best IMO, not sure about any issues though. That you can download at http://sourceforge.net/projects/ironjacamar/files/ was (Author: rareddy): You could not get it from here? http://www.ironjacamar.org/download.html > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3206: ------------------------------------- You could not get it from here? http://www.ironjacamar.org/download.html > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3245) Database Logging: Problems with Microsoft

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3245?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3245. --------------------------------- Fix Version/s: 8.7.1 Resolution: Done Changed the column name to "row_count". BTW, when the scripts are modified from H2 to other database the included the VDB needs to be modified manually. I am not sure what is the need for this VDB, as the Dashboard can directly access java:/teiid-log-ds to go to source database avoiding this VDB altogether. But it may be serving another purpose that I do not know. > Database Logging: Problems with Microsoft > ------------------------------------------ > > Key: TEIID-3245 > URL: https://issues.jboss.org/browse/TEIID-3245 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Fix For: 8.7.1 > > > Still getting error with mssql driver and sql server 2012. > The error messages look similar, but one: > [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 55) Incorrect syntax near the keyword 'rowcount'. > is present. > While the prior issue > 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool – 57) Incorrect syntax near the keyword 'plan'. > was solved. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3206: ----------------------------------- Ramesh, I can do that, but how do you want to handle the IronJacamar module ZIP file? I think that ZIP should be hosted somewhere (like Teiid SourceForge) instead of being checked into Git. Basically I could not find a download for an IJ JBoss module, so I created a script to create one from Maven, but I think it would be better to run the script once and then just host the result somewhere. Thoughts? > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3245) Database Logging: Problems with Microsoft

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3245?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3245: ------------------------------------- ROWCOUNT is reserved work in SQLSercer per http://msdn.microsoft.com/en-us/library/ms189822.aspx thus the issue, may need to quote it or modify it > Database Logging: Problems with Microsoft > ------------------------------------------ > > Key: TEIID-3245 > URL: https://issues.jboss.org/browse/TEIID-3245 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > > Still getting error with mssql driver and sql server 2012. > The error messages look similar, but one: > [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 55) Incorrect syntax near the keyword 'rowcount'. > is present. > While the prior issue > 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool – 57) Incorrect syntax near the keyword 'plan'. > was solved. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3245) Database Logging: Problems with Microsoft

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3245?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3245: ---------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > Database Logging: Problems with Microsoft > ------------------------------------------ > > Key: TEIID-3245 > URL: https://issues.jboss.org/browse/TEIID-3245 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > > Still getting error with mssql driver and sql server 2012. > The error messages look similar, but one: > [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 55) Incorrect syntax near the keyword 'rowcount'. > is present. > While the prior issue > 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool – 57) Incorrect syntax near the keyword 'plan'. > was solved. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3245) Database Logging: Problems with Microsoft

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3245?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3245: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1118470 > Database Logging: Problems with Microsoft > ------------------------------------------ > > Key: TEIID-3245 > URL: https://issues.jboss.org/browse/TEIID-3245 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Still getting error with mssql driver and sql server 2012. > The error messages look similar, but one: > [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 55) Incorrect syntax near the keyword 'rowcount'. > is present. > While the prior issue > 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool – 57) Incorrect syntax near the keyword 'plan'. > was solved. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3245) Database Logging: Problems with Microsoft

by Van Halbert (JIRA)

Van Halbert created TEIID-3245: ---------------------------------- Summary: Database Logging: Problems with Microsoft Key: TEIID-3245 URL: https://issues.jboss.org/browse/TEIID-3245 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.7.1 Reporter: Van Halbert Assignee: Steven Hawkins Still getting error with mssql driver and sql server 2012. The error messages look similar, but one: [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 55) Incorrect syntax near the keyword 'rowcount'. is present. While the prior issue 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool – 57) Incorrect syntax near the keyword 'plan'. was solved. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3241) Audit/Command Logging handler names do not match web console handler names

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3241?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3241: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1170583|https://bugzilla.redhat.com/show_bug.cgi?id=1170583] from ASSIGNED to MODIFIED > Audit/Command Logging handler names do not match web console handler names > -------------------------------------------------------------------------- > > Key: TEIID-3241 > URL: https://issues.jboss.org/browse/TEIID-3241 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1 > > > When changing configuration of Audit and Command logging via Web Management, an exception is thrown in specific usecase, see the steps to reproduce below. > Then even after server restart logging doesn't work. No changes noticed in standalone.xml during the configuration. > Version-Release number of selected component (if applicable): > DV 6.1.0 ER4 > How reproducible: > Once after installation (further on the logging simply doesn't work) > Steps to Reproduce: > 1.Install DV with audit/command logging enabled > 2.Start DV with bin/standalone.sh, check that logging works > 3.Access http://localhost:9990/console/App.html#teiid-audit and unselect selected options > 4.Apply > 5.Select the previously deselected options again > 6.Apply > 7.See the server log in console > 8.When there is server reload between unselecting and reselecting the options, then the exception is not raised, but the logging doesn't work afterwards. > Actual results: > java.lang.IllegalArgumentException: Handler "TEIID_AUDIT_LOG" is not found > or > java.lang.IllegalArgumentException: Handler "TEIID_COMMAND_LOG" is not found > Expected results: > Logging configured again -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3216: --------------------------------------- I'm working through it now. I'll make some changes for the routine stuff like adding headers and localizing messages and let you know if I have any questions. > Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector > ---------------------------------------------------------------------------- > > Key: TEIID-3216 > URL: https://issues.jboss.org/browse/TEIID-3216 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Filip Elias > Assignee: Filip Elias > Fix For: Open To Community > > > Current plan is to use list-based feed of the Google Data API[1]. > There are three known issues: > performance - to delete/update 100 rows Teiid must generate 100 http requests > consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't. > headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet) > Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers. > [1] https://developers.google.com/google-apps/spreadsheets/ -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 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 December 2014