[JBoss JIRA] (TEIIDDES-2237) Server credentials for multiple Teiid instances sharing password
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2237:
--------------------------------------
Summary: Server credentials for multiple Teiid instances sharing password
Key: TEIIDDES-2237
URL: https://issues.jboss.org/browse/TEIIDDES-2237
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Teiid Integration, VDB & Execution
Affects Versions: 8.5
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.6, 8.5.1
1) Set up EAP6.1Alpha + Teiid 7.7Final server (username=user, pwd=user)
* Open Teiid server editor page and see user/****
2) Set up DV6.1DR1 server (username=teiidUser, pwd =teiidUser)
3) Start DV6.1DR1 server and open Teiid server editor page and see teiidUser/******** properties. Stop server.
4) Start EAP6.1Alpha + Teiid 7.7Final. Open Teiid server editor page and see user/********
Seems the PWD from one server is being used for multiple servers?
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2236) An error occurred while attempting to analyse the teiid instance's translator: salesforce
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2236?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2236.
------------------------------------
Resolution: Done
done
> An error occurred while attempting to analyse the teiid instance's translator: salesforce
> -----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2236
> URL: https://issues.jboss.org/browse/TEIIDDES-2236
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Extension Framework, Teiid Integration
> Affects Versions: 8.5
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 8.6, 8.5.1
>
>
> This is using latest Teiid 8.8 version. Occurs when server is started or refreshed.
> {code}
> java.lang.Exception: The Model Extension Definition file "salesforce" did not parse successfully and cannot be added to or updated in the registry.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Defaulted on Create' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Defaulted on Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Picklist Values' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Picklist Values' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Create' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Delete' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Delete' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports ID Lookup' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports ID Lookup' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Merge' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Merge' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Query' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Query' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Replicate' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Replicate' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Retrieve' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Retrieve' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Search' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Search' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.deploy(TeiidInstanceMedListener.java:132)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.analyseTranslators(TeiidInstanceMedListener.java:224)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.access$0(TeiidInstanceMedListener.java:192)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener$1.run(TeiidInstanceMedListener.java:251)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2236) An error occurred while attempting to analyse the teiid instance's translator: salesforce
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2236?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2236:
----------------------------------------
The issue popped up because of the initial legacy Salesforce MED being constructed based on a non-space name rule. The *modelExtension.xsd" specified the type for this name value as *xs:NCName* which the TeiidInstanceMedListener was using to validate the incoming extension name values and throwing the exception.
The fix is to relax the datatype to *xs:token* which does allow SPACEs. The MED editor's validation framework will still prevent any new MEDs to defined property names containing SPACEs
> An error occurred while attempting to analyse the teiid instance's translator: salesforce
> -----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2236
> URL: https://issues.jboss.org/browse/TEIIDDES-2236
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Extension Framework, Teiid Integration
> Affects Versions: 8.5
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 8.6, 8.5.1
>
>
> This is using latest Teiid 8.8 version. Occurs when server is started or refreshed.
> {code}
> java.lang.Exception: The Model Extension Definition file "salesforce" did not parse successfully and cannot be added to or updated in the registry.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Defaulted on Create' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Defaulted on Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Picklist Values' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Picklist Values' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Create' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Delete' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Delete' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports ID Lookup' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports ID Lookup' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Merge' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Merge' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Query' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Query' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Replicate' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Replicate' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Retrieve' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Retrieve' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Search' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Search' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.deploy(TeiidInstanceMedListener.java:132)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.analyseTranslators(TeiidInstanceMedListener.java:224)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.access$0(TeiidInstanceMedListener.java:192)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener$1.run(TeiidInstanceMedListener.java:251)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2236) An error occurred while attempting to analyse the teiid instance's translator: salesforce
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2236?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2236:
-----------------------------------
Fix Version/s: 8.6
8.5.1
Assignee: Barry LaFond
Affects Version/s: 8.5
Component/s: Extension Framework
Teiid Integration
> An error occurred while attempting to analyse the teiid instance's translator: salesforce
> -----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2236
> URL: https://issues.jboss.org/browse/TEIIDDES-2236
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Extension Framework, Teiid Integration
> Affects Versions: 8.5
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 8.6, 8.5.1
>
>
> This is using latest Teiid 8.8 version. Occurs when server is started or refreshed.
> {code}
> java.lang.Exception: The Model Extension Definition file "salesforce" did not parse successfully and cannot be added to or updated in the registry.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Defaulted on Create' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Defaulted on Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Picklist Values' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Picklist Values' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Create' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Delete' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Delete' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports ID Lookup' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports ID Lookup' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Merge' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Merge' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Query' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Query' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Replicate' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Replicate' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Retrieve' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Retrieve' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Search' is not a valid value for 'NCName'.
> Parsing Error: cvc-attribute.3: The value 'Supports Search' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.deploy(TeiidInstanceMedListener.java:132)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.analyseTranslators(TeiidInstanceMedListener.java:224)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.access$0(TeiidInstanceMedListener.java:192)
> at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener$1.run(TeiidInstanceMedListener.java:251)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2236) An error occurred while attempting to analyse the teiid instance's translator: salesforce
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2236:
--------------------------------------
Summary: An error occurred while attempting to analyse the teiid instance's translator: salesforce
Key: TEIIDDES-2236
URL: https://issues.jboss.org/browse/TEIIDDES-2236
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Reporter: Ramesh Reddy
This is using latest Teiid 8.8 version. Occurs when server is started or refreshed.
{code}
java.lang.Exception: The Model Extension Definition file "salesforce" did not parse successfully and cannot be added to or updated in the registry.
Parsing Error: cvc-datatype-valid.1.2.1: 'Defaulted on Create' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Defaulted on Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Picklist Values' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Picklist Values' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Create' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Create' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Delete' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Delete' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports ID Lookup' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports ID Lookup' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Merge' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Merge' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Query' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Query' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Replicate' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Replicate' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Retrieve' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Retrieve' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
Parsing Error: cvc-datatype-valid.1.2.1: 'Supports Search' is not a valid value for 'NCName'.
Parsing Error: cvc-attribute.3: The value 'Supports Search' of attribute 'name' on element 'property' is not valid with respect to its type, 'NCName'.
at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.deploy(TeiidInstanceMedListener.java:132)
at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.analyseTranslators(TeiidInstanceMedListener.java:224)
at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener.access$0(TeiidInstanceMedListener.java:192)
at org.teiid.designer.extension.ui.server.TeiidInstanceMedListener$1.run(TeiidInstanceMedListener.java:251)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
{code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2214) Cannot generate CXF WAR from VDB created in 8.3.3
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2214?page=com.atlassian.jira.plu... ]
Ted Jones resolved TEIIDDES-2214.
---------------------------------
Resolution: Done
Marking as resolved with Paul's commit to 8.3.x.
> Cannot generate CXF WAR from VDB created in 8.3.3
> -------------------------------------------------
>
> Key: TEIIDDES-2214
> URL: https://issues.jboss.org/browse/TEIIDDES-2214
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: VDB & Execution, Web Services Support
> Affects Versions: 8.3.3
> Environment: Teiid Designer 8.3.3
> JBDS 7.1.1.GA
> Reporter: Andrej Šmigala
> Assignee: Paul Richardson
> Fix For: 8.3.4, 8.5.1
>
> Attachments: CxfTest-8.3.2.zip, CxfTest-8.3.3.zip, log
>
>
> The following error occurs when generating CXF WAR from VDB: "An error occurred while creating WAR file, check log for detail" (log attached).
> This only happens with VDB created in 8.3.3, not if one uses a VDB created in 8.3.2.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2232) Cannot create JDBC/Oracle connection profile using ServiceName syntax
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2232:
----------------------------------------
Using Generic JDBC connection profile will work if:
1) When you define your Generic JDBC driver, set/select the appropriate driver jar (*odbc14.jar*)
2) In the driver properties tab, set the driver class to *oracle.jdbc.OracleDriver*
3) Set your full URL
4) Define *Database* (partssupplier), *User* (partssupplier) and pwd values
5) After importing/creating your source model use *Modeling > Set Translator Name* and select *oracle* translator
Then view connection profile to affirm your proper connection properties are in the source model
Preview and Execute VDB should function as normal.
> Cannot create JDBC/Oracle connection profile using ServiceName syntax
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2232
> URL: https://issues.jboss.org/browse/TEIIDDES-2232
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Teiid Integration
> Affects Versions: 8.4
> Reporter: Tom Johnston
>
> Cannot successfully create a jdbc url like:
> "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename"
> which is found here:
> http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm
> Note the "../myservicename"
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2235) Preview uses Pool Name instead of JNDI name
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2235?page=com.atlassian.jira.plu... ]
Ramesh Reddy updated TEIIDDES-2235:
-----------------------------------
Attachment: connection_profile.png
names.xlsx
> Preview uses Pool Name instead of JNDI name
> -------------------------------------------
>
> Key: TEIIDDES-2235
> URL: https://issues.jboss.org/browse/TEIIDDES-2235
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Data Preview
> Reporter: Ramesh Reddy
> Priority: Critical
> Attachments: connection_profile.png, names.xlsx
>
>
> I am using almost latest 8.5-nightly, and latest 8.8 Teiid.
> I created a file data source in server using CLI
> {code}
> /subsystem=resource-adapters/resource-adapter=fileExcel:add(module=org.jboss.teiid.resource-adapter.file)
> /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS:add(jndi-name="java:/excel-ds", class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true)
> /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=ParentDirectory:add(value="/home/rareddy/Downloads" )
> /subsystem=resource-adapters/resource-adapter=fileExcel:activate
> {code}
> here
> fileExcel = is resource adapter name
> fileDS = pool-name
> java:/excel-ds = JNDI name
> All the communication over the Admin API occurs over "pool-name", however JNDI name is what should be used in the "connection-jndi-name"
> Now, I used "Teiid Connection Importer" to import from data source created above, used "excel" translator, created a model. It created a "sheet1" table. Now right click preview, I see
> {code}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Names: TEIID30481 Failed to find the Connection Factory with JNDI name fileDS. Please check the name or deploy the Connection Factory with specified name.
> {code}
> which is wrong. "Right-Click -> View Connection Profile Dialog" attached.
> I have been suggesting to use a simple "JNDI" based data source connection profile for dealing with the data sources on server to avoid issues like this, and I see designer is going more towards other side adding dependencies like BIRT etc.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2235) Preview uses Pool Name instead of JNDI name
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2235:
--------------------------------------
Summary: Preview uses Pool Name instead of JNDI name
Key: TEIIDDES-2235
URL: https://issues.jboss.org/browse/TEIIDDES-2235
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Data Preview
Reporter: Ramesh Reddy
Priority: Critical
I am using almost latest 8.5-nightly, and latest 8.8 Teiid.
I created a file data source in server using CLI
{code}
/subsystem=resource-adapters/resource-adapter=fileExcel:add(module=org.jboss.teiid.resource-adapter.file)
/subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS:add(jndi-name="java:/excel-ds", class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true)
/subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=ParentDirectory:add(value="/home/rareddy/Downloads" )
/subsystem=resource-adapters/resource-adapter=fileExcel:activate
{code}
here
fileExcel = is resource adapter name
fileDS = pool-name
java:/excel-ds = JNDI name
All the communication over the Admin API occurs over "pool-name", however JNDI name is what should be used in the "connection-jndi-name"
Now, I used "Teiid Connection Importer" to import from data source created above, used "excel" translator, created a model. It created a "sheet1" table. Now right click preview, I see
{code}
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Names: TEIID30481 Failed to find the Connection Factory with JNDI name fileDS. Please check the name or deploy the Connection Factory with specified name.
{code}
which is wrong. "Right-Click -> View Connection Profile Dialog" attached.
I have been suggesting to use a simple "JNDI" based data source connection profile for dealing with the data sources on server to avoid issues like this, and I see designer is going more towards other side adding dependencies like BIRT etc.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months