November 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3206) JDBC Datasources Broken

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3206: --------------------------------- Summary: JDBC Datasources Broken 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 JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3202) Add the translator to the log entry when the model is loaded

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3202?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3202: ---------------------------------- Fix Version/s: 8.10 > Add the translator to the log entry when the model is loaded > ------------------------------------------------------------ > > Key: TEIID-3202 > URL: https://issues.jboss.org/browse/TEIID-3202 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Optional > Fix For: 8.10 > > > When the server starts up and there's a log entry for the model when its loaded. Example: > 11:00:29,691 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB QT_Hive_Push.1 model "Source" metadata is currently being loaded. Start Time: 9/25/14 11:00 AM > It would be nice to have the associated translator that was assigned at load time. This can be helpful to tracking down issues. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3042: --------------------------------------- Usage was chosen to keep the table / column name concise: CREATE FOREIGN TABLE Usage ( VDBName string(255) NOT NULL, UID string(50) NOT NULL, object_type string(50) NOT NULL, SchemaName string(255) NOT NULL, Name string(255) NOT NULL, ElementName string(255), Uses_UID string(50) NOT NULL, Uses_object_type string(50) NOT NULL, Uses_SchemaName string(255) NOT NULL, Uses_Name string(255) NOT NULL, Uses_ElementName string(255), PRIMARY KEY (UID, Uses_UID) ); The term usage was chosen as this was similar to a view in sql server and most other dbs when you ask about dependency/referencing info give it in the other direction. That is you are finding objects that depend upon the one you are asking about, not what that object is dependent upon. Other approaches include just exposing procedures (this is especially useful to constrain how the information is searched and/or if something is computed). > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3204) Admin shell throws an IncompatibleClassChangeError

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3204?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3204: ------------------------------------ Think I found the problem and confirm it: - issue: Teiid / adminshell is built with 1.6 (or 1.7 with 1.6 compatibility) and then run with JDK 1.7 https://jira.codehaus.org/browse/GROOVY-6080 I confirmed this issue by running with 1.6 and getting the correct error: ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;] FATAL: org.codehaus.groovy.tools.shell.CommandException: File not found: xx.xx org.codehaus.groovy.tools.shell.CommandException: File not found: xx.xx I also confirmed Teiid is built with JDK 1.7, with 1.6 compatibility with groovy 1.7.2. > Admin shell throws an IncompatibleClassChangeError > -------------------------------------------------- > > Key: TEIID-3204 > URL: https://issues.jboss.org/browse/TEIID-3204 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Van Halbert > > Admin shell throws an IncompatibleClassChangeError when wrong path to groovy script is provided along with load command. > Actual result: > ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;] > FATAL: java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > at groovy.lang.MetaClassImpl.selectConstructorAndTransformArguments(MetaClassImpl.java:1406) > at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.selectConstructorAndTransformArguments(ScriptBytecodeAdapter.java:237) > at org.codehaus.groovy.tools.shell.CommandException.<init>(Command.groovy:60) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > .... > .... -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3042: ------------------------------------- "Usage" name feels to me like how many times somebody used/invoked this view or procedure, should we call something like "dependency" or "dependencyinfo" or "dependencydetails"? > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3042. ----------------------------------- Resolution: Done Added SYSADMIN.Usage. Added a release note and a doc entry in the reference. With 8.10 and recursive common table expressions you can see all dependencies to an object: with u as (select uid, uses_uid from sysadmin.usage union select u.uid, sysadmin.usage.uses_uid from u, sysadmin.usage where u.uses_uid = sysadmin.usage.uid) select * from u > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3204) Admin shell throws an IncompatibleClassChangeError

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3204?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3204: --------------------------------------- The problem isn't with groovy in isolation. Groovy has quite a few other dependencies, see http://stackoverflow.com/questions/11738732/exception-java-lang-incompati... What version of groovy is being used? And what version of groovy was used to determine the dependencies? My understanding from TEIID-3145 was that we are effectively building against Groovy 2.0.5 but then switching the adminshell kitting to use Groovy 1.7.2. > Admin shell throws an IncompatibleClassChangeError > -------------------------------------------------- > > Key: TEIID-3204 > URL: https://issues.jboss.org/browse/TEIID-3204 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Van Halbert > > Admin shell throws an IncompatibleClassChangeError when wrong path to groovy script is provided along with load command. > Actual result: > ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;] > FATAL: java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > at groovy.lang.MetaClassImpl.selectConstructorAndTransformArguments(MetaClassImpl.java:1406) > at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.selectConstructorAndTransformArguments(ScriptBytecodeAdapter.java:237) > at org.codehaus.groovy.tools.shell.CommandException.<init>(Command.groovy:60) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > .... > .... -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3205) Push down supported searched case expression even if other select expressions are not supported by the source

by Sanjeev Gour (JIRA)

Sanjeev Gour created TEIID-3205: ----------------------------------- Summary: Push down supported searched case expression even if other select expressions are not supported by the source Key: TEIID-3205 URL: https://issues.jboss.org/browse/TEIID-3205 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Reporter: Sanjeev Gour Assignee: Steven Hawkins If the source supports the searched case expression and does not support a custom function, having both in the select caused searched case expression not to be pushed. More details are here- https://developer.jboss.org/message/909439#909439 -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3204) Admin shell throws an IncompatibleClassChangeError

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3204?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3204: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) See also TEIID-3132 and TEIID-3145. It may be that downgrading groovy as was done for TEIID-3145 is not appropriate without downgrading other dependencies. > Admin shell throws an IncompatibleClassChangeError > -------------------------------------------------- > > Key: TEIID-3204 > URL: https://issues.jboss.org/browse/TEIID-3204 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Van Halbert > > Admin shell throws an IncompatibleClassChangeError when wrong path to groovy script is provided along with load command. > Actual result: > ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;] > FATAL: java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > at groovy.lang.MetaClassImpl.selectConstructorAndTransformArguments(MetaClassImpl.java:1406) > at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.selectConstructorAndTransformArguments(ScriptBytecodeAdapter.java:237) > at org.codehaus.groovy.tools.shell.CommandException.<init>(Command.groovy:60) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > .... > .... -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3204) Admin shell throws an IncompatibleClassChangeError

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3204?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3204: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1161428 > Admin shell throws an IncompatibleClassChangeError > -------------------------------------------------- > > Key: TEIID-3204 > URL: https://issues.jboss.org/browse/TEIID-3204 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Admin shell throws an IncompatibleClassChangeError when wrong path to groovy script is provided along with load command. > Actual result: > ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;] > FATAL: java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5 > at groovy.lang.MetaClassImpl.selectConstructorAndTransformArguments(MetaClassImpl.java:1406) > at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.selectConstructorAndTransformArguments(ScriptBytecodeAdapter.java:237) > at org.codehaus.groovy.tools.shell.CommandException.<init>(Command.groovy:60) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > .... > .... -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 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 November 2014