Designer haven't set password to datasource which is created
before preview.
----------------------------------------------------------------------------
Key: TEIIDDES-2951
URL:
https://issues.jboss.org/browse/TEIIDDES-2951
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 10.0.2
Environment: Fedora 24
Reporter: Matej Kralik
Assignee: Barry LaFond
Priority: Critical
Labels: verified_jbdsis-9.0.3
Fix For: 10.0.2
Attachments: screenshot1.png, screenshot2.png
I generated source model from a database (SQL Server) via JDBC. When I go through wizard
I haven't started server so the data source haven't been set (screenshot1). I
started a server and I wanted to preview data, shows me dialog
([
TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create
DS. I clicked yes and ok but server shows error:
{code:java}
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote
org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for
SQL_Server_2008_Books were not available. The command could not be planned properly.
{code}
I tried to create the data source (with the same name) manually but the error is still
there [
TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data
source from the server and create it again or set another name of the datasource.
I deleted datasource.
When I generated a model from a database via JDBC again (but a server was running) and I
checked Auto-create Data Source (screenshot2), preview worked fine.
So I notice that datasource haven't set a password when DS is created before the
preview.
I looked to standalone.xml
Datasource which is created before preview:
{code:java}
datasource jndi-name="java:/SQL_Server_2008_Books_DS"
pool-name="SQL_Server_2008_Books_DS" enabled="true">
<connection-url>connection url</connection-url>
<driver>sqljdbc4.jar</driver>
<security>
<user-name>books</user-name>
</security>
</datasource>
{code}
Datasource which is created in the import wizard:
{code:java}
<datasource jndi-name="java:/SQL_Server_2008_Books_DS"
pool-name="SQL_Server_2008_Books_DS" enabled="true">
<connection-url>connection url</connection-url>
<driver>sqljdbc4.jar</driver>
<security>
<user-name>books</user-name>
<password>**</password>
</security>
</datasource>
{code}