Mailing-List: contact issues-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: issues@commons.apache.org
Date: Mon, 14 Nov 2011 15:38:52 +0000 (UTC)
From: "Michael Akerman (Commented) (JIRA)" <jira@apache.org>
To: issues@commons.apache.org
Message-ID: 
 <449648083.26953.1321285132110.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1066559881.14946.1310674740043.JavaMail.tomcat@hel.zones.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.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

Here's the code that fails to run the SQL for me:

			final QueryRunner qr = new QueryRunner();
			final int rows = qr.update( con, sql, args );
			return rows;

Here's code that works:
			final PreparedStatement psm = con.prepareStatement( sql );
			for ( int i=1; i <= args.length; i++ )
			{
				psm.setString( i, args[i].toString() );
			}
			int rows = psm.executeUpdate();
			psm.close();
			return rows;
                
> "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