[teiid-issues] [JBoss JIRA] (TEIID-5386) Wrong procedure import from MS SQL Server

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13596489#comment-13596489 ] 

Steven Hawkins commented on TEIID-5386:
---------------------------------------

The proposed solution will be to simply remove ;number - but we run the risk that it actually was part of the name.  That should be a narrow case though that we can address later.

> Wrong procedure import from MS SQL Server
> -----------------------------------------
>
>                 Key: TEIID-5386
>                 URL: https://issues.jboss.org/browse/TEIID-5386
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.13.6_4
>            Reporter: Jan Martiska
>            Assignee: Steven Hawkins
>
> When using automatic procedure import from SQL Server (I used 2016) with a model like this:
> {noformat}
> <model name="mymodel">
>         <property name="importer.useFullSchemaName" value="false"/>
>         <property name="importer.UseQualifiedName" value="false" />
>         <property name="importer.procedureNamePattern" value="echo%"/>
>         <property name="importer.importProcedures" value="true" />
>         <source connection-jndi-name="java:/mssql2016"
>             name="mySource" translator-name="sqlserver" />
>     </model>
> {noformat}
> There is a procedure named {{echo}} in SQL server. It is imported into the VDB as {{"mymodel"."echo;1"}} (not sure why the ;1). When I afterwards try to execute it using
> {noformat}
> EXEC "mymodel"."echo;1"();
> {noformat}, I will get this exception from SQL server which suggests that Teiid mapped the procedure to the wrong name in the source database:
> {noformat}
> com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'echo;1'.
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)