David, It works.
Thanks for the idea..Hope the Moderaters document this. Thanks, Vijay Khanna -----Original Message----- From: David Gagnon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 12:03 PM 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'm using Intellij to run my ant task. Here is my task. The problem is that you should add F:\java\ibatis2.1.7\src\ibatis-src.jar in the classpath (wich contain the xsl sheet). But adding it to convert.classpath doesn`t work!! So I add it directly in the additionnal librarie wich is the same thing than using : java -classpath ... <path id="convert.classpath"> <pathelement location="F:/java/ibatis2.1.7/src/toto.jar"/> <pathelement location="F:/java/ibatis2.1.7/lib/1-x-Compatibility/ibatis-sqlmap-1-x.jar"/> <pathelement location="F:/java/ibatis2.1.7/lib/ibatis-sqlmap-2.jar"/> <pathelement location="F:/java/ibatis2.1.7/lib/ibatis-common-2.jar"/> </path> <taskdef name="convertSqlMaps" classname="com.ibatis.db.sqlmap.upgrade.ConvertTask" classpathref="convert.classpath"/> <target name="convert"> <convertSqlMaps todir="F:\projects\conversion" overwrite="true"> <fileset dir="F:\projects\applicationServer"> <include name="**/*Dao_sql-map*.xml"/> </fileset> </convertSqlMaps> </target> Hope that help Regards /David Khanna, Vijay (GE, Corporate, consultant) wrote: > 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 >> >> > >> >> > >> >> > >> >> > >> >> > >> >> >> >> >> >> >> > >> > >> > >> > >> > >> >> >> >> > > > > > >
