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

[Jan Martiska (JIRA)]

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

Jan Martiska commented on TEIID-5386:
-------------------------------------

This was JDBC driver version 4.0, I now tried the same with version 6.4, but no difference:
{noformat}
Commit=true;DatabaseProductName=Microsoft SQL Server;DatabaseProductVersion=13.00.4001;DriverMajorVersion=6;DriverMajorVersion=4;DriverName=Microsoft JDBC Driver 6.4 for SQL Server;DriverVersion=6.4.0.0;IsolationLevel=2
{noformat}

> 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)