ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sanjiv Jivan" <sanjiv.ji...@gmail.com>
Subject Re: MSAccess support?
Date Sat, 19 Aug 2006 15:04:10 GMT
Yes, a SQLException is raised. Maybe at startup time try calling the method
and set a boolean flag or lazily set the boolean flag at the first time a
call to setQueryTimeout() is made.

Thanks,
Sanjiv


On 8/19/06, Jeff Butler <jeffgbutler@gmail.com> wrote:
>
>  Does an SQLExcpetion get thrown, or some other error?  I've done a quick
> check, but so far can't find any standard call to check for driver
> compliance.  I'll keep looking - but maybe an all encompassing catch block
> will be the way to handle it.
>
> Jeff Butler
>
>
>  On 8/19/06, Sanjiv Jivan <sanjiv.jivan@gmail.com> wrote:
> >
> >
> >  It appears that the query timeout feature was added only in Ibatis
> > 2.2.0 which seems to have broken the MSAcess support.
> > http://www.nabble.com/query-timeout--tf1868564.html#a5106526
> >
> > http://issues.apache.org/jira/browse/IBATIS-22
> >
> > Can Ibatis test driver support for this feature before calling it?
> > Additionally, in com.ibatis.sqlmap.engine.execution.SqlExecutor,
> > can the method setStatementTimeout not explicitly call
> > statement.setQueryTimeout(0) if  mappedStatement.getTimeout() is null.
> >
> >   private static void setStatementTimeout(MappedStatement
> > mappedStatement, Statement statement) throws SQLException {
> >     if (mappedStatement.getTimeout() != null) {
> >       statement.setQueryTimeout(mappedStatement.getTimeout().intValue());
> >     } else {
> >       statement.setQueryTimeout(0); // no timeout
> >     }
> >   }
> >
> > Thanks,
> >  Sanjiv
> >
> > On 8/18/06, Sanjiv Jivan <sanjiv.jivan@gmail.com > wrote:
> > >
> > >  The Ibatis FAQ entry on list of supported database/driver lists
> > > MSAccess 2000 with the Sun JDBC OBDC bridge. However when trying to use
> > > Ibatis 2.20 / JDK 1.4 with MSAccess 2000, an exception with message
> > > "Optional feature not implemented"is raised at the point where Ibatis calls
> > > statement.setQueryTimeout(). I checked out the Ibatis code and there
> > > is no protection around this call to test if the optional feature is
> > > supported.
> > >
> > > So my question is how are people able to run Ibatis with MSAccess
> > > using the Sun jdbc-odbc driver? Is it the case that JDK 1.5 has
> > > implemented this method? Regardless, we are required to support JDK
> > > 1.4 so would it be possible for Ibatis to support JDK 1.4 / MS Access?
> > >
> > > Thanks,
> > >  Sanjiv
> > >
> > >
> > >
> >
> >
>

Mime
View raw message