Actually, I was facing trouble with ANT still unable to find the XSL file.How exactly are u passing this file/src on the ant command prompt..
D:> ant task ... Thanks, Vijay Khanna Desk : 203-326-2365 -----Original Message----- From: David Gagnon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 11:40 AM To: [email protected] Subject: Re: Updating from ibatis 1.3.1 to 2.1.7 .. should I? Does it worth the effort?: ... Upgrade question II Hi, I fact I was wondering why this is not the SQLMap that includes to the sqlMapConfig. ... But if it`s the other way fine I can live with this. /David Nathan Maves wrote: > Not sure what you are asking? If you are asking if you have to keep > all of your sqlMaps in the main config file then the answer is no. > > Here is an example of a sqm map config file that includes multiple > sqlMap files. > > <sqlMapConfig> > > <properties resource="lighthouse/resources/database.properties"/> > > <settings > cacheModelsEnabled="true" > enhancementEnabled="true" > maxSessions="64" > maxTransactions="8" > maxRequests="128" > useStatementNamespaces="false"/> > > <transactionManager type="JDBC"> > <dataSource type="SIMPLE"> > <property name="JDBC.Driver" value="${JDBC.Driver}"/> > <property name="JDBC.ConnectionURL" value="${ > JDBC.ConnectionURL}"/> > <property name="JDBC.Username" value="${JDBC.Username}"/> > <property name="JDBC.Password" value="${JDBC.Password}"/> > <property name="Pool.MaximumActiveConnections" > value="${Pool.MaximumActiveConnections}"/> > <property name="Pool.MaximumIdleConnections" > value="${Pool.MaximumIdleConnections }"/> > </dataSource> > </transactionManager> > > <!-- SQLMaps go here --> > > <sqlMap resource="lighthouse/persistence/sqlMapDao/sql/Load.xml"/> > <sqlMap resource="lighthouse/persistence/sqlMapDao/sql/Metrics.xml"/> > <sqlMap resource="lighthouse/persistence/sqlMapDao/sql/Note.xml"/> > <sqlMap > resource="lighthouse/persistence/sqlMapDao/sql/Hierarchy.xml"/> > <sqlMap > resource="lighthouse/persistence/sqlMapDao/sql/Thresholds.xml"/> > <sqlMap resource="lighthouse/persistence/sqlMapDao/sql/Trend.xml"/> > <sqlMap > resource="lighthouse/persistence/sqlMapDao/sql/CaseData.xml"/> > > </sqlMapConfig> > > As a side note your main sql map config could be called anything you > want :) Here is an example of the sqlmap dao framework with a > sqlmapConfig file called myConfig.xml > > <transactionManager type="SQLMAP"> > <property name="SqlMapConfigResource" > value="lighthouse/persistence/sqlMapDao/myConfig.xml"/> > </transactionManager> > > On 8/16/06, *David Gagnon* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hi all, > > Another question: > -I created an sqlMapConfig but it seems that from the sqlMap you > cannot > load the sqlMapConfig (i.e.: global config). I really need to declare > all my sqlMap in sqlMapCOnfig.xml??? > > I use this code in my DAO to load the corresponding sqlMap: > > sqlNewMap = > > XmlSqlMapBuilder.buildSqlMap(ResourceManager.getResourceAsReader(file) > ); > > I seem to still be valid but this piece of code tells to load the > sqlMap > directly. How can you link to the sqlMapConfig? > > Thanks for your help !!! > /David > > > David Gagnon wrote: > > 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]> > >> <mailto:[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]>> > >> > <mailto: [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]>> > >> > <mailto: [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]>> > >> > <mailto:[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]>> > >> > <mailto:[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 > >> > > >> > > >> > > >> > > >> > > >> > >> > >> > > > > > > > > > > > > >
