[
https://issues.jboss.org/browse/TEIID-5386?page=com.atlassian.jira.plugin...
]
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)