[JBoss JIRA] (TEIIDDES-3034) Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3034?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3034:
-----------------------------------
Fix Version/s: 11.1.2
> Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-3034
> URL: https://issues.jboss.org/browse/TEIIDDES-3034
…
[View More]> Project: Teiid Designer
> Issue Type: Enhancement
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 11.1, 11.1.1, 11.1.2
>
> Attachments: viewModelFromComment.png, viewModelFromDescription.png
>
>
> testing and debugging for TEIIDDES-2783 exposed an issue when importing a procedure containing a RETURNS data type and no result set.
> The transformation resolving framework contains logic that will auto-create a result set containing a generated column.
> We need to catch this use-case and prevent the result set from being created using this simple DDL input
> {code}
> CREATE VIRTUAL PROCEDURE ProcedureWithRS (
> stringIN string(4000) OPTIONS(ANNOTATION 'parameter 1 description')
> ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') AS
> BEGIN
> SELECT stringIN AS result;
> END
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 3 months
[JBoss JIRA] (TEIIDDES-2865) JDBC importer imports MSSQL Server datatype numeric(9, [0-9]) as bigdecimal with zero precision
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2865?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2865:
-----------------------------------
Fix Version/s: 11.1.2
(was: 11.1)
> JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2865
> URL: https://…
[View More]issues.jboss.org/browse/TEIIDDES-2865
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 10.0, 9.0.5, 9.0.6, 9.0.7
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Fix For: 11.1.1, 11.1.2
>
> Attachments: debTest2Import.png, debtestImport.png, importedColumns.png
>
>
> JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision and should be 9. I believe this https://issues.jboss.org/browse/TEIIDDES-2746 may have changed the behavior, in version 9.0.3 it imports correctly.
> You can use jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds
> user - mss_eds
> password - mss_eds
> table - debtest2, both columns are numeric(9,2)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 3 months
[JBoss JIRA] (TEIIDDES-3097) Create common JNDI entry workflow requiring "java:/" prefix
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3097?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3097:
-----------------------------------
Fix Version/s: 11.1.2
> Create common JNDI entry workflow requiring "java:/" prefix
> -----------------------------------------------------------
>
> Key: TEIIDDES-3097
> URL: https://issues.jboss.org/browse/TEIIDDES-3097
> Project: Teiid Designer
> Issue Type: …
[View More]Enhancement
> Components: Datatools Integration, Editors, Teiid Integration
> Affects Versions: 11.0.1
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 11.1, 11.1.1, 11.1.2
>
> Attachments: LDAP.png, LDAPafter.png, XML.png, XMLafter.png, jdgConnectionProfile.png, salesforce.png, webServiceJNDI.png
>
>
> Change all JNDI name entry fields to validate using common validator to require proper "java:/" prefix and verify valid characters only after that.
> This should collapse all possible JNDI text fields to operate with the same validation logic and make the "java:/" prefix a requirement rather than confusing the user in allowing a name without it yet adding it behind the scenes.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 3 months
[JBoss JIRA] (TEIIDDES-3163) Translator override properties can not be updated after re-generating a dynamic vdb
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3163?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3163:
-----------------------------------
Fix Version/s: 11.1.2
(was: 11.1.1)
> Translator override properties can not be updated after re-generating a dynamic vdb
> -----------------------------------------------------------------------------------
>
> Key: TEIIDDES-3163
> URL: https://issues.jboss.org/browse/…
[View More]TEIIDDES-3163
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1.1
> Environment: Devstudio 11.1.0 CR1 (Teiid Desinger 11.1.1)
> Reporter: Hiroki Daicho
> Assignee: Barry LaFond
> Fix For: 11.1.2
>
> Attachments: reproducer_project.zip
>
>
> If dynamic vdb has already generated, Translator override properties can not be modified by regenerate dynamic vdb.
> 1. Add Translator override property to vdb (testvdb.vdb). e.g. prop1 -> 100
> 2. generate dynamic vdb (testvdb-vdb.xml).
> {code}
> <property name="prop1" value="100"/>
> {code}
> 3. Modify the propery in vdb (testvdb.vdb). e.g. prop1 -> 199
> 4. generate dynamic vdb (testvdb-vdb.xml).
> 5. the property is not updated to 199 in the dynamic vdb xml.
> {code}
> <property name="prop1" value="100"/>
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 3 months
[JBoss JIRA] (TEIIDDES-3162) ModuleNotFoundException occurs with dynamic vdb including UDF Jars
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3162?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3162:
-----------------------------------
Fix Version/s: 11.1.2
(was: 11.1.1)
> ModuleNotFoundException occurs with dynamic vdb including UDF Jars
> ------------------------------------------------------------------
>
> Key: TEIIDDES-3162
> URL: https://issues.jboss.org/browse/TEIIDDES-3162
> …
[View More]Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1.1
> Environment: DevstudioIS 11.1.0 CR1 (Teiid Desinger 11.1.1)
> Reporter: Hiroki Daicho
> Assignee: Barry LaFond
> Fix For: 11.1.2
>
> Attachments: reproducer_project.zip, v2_vdb.xml
>
>
> Teiid desinger 11.1.1 generate UDF jars with comma separated to dynamic vdb as follows.
> {code}
> <property name="lib" value="deployement.test.jar, deployement.test2.jar"/>
> {code}
> But ModuleNotFoundException occurs in teiid server when the dynamic vdb deployed.
> {code}
> ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC000001: Failed to start service jboss.deployment.unit."testvdb-vdb.xml".DEPENDENCIES: org.jboss.msc.service.StartException in service jboss.deployment.unit."testvdb-vdb.xml".DEPENDENCIES: JBAS018733: Failed to process phase DEPENDENCIES of deployment "testvdb-vdb.xml"
> at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:166) [jboss-as-server-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
> Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: TEIID50088 Failed to load module deployment.test.jar, for UDF in VDB testvdb.1:org.jboss.modules.ModuleNotFoundException: deployment.test.jar,:main
> at org.teiid.jboss.VDBDependencyDeployer.deploy(VDBDependencyDeployer.java:85)
> at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:159) [jboss-as-server-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2]
> ... 5 more
> {code}
> Teiid expects space delimited list for the module names.
> "The lib property value may contain a space delimited list of module names if more than one dependency is needed."
> https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtuali...
> If changing vdb to use space delimited as follows, deployment was succeeded.
> {code}
> <property name="lib" value="deployement.test.jar deployement.test2.jar"/>
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 3 months