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]>> wrote:
I even *concur* :)
On 8/14/06, *Nathan Maves* <[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]>> 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]> > 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
