[
https://issues.jboss.org/browse/TEIIDDES-3046?page=com.atlassian.jira.plu...
]
Ramesh Reddy edited comment on TEIIDDES-3046 at 4/17/17 11:47 AM:
------------------------------------------------------------------
In the case of the Resource Adapter the "id" value is used as the identifier, as
the life-cycle of the RA is currently NOT managed at the connection level, but at RA
level. Typically
RA -- * -->ConnectionFactory -- * -->Connections
but typical usage has been
RA -- 1 -->ConnectionFactory -- * -->Connections
[*] = means multiple, [1] = means single connection factory
Since WildFly does not provide same level connection factory management at
ConnectionFactory level without the restart of the server, the workaround was based on
creating a single connection factory per RA. So, now since the pool name is at a different
level than the management, Teiid Admin API uses the "id" at the RA as
identifier. Even in the case when pool -name is omitted in RA, I am sure one is generated
internally for management purposes. Note that this is *may* be true only if you are
editing the standalone.xml file directly. If you are using CLI like below
{code}
/subsystem=resource-adapters/resource-adapter=file/connection-definitions=fileDS:add(jndi-name="${jndi.name}",
class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true,
use-java-context=true)
{code}
Note the "file" and "fileDS" in above code fragment, where
"file" becomes the RA's id and "fileDS" becomes the
connection-pool name. Since the Teiid Admin API uses the CLI underneath, it may generate
some of these names automatically for you. When users mix and match between Designer usage
and hand coding they may get into discrepancies, but as long they use single mechanism it
should be fine, and 99% of time that is the case.
was (Author: rareddy):
In the case of the Resource Adapter the "id" value is used as the identifier, as
the life-cycle of the RA is currently NOT managed at the connection level, but at RA
level. Typically
RA --*-->ConnectionFactory --*-->Connections
but typical usage has been
RA --1-->ConnectionFactory --*-->Connections
[*] = means multiple, [1] = means single connection factory
Since WildFly does not provide same level connection factory management at
ConnectionFactory level without the restart of the server, the workaround was based on
creating a single connection factory per RA. So, now since the pool name is at a different
level than the management, Teiid Admin API uses the "id" at the RA as
identifier. Even in the case when pool -name is omitted in RA, I am sure one is generated
internally for management purposes. Note that this is *may* be true only if you are
editing the standalone.xml file directly. If you are using CLI like below
{code}
/subsystem=resource-adapters/resource-adapter=file/connection-definitions=fileDS:add(jndi-name="${jndi.name}",
class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true,
use-java-context=true)
{code}
Note the "file" and "fileDS" in above code fragment, where
"file" becomes the RA's id and "fileDS" becomes the
connection-pool name. Since the Teiid Admin API uses the CLI underneath, it may generate
some of these names automatically for you. When users mix and match between Designer usage
and hand coding they may get into discrepancies, but as long they use single mechanism it
should be fine, and 99% of time that is the case.
Unable to preview data of file-based data source when the JNDI name
already exist on the server runtime
-------------------------------------------------------------------------------------------------------
Key: TEIIDDES-3046
URL:
https://issues.jboss.org/browse/TEIIDDES-3046
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 10.0.2
Environment: MacOS
Red Hat JBoss Developer Studio 10.3.0.GA with JBoss Developer Studio Integration Stack
10.0.2 installed
Reporter: Cojan van Ballegooijen
Assignee: Barry LaFond
Fix For: 11.0.2
Attachments: Screen Shot 2017-03-01 at 10.16.26.png, Screen Shot 2017-03-01 at
10.16.46.png
If a data source is already created on the JDV server runtime unable to preview data on
the models.
Workaround is to add these models into a VDB, deploy/execute VDB but Preview data should
work despite the fact that the datasource JNDI names already exists on the server side.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)