R: iBATIS 3.0 selectOne SessionException if no data found

2009-08-28 Thread Davide Rogora
> Where I’d prefer to return null on 0, object for 1 and then throw a TooManyObjects error > – the name of the error is irrelevant :) > This way a simple null test is all that is needed in non > exceptional circumstances. I agree with Zoran, this is the behaviour I would expect Davide. -

R: read large result set in Ibatis3

2010-02-25 Thread Davide Rogora
I agree with Martin. In my company we use iBatis and we appreciate both result mapping and dynamic SQL features, but sometimes we only need dynamic SQL with direct access to the underlying jdbc cursor. For instance... we use JasperReports for report generation (and dynamic queries are very usefu

R: read large result set in Ibatis3

2010-02-26 Thread Davide Rogora
> Also, the JasperReports example mentioned earlier in the thread could be part of a > batch process for all we know. > The point is: not every application is a web application. You're right. We have no problem using iBatis on the web part of our application because usually on the "interactive" si

R: iBATIS Survey (10 Minutes)

2007-07-09 Thread Davide Rogora
My company proxy prevents me to use port 81. Is it possible tu put the survey on port 80? Thanks! Davide. -Messaggio originale- Da: Clinton Begin [mailto:[EMAIL PROTECTED] Inviato: domenica 8 luglio 2007 7.55 A: [EMAIL PROTECTED]; iBatis Java Mail List; [EMAIL PROTECTED] Oggetto: iBATIS

Reporting with iBatis

2007-11-26 Thread Davide Rogora
Hi, I'm developing an intranet web application with iBatis, and I'm very happy with it :-) Now, I'm starting to analyze which is the best way to integrate iBatis with the reporting tool we have chosen (JasperReports). As JasperReports manual says, a simple a quick way to fill a report is to execu

R: Reporting with iBatis

2007-11-27 Thread Davide Rogora
Larry, thanks for your reply. It's a pity that iBatis could not return a java.sql.resultset to be passed to JasperReports for the following reasons: 1) Now all the sql statements of our application are in sqlmap xml files 2) If we cannot use iBatis for the reports we cannot use the powerful featur

Need help with query metadata caching (remapResults)

2008-02-22 Thread Davide Rogora
Hi, we have the following problem with iBatis. Our application (web application using spring), in some cases does an automatic upgrade of the database (add and drop colums on varous tables); after this upgrade we have problems with iBatis, because iBatis by default remembers what fields were retur

R: Need help with query metadata caching (remapResults)

2008-02-22 Thread Davide Rogora
PROTECTED] Inviato: venerdì 22 febbraio 2008 15.20 A: user-java@ibatis.apache.org Oggetto: Re: Need help with query metadata caching (remapResults) I haven't tried this myself, but there must be a way to reinitialize the SqlMapClient - that would do it. Larry On Fri, Feb 22, 2008 at 3:03 AM, D

R: create table in a mapping file??

2008-07-07 Thread Davide Rogora
We create tables with iBatis tag and it works perfectly I.e.: CREATE TABLE [dbo].[FooTable] . Remember that if the table name contains # character, you have to escape it, otherwhise iBatis will treat it like a field placeholder. Davide. -Messaggio originale- Da:

Setters, gettes and public fields

2008-07-18 Thread Davide Rogora
; } public void setLastName(String lastName) { this.lastName = lastName; } } Do you think that the presence of both public field and getter and setter will cause problems to iBatis? Thanks, Davide. - Davide Rogora Unione Fiduciaria S.p.A. - Società Fiduciaria e di Servizi delle Banche

R: Setters, gettes and public fields

2008-07-18 Thread Davide Rogora
gn and I can't imagine why on earth you'd want to do something like that... :-) Clinton On Fri, Jul 18, 2008 at 8:32 AM, Davide Rogora <[EMAIL PROTECTED]> wrote: Hi, my company is using iBatis for our web application and we are very happy with it. Actually in

url attribute of tag

2008-07-23 Thread Davide Rogora
ct way to use a relative path with the url attribute? Thanks, Davide. - Davide Rogora Unione Fiduciaria S.p.A. - Società Fiduciaria e di Servizi delle Banche Popolari Italiane Area Informatica via Olmetto, 1 20123 Milano Tel. 02 72.422.423 e-mail: [EMAIL PROTECTED] Le dichiarazioni contenu

R: url attribute of tag

2008-07-24 Thread Davide Rogora
t the SqlMapCientBuilder to see how to do that. FWIW, I wouldn't recommend this. It's extra work without a reward. Larry On Wed, Jul 23, 2008 at 7:18 AM, Davide Rogora <[EMAIL PROTECTED]> wrote: > Hi, > Actually my iBatis xml config files are under the classpath so, to incl

R: iBatis AS/400 journaling STRJRNPF

2008-10-27 Thread Davide Rogora
I think it'not an iBatis issue but a "transactional" issue. If you want to use transactions on AS/400 you have to put the files under journaling. We usually create libraries with the SQL command "CREATE COLLECTION" instead of traditional AS/400 command "CRTLIB". The "CREATE COLLECTION" sql instr

Pattern for multiple database

2006-03-23 Thread Davide Rogora
Hi all, my company is starting a new data-centric application that should be database-indipendent (e.g. work with MySql, Oracle, SQL-Server, DB2 ecc.). We don't want to use Hibernate because we used it in the past e we dont' like it. I've found iBATIS, read the documentation and I like it

R: Pattern for multiple database

2006-03-23 Thread Davide Rogora
but have not had enough people who needed it to address it. If we do fix it, we will most likely make a way to define which mapped statement to use when there are duplicates. Larry On 3/23/06, Davide Rogora <[EMAIL PROTECTED]> wrote: Hi all, my company is starting

Survey - do you use Abator?

2006-04-04 Thread Davide Rogora
Hi, I'm new to iBATIS and I'm going to start a new application for my company using it.   One of my last doubt is: "Should I use Abator to generate sqlmap files and classes?" I have this doubt because I saw that JPetStore application has been developed without using Abator.   Do you have a