[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2301:
-----------------------------------
Component/s: Patch Release
> XML File importer - issues with SQL generation
> ----------------------------------------------
>
> Key: TEIIDDES-2301
> URL: https://issues.jboss.org/browse/TEIIDDES-2301
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
> Attachments: xmlImportSQLGeneration.png
>
>
> In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly.
> Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months
[JBoss JIRA] (TEIIDDES-2356) Import DDL file from workspace location does not work. File not found
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2356?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2356:
-----------------------------------
Component/s: Patch Release
> Import DDL file from workspace location does not work. File not found
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2356
> URL: https://issues.jboss.org/browse/TEIIDDES-2356
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release
> Affects Versions: 8.6
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
>
> Trying to import a DDL file from a workspace location cannot find the designated file.
> The workspace relative path is shown and stored in the DdlImporter and combo-box text, however, the importer expects an existing Java File location.
> Need to convert the selected IResource/IFile to a file and use that path instead:
> >>> final File realFile = choice.getLocation().toFile();
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months
[JBoss JIRA] (TEIIDDES-2347) Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2347?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2347:
-----------------------------------
Component/s: Patch Release
> Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2347
> URL: https://issues.jboss.org/browse/TEIIDDES-2347
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, Teiid Integration, VDB & Execution
> Affects Versions: 8.6
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
>
> 1) Deploy a Dynamic VDB on a server
> 2) Select in Designer Servier view and select "Undeploy VDB"
> 3) Get following uncaught exception:
> {code}
> !ENTRY org.teiid.designer.dqp.ui 2 0 2014-09-22 15:53:57.594
> !MESSAGE Error undeploying VDB: Portfolio
> !STACK 0
> org.teiid.adminapi.AdminProcessingException: {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014807: Management resource '[(\"deployment\" => \"Portfolio.vdb\")]' not found"}}
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.execute(Admin8Factory.java:548)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.undeploy(Admin8Factory.java:782)
> at org.teiid.runtime.client.admin.v8.Admin8Spec.undeploy(Admin8Spec.java:73)
> at org.teiid.runtime.client.admin.ExecutionAdmin.undeployVdb(ExecutionAdmin.java:773)
> {code}
> We're only catching "OperationFormatException" format exception. maybe we should catch this type too and display to user?
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months
[JBoss JIRA] (TEIIDDES-2347) Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2347?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2347.
------------------------------------
Assignee: Barry LaFond (was: Paul Richardson)
Resolution: Done
changed undeploy to use deployment-name property value instead of vdbName
Done
https://github.com/Teiid-Designer/teiid-designer/commit/5633d7de5a3dc55d6...
> Undeploying a Dynamic VDB results in TeiidAdminProcessing exception
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2347
> URL: https://issues.jboss.org/browse/TEIIDDES-2347
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration, VDB & Execution
> Affects Versions: 8.6
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
>
> 1) Deploy a Dynamic VDB on a server
> 2) Select in Designer Servier view and select "Undeploy VDB"
> 3) Get following uncaught exception:
> {code}
> !ENTRY org.teiid.designer.dqp.ui 2 0 2014-09-22 15:53:57.594
> !MESSAGE Error undeploying VDB: Portfolio
> !STACK 0
> org.teiid.adminapi.AdminProcessingException: {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014807: Management resource '[(\"deployment\" => \"Portfolio.vdb\")]' not found"}}
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.execute(Admin8Factory.java:548)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.undeploy(Admin8Factory.java:782)
> at org.teiid.runtime.client.admin.v8.Admin8Spec.undeploy(Admin8Spec.java:73)
> at org.teiid.runtime.client.admin.ExecutionAdmin.undeployVdb(ExecutionAdmin.java:773)
> {code}
> We're only catching "OperationFormatException" format exception. maybe we should catch this type too and display to user?
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months
[JBoss JIRA] (TEIIDDES-2210) Using Teiid Connection importer doesn't completely import the DDL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2210?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2210:
----------------------------------------
Added processing of OPTIONS for FKs: https://github.com/Teiid-Designer/teiid-designer/commit/87aa824885227808f...
> Using Teiid Connection importer doesn't completely import the DDL
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2210
> URL: https://issues.jboss.org/browse/TEIIDDES-2210
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 8.6.1
>
>
> When using Teiid connection importer, there's a couple of issues importing the ddl:
> 1. this property isn't being loaded: "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person'
> 2. NIS for Foreign key isn't being set: CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones')
> Example DDL:
> CREATE FOREIGN TABLE Person (
> PersonObject object OPTIONS (NAMEINSOURCE 'this', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'java.lang.Object'),
> name string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> id integer OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.Integer'),
> email string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person');
> CREATE FOREIGN TABLE PhoneNumber (
> number string OPTIONS (NAMEINSOURCE 'phone.number', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> type string OPTIONS (NAMEINSOURCE 'phone.type', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> Id integer NOT NULL OPTIONS (SELECTABLE FALSE, SEARCHABLE 'Unsearchable', NATIVE_TYPE 'int'),
> CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones')
> ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.PhoneNumber');
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months
[JBoss JIRA] (TEIIDDES-2356) Import DDL file from workspace location does not work. File not found
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2356:
--------------------------------------
Summary: Import DDL file from workspace location does not work. File not found
Key: TEIIDDES-2356
URL: https://issues.jboss.org/browse/TEIIDDES-2356
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.6
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 8.7, 8.6.1
Trying to import a DDL file from a workspace location cannot find the designated file.
The workspace relative path is shown and stored in the DdlImporter and combo-box text, however, the importer expects an existing Java File location.
Need to convert the selected IResource/IFile to a file and use that path instead:
>>> final File realFile = choice.getLocation().toFile();
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months
[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2301:
----------------------------------------
Note: Work with Ted to develop a better approach
> XML File importer - issues with SQL generation
> ----------------------------------------------
>
> Key: TEIIDDES-2301
> URL: https://issues.jboss.org/browse/TEIIDDES-2301
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 8.7, 8.6.1
>
> Attachments: xmlImportSQLGeneration.png
>
>
> In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly.
> Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months