Hi all,
I'm in the process of upgrading now and I found answer to some of my
questions but I was wondering what should I do with the modification I
made. I created PaginatedDataListWithRowCount class because I need to
have the number of row returned when I used a paginatedDataList. This
way I can show the number of row on the screen. I was wondering what
was the official way to implements that? I doubt that I chose the right
way when I did it 3 years ago!
Thanks for your advice.. I'm proceeding with the upgrade now :-)
/David
You can set it with the resultSetType attribute of the <select> element.
PS: 2.2.0 is coming out in a few days. Feel free to continue your
upgrade efforts, as it will be compatible, but I'd suggest going to
production with 2.2.0 (after testing of course).
Cheers,
Clinton
On 8/14/06, *David Gagnon* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi,
Thanks for the help! I will then ;-)
I'm using 1.5 so this shouldn`t be a problem.
Maybe another question that you may answer since your know well
all the
db stuff. I came to the idea of upgrading ibatis because I tried to
upgrade my postgresql jdbc driver. I get this exception:
DEBUG [main] ( MappedStatement.java:908) 2006-08-14 13:23:03,000
: Error
executing 'role.getList' in '[Reader passed to buildSqlMap()]'. Check
the SQL statement. Cause: org.postgresql.util.PSQLException:
L'opération
nécessite un scrollable ResultSet, mais ce ResultSet est
FORWARD_ONLY.
org.postgresql.util.PSQLException: L'opération nécessite un scrollable
ResultSet, mais ce ResultSet est FORWARD_ONLY.
at
com.ibatis.db.sqlmap.MappedStatement.runQueryForList(MappedStatement.java:908)
at
com.ibatis.db.sqlmap.MappedStatement.executeQueryForList(MappedStatement.java:665)
at
com.ibatis.db.sqlmap.MappedStatement.executeQueryForList(MappedStatement.java:643)
(sorry for the french exception) But it complain about the resultSet
being Forward_Only. I check and found that the type of ResulSet
must be
given in the prepareStatement. But I search the source of 2.1.7 and
didn`t find a place where this was set. Will I run into the same
problem with 2.1.7 ? Any Idea how to fix this problem ?
Anyway Thanks for the help!
Best Regards
/David
Clinton Begin wrote:
> YES! CONCURE!!! ;-)
>
> David: Are you using JDK 1.4 or greater?
>
> Cheers,
> Clinton
>
>
>
>
> On 8/14/06, *Nathan Maves* < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>> wrote:
>
> I even *concur* :)
>
>
> On 8/14/06, *Nathan Maves* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>> wrote:
>
> I concure. Please upgrade and let us know if you have any
> problems.
>
> nathan
>
>
>
> On 8/14/06, *Jeff Butler* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>> wrote:
>
> You can use the Ant task to upgrade your sql maps,
or just
> a find/replace. On one project with about 80 result
maps
> I did it with find/replace - it's pretty easy.
>
> The only real issue we had with upgrading that
project is
> that iBATIS 2.x will throw an exception if you execute a
> queryForObject but the query returns more than one row.
> This has actually helped us find several errors in our
> code, but it was hard to test all the code paths to root
> out these errors. We still find them every once in
a while!
>
> Other than that, I'll say YES - definitely upgrade. We
> don't support version 1.x anymore
>
> Jeff Butler
>
>
> On 8/14/06, *David Gagnon* < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> > wrote:
>
> Hi all,
>
> I've been working with ibatis for several years but
> because version
> 1.3+ wasn't supporting multiple datasource in the
> sqlmap I didn't update
> since this time:-( I don't have this limitation
> anymore and I wonder
> if the upgrade worth the effort.
>
> I probably have arroud 60 sql maps. I patched
1.3 to
> support some
> custom type too! Is 2.1.7 is faster ?
>
> Too for the migration path what is that gone be
> hard? I remembered I
> need to use some ant task to convert my map to
the new
> format.
>
> Since the gap is growing between the releases it
> getting more and more
> difficult to have a clear view...
>
> Thanks for any help.. it`s really appreciated!
> Best Regards
> /David
>
>
>
>
>
