Re: [SQL Server 2000 Driver for JDBC]Must declare the variable '@P7where'

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 08/26/04


Date: Thu, 26 Aug 2004 08:21:30 -0700
To: nauna <nauna_jia@hotmail.com>

Show the JDBC code that creates the statement, sets the parameters, and calls the execute().

nauna wrote:
> 1) I'm using MS Sql Server 2000 JDBC driver at WSAD5.1.1.
> 2) When I try to update the database in my DAO by using:
> ps.executeUpdate();
> 3) Server throws the exception:
> java.sql.SQLException: [Microsoft][SQL Server 2000 Driver for
> JDBC][SQL Server]Must declare the variable '@P7where'.
>
> Anything is wrong with the MS JDBC driver with IBM WSAD??? shall I set
> something somewhere?
>
> Experts, please help!


Loading