commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Akerman (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DBUTILS-77) "drop view" does not work from QueryRunner.update with SQLServer JDBC drivers. Same SQL works with a PreparedStatement just fine.
Date Mon, 14 Nov 2011 15:57:51 GMT

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

Michael Akerman commented on DBUTILS-77:
----------------------------------------

Here is the inner SQLException:
com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException:
Unable to identify the table drop view sqlapps.rso_current_person for the metadata.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
	at com.microsoft.sqlserver.jdbc.SQLServerParameterMetaData.(SQLServerParameterMetaData.java:426)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getParameterMetaData(SQLServerPreparedStatement.java:1510)
	at org.apache.commons.dbutils.AbstractQueryRunner.fillStatement(AbstractQueryRunner.java:172)
	at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:485)
	at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:402)
	at edu.uark.util.ConnectionUtils.execute(ConnectionUtils.java:66)
	at edu.uark.util.queryrunner.Main.main(Main.java:64)

                
> "drop view" does not work from QueryRunner.update with SQLServer JDBC drivers.  Same
SQL works with a PreparedStatement just fine.
> ----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DBUTILS-77
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-77
>             Project: Commons DbUtils
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: Java environment: Java 6 on Redhat Linux
> Database enviroment: SQLServer 2008
>            Reporter: Michael Akerman
>             Fix For: 1.5
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message