This indeed solved my problem. Thanks a lot!
From: Clinton Begin <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Lieven De Keyzer <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:
>
>
>
> >From: Clinton Begin <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >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 <[EMAIL PROTECTED]> 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?
> > >
> > >
>
>
