Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of gnomeking@gmail.com designates
 64.233.182.185 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=t791Nq+Fm0Oimizm2paqI7bzmsGay2qt4xyHtbRQXOvAZ4Z0Nz/qrAeTNCrYYgenIB/7UrBd7mzH3p+lFNGgnQNCRRDR+OsqZY2JSPsdP5J8XBctOnFzEFLWcjDqOsrkTmLPXoqOuMGH8hfsiX6a3009cYCUF3h1ygrq4n/IYLE=
Message-ID: <d990bcc80603230054v5a0c2df3q@mail.gmail.com>
Date: Thu, 23 Mar 2006 08:54:51 +0000
From: Bob <gnomeking@gmail.com>
To: "Bruce Wexler" <bwexler@massconnections.com>
Subject: Re: sql server 2k parameterized queries
Cc: user-java@ibatis.apache.org
In-Reply-To: 
 <07D14BB1384B0F4B98CF3D1D48A9CA8C086D541F@mcexchange2.enterprise.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: 
 <07D14BB1384B0F4B98CF3D1D48A9CA8C086D541F@mcexchange2.enterprise.com>

Bruce,

On 23/03/06, Bruce Wexler <bwexler@massconnections.com> wrote:
> Caused by: com.ibatis.dao.client.DaoException: Failed to queryForPaginate=
dList - id [getProductListByCategory], parameterObject [DOGS], pageSize [4]=
.  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/ibatis/jpetstore/persistence/sqlmapdao/sql/=
Product.xml.
> --- The error occurred while applying a parameter map.
> --- Check the getProductListByCategory-InlineParameterMap.
> --- Check the statement (query failed).
> --- Cause: java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQL=
Server]Invalid object name 'PRODUCT'.

I'm no expert, but to me that indicates that it is connecting to the
server and sending the query.  The query is then coming back
suggesting that SQL server had a problem with the request.  In this
case, it is suggesting to me that it cannot find the PRODUCT table.

I would check three things...
1) Are you connecting to the correct server / table
2) Does the user you are connecting as have permissions to execute
that query (I assume it does since you seem to be using sa)
3) Is the default table for your user the table you want to use

Try using SQL Profiler to track what query is being made to the
server, then Query Analyser to log in and check if you actually do
have permissions to run that query.

> database.properties file:
>
> driver=3Dcom.ddtek.jdbc.sqlserver.SQLServerDriver

One other difference is that I am using the driver
net.sourceforge.jtds.jdbc.Driver

I'm also setting up the data source in tomcat's server.xml - but I
guess thats not going to be your problem

Bob