Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of lieven_dekeyzer@hotmail.com
 designates 64.4.49.29 as permitted sender)
Message-ID: <BAY14-F29D0C6EF2040377493BFA9961E0@phx.gbl>
In-Reply-To: <16178eb1050509073557137101@mail.gmail.com>
From: "Lieven De Keyzer" <lieven_dekeyzer@hotmail.com>
To: ibatis-user-java@incubator.apache.org
Bcc: 
Subject: Re: SQLException when deleting
Date: Mon, 09 May 2005 15:04:04 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

This indeed solved my problem. Thanks a lot!

>From: Clinton Begin <clinton.begin@gmail.com>
>Reply-To: cbegin@ibatis.com
>To: Lieven De Keyzer <lieven_dekeyzer@hotmail.com>
>Subject: Re: SQLException when deleting
>Date: Mon, 9 May 2005 08:35:28 -0600
>
>Try getting v2.0.9b. JPetStore doesn't necessarily come with the latest
>iBATIS JAR. They are separate development paths.
>
>Cheers,
>Clinto
>
>On 5/9/05, Lieven De Keyzer <lieven_dekeyzer@hotmail.com> wrote:
> >
> >
> >
> > >From: Clinton Begin <clinton.begin@gmail.com>
> > >Reply-To: cbegin@ibatis.com
> > >To: ibatis-user-java@incubator.apache.org
> > >Subject: Re: SQLException when deleting
> > >Date: Sun, 8 May 2005 21:45:01 -0600
> > >
> > >Odd....the DAO template doesn't throw an exception...
> > >
> > > public int delete(String id, Object parameterObject) {
> > >
> > >
> > >Maybe you're using an old version of the framework?
> >
> > I'm using the same jar files for the DAO and SqlMaps frameworks as used 
>in
> > the latest version of the JPetStore example.
> >
> > Anyway, here is the complete file:
> >
> > package com.vub.bookmarked.persistence.sqlmapdao;
> >
> > import com.ibatis.dao.client.DaoManager;
> > import com.vub.bookmarked.domain.Account;
> > import com.vub.bookmarked.persistence.iface.AccountDao;
> >
> > public class AccountSqlMapDao extends BaseSqlMapDao implements 
>AccountDao
> > {
> >
> > public AccountSqlMapDao(DaoManager daoManager) {
> > super(daoManager);
> > }
> >
> > public Account getAccount(String username) {
> > return (Account) queryForObject("getAccountByUsername", username);
> > }
> >
> > public Account getAccount(String username, String password) {
> > Account account = new Account();
> > account.setUsername(username);
> > account.setPassword(password);
> > return (Account) queryForObject("getAccountByUsernameAndPassword",
> > account);
> > }
> >
> > public void insertAccount(Account account) {
> > insert("insertAccount", account);
> > }
> >
> > public void updateAccount(Account account) {
> > update("updateAccount", account);
> > }
> >
> > public void deleteAccount(Account account) {
> > delete("deleteAccount", account);
> > }
> >
> > }
> >
> > >
> > >
> > >Cheers,
> > >Clinton
> > >
> > >
> > >
> > >
> > >On 5/8/05, Lieven De Keyzer <lieven_dekeyzer@hotmail.com> wrote:
> > > >
> > > > This is a snapshot of my AccountSqlMapDao, following the concepts of
> > the
> > > > latest JPetStore.
> > > >
> > > > public void insertAccount(Account account) {
> > > > insert("insertAccount", account);
> > > > }
> > > >
> > > > public void updateAccount(Account account) {
> > > > update("updateAccount", account);
> > > > }
> > > >
> > > > public void deleteAccount(Account account) {
> > > > delete("deleteAccount", account);
> > > > }
> > > >
> > > > I get an error however in deleteAccount:
> > > >
> > > > unreported exception java.sql.SQLException; must be caught or 
>declared
> > >to
> > > > be
> > > > thrown
> > > >
> > > > [javac] delete("deleteAccount", account);
> > > >
> > > > Why do I need to catch the exception for the delete statement, but 
>not
> > >for
> > > > the insert or update method?
> > > >
> > > >
> >
> >