commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jozef Matejička (JIRA) <j...@apache.org>
Subject [jira] [Commented] (DBUTILS-117) Error handling possible getParameterMetaData() results
Date Mon, 29 Jan 2018 17:30:02 GMT

    [ https://issues.apache.org/jira/browse/DBUTILS-117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16343676#comment-16343676
] 

Jozef Matejička commented on DBUTILS-117:
-----------------------------------------

Following code also triggers the error:
{code:java}
new QueryRunner().update(tenantDB, "execute as user = 'MY_USER'");{code}
 Driver:
{code:java}
 <dependency>
     <groupId>com.microsoft.sqlserver</groupId>
     <artifactId>mssql-jdbc</artifactId>
     <version>6.2.2.jre8</version>
 </dependency>{code}
Exception thrown:
{code:java}
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'as'.
SQLState = S0001
vendorCode = 156{code}

 Work around:
{code:java}
new QueryRunner(true).update(tenantDB, "execute as user = 'MY_USER'");{code}

> Error handling possible getParameterMetaData() results
> ------------------------------------------------------
>
>                 Key: DBUTILS-117
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-117
>             Project: Commons DbUtils
>          Issue Type: Bug
>    Affects Versions: 1.5
>            Reporter: Vadim Smirnov
>            Priority: Minor
>              Labels: easyfix, newbie
>             Fix For: 1.6
>
>         Attachments: DBUTILS-117-tests.patch, DBUTILS-117.patch
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Error in fillStatement method of AbstractQueryRunner class.
> There is no try...catch statement near pmd = stmt.getParameterMetaData();
> So method fails instead of automaticallye turning pmdKnownBroken to true.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message