Re: From Ibatis-2- to Ibtais-3-

2009-09-08 Thread faresz
I have a table with more than 1000 records, i used the ibatis queryList method the returned collection has always 1000 records only, the old version of ibatis was retrieving all the data from the database. Did i miss something, or this is the case of the new version? Clinton Begin wrote: > >

Re: Query List limitation

2009-09-08 Thread faresz
I have no error messages but this problem will affect our business, i have some process that need to retrieve all the existing data that may be more than 1000 records (Already we have this case) Kai Grabfelder-3 wrote: > > do you have any error message or stacktraces? > > --- Original Nachric

Re: IBatis + Stored Procedures

2009-09-08 Thread jimmymac
This is about all I can get from the logging. Executing Statement: {call HTE60PGM.KLSCCAPI(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} {pstm-100016} Parameters: [HTE60PGM, HTE60QUA1, HT, , , , , , A, , 0, 0, BNK, SWIP, 0, 0, , , CR

Re: IBatis + Stored Procedures

2009-09-08 Thread Nathan Maves
any chance you also have the logging output where the sql generated by ibatis? On Tue, Sep 8, 2009 at 8:36 AM, jimmymac wrote: > > It's choking on the lastname value being read off a magnetic strip. Here is > the relevant portion of the map > Here is the parameter map: > id="SwipedCreditCard_pr

Re: Query List limitation

2009-09-08 Thread Kai Grabfelder
do you have any error message or stacktraces? --- Original Nachricht --- Absender: faresz Datum: 08.09.2009 09:52 > In the older version, list queries could retrieve more than 1,000 records. in > iBatis 3 we are not able to retrieve more than 1000 records. This will cause > a problem in case we ne

Re: IBatis + Stored Procedures

2009-09-08 Thread jimmymac
It's choking on the lastname value being read off a magnetic strip. Here is the relevant portion of the map Here is the parameter map: .. ... And the exception: [2009-09-03 13:20:28,502] [http-80-Processor25] [ERROR] - [IBatisStoredProcDAO.insert] [failed

Re: IBatis + Stored Procedures

2009-09-08 Thread Nathan Maves
Post your parameter map and the actual exception you are getting. On Tue, Sep 8, 2009 at 7:59 AM, jimmymac wrote: > > I seem to be having an issue with mapping and stored procedures. I'm > passing > in a value " O'Malley ". Shouldn't the use of a prepared statement handle > the apostrophe? The A

RE: Property/Field resolution order

2009-09-08 Thread Gustavo Henrique Sberze Ribas
> Does anyone actually care if iBATIS uses getter/setters instead of fields directly? I don't care, as long as it keeps support to java beans getters/setters or implement some sort of column to method mapping like Brandon suggested. We have a special float point data array stored as a blob in

IBatis + Stored Procedures

2009-09-08 Thread jimmymac
I seem to be having an issue with mapping and stored procedures. I'm passing in a value " O'Malley ". Shouldn't the use of a prepared statement handle the apostrophe? The API is returning a message of invalid character O' from the DB2 database. [code] {call ${sp.lib}.KLSCCAPI(?, ?, ?, ?,

Re: From Ibatis-2- to Ibtais-3-

2009-09-08 Thread Clinton Begin
Please don't double post... you already had posts for each of these. Also avoid aggregate posts like this, as the thread will have too many topics. On Tue, Sep 8, 2009 at 1:47 AM, faresz wrote: > > We are in the process of testing the new version of Ibatis 3.0 Beta and we > are facing the follow

Re: Mapping new syntax

2009-09-08 Thread Clinton Begin
+1 -- person with the greatest need should write this tool. Clinton On Tue, Sep 8, 2009 at 6:41 AM, Jeff Butler wrote: > You have some options... > > If iBATIS2 is working well for you, then you might decide to stay with it. > > Otherwise, you could probably write an XSL transform that would d

Re: From Ibatis-2- to Ibtais-3-

2009-09-08 Thread Clinton Begin
iBATIS 3 doesn't limit you to 1000 records... where is this limitation coming from? Clinton On Tue, Sep 8, 2009 at 2:41 AM, faresz wrote: > > Hello man, > I was testing the new ibatis version and in some cases in our application > and for some business it recommends to gather all available data

Re: Mapping new syntax

2009-09-08 Thread Jeff Butler
You have some options... If iBATIS2 is working well for you, then you might decide to stay with it. Otherwise, you could probably write an XSL transform that would do the migration automatically. You might spend less time writing the XSL than on manually migrating the XML - and then you could co

RE: Problem with connecting

2009-09-08 Thread meindert
Depends on your datasource... I'm using spring so it's in my spring.xml -Original Message- From: Odelya YomTov [mailto:ode...@jpost.com] Sent: 08 September 2009 02:17 PM To: user-java@ibatis.apache.org Subject: RE: Problem with connecting Hi! To which file would you add it? -Origin

Re: Mapping new syntax

2009-09-08 Thread faresz
Yes i know but we have a huge application with thousands of queries :S So should we loose time by reconstructing all these queries??? Jeff Butler-2 wrote: > > The old syntax is gone. The new syntax is like this: > > > ... > > > iBATIS now uses OGNL for expressions - it's much more pow

Re: Mapping new syntax

2009-09-08 Thread Jeff Butler
The old syntax is gone. The new syntax is like this: ... iBATIS now uses OGNL for expressions - it's much more powerful than the old tags. Jeff Butler On Tue, Sep 8, 2009 at 2:49 AM, faresz wrote: > > Does iBatis3 support the old syntax of iBatis 2 like if not > so the migration from ver

RE: Problem with connecting

2009-09-08 Thread Odelya YomTov
Hi! To which file would you add it? -Original Message- From: meindert [mailto:meind...@eduflex.com] Sent: Tuesday, September 08, 2009 2:52 PM To: user-java@ibatis.apache.org Subject: RE: Problem with connecting I would add the validationQuery to the datasource, not sure if it helps in yo

RE: Problem with connecting

2009-09-08 Thread meindert
I would add the validationQuery to the datasource, not sure if it helps in your case though; That would validate old connections before using them. Here is my datasource setup;

problems with collection element

2009-09-08 Thread araoko
i have a problem with the collection element, i cant get it to populate ArraList properties on my POJO. i can instantiate the pojo using the constructor element but the collection element did not work. the mapper configuration xml is below, and folowing it is my POJO select a.name as nam

Problem with connecting

2009-09-08 Thread Odelya YomTov
Hi! Once a day I get the following message: javax.servlet.ServletException: Failed to execute queryForObject - id [getUserByNameAndPassword], parameterObject [il.co.yalkut.data.userd...@4d8d50]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in il/co/yalkut

Re: From Ibatis-2- to Ibtais-3-

2009-09-08 Thread faresz
Hello man, I was testing the new ibatis version and in some cases in our application and for some business it recommends to gather all available data that it could be more than 1000 Sameeh Harfoush wrote: > > Fares man, > you need to add in your post some server stack trace and error logs..

Re: From Ibatis-2- to Ibtais-3-

2009-09-08 Thread Sameeh Harfoush
Fares man, you need to add in your post some server stack trace and error logs.. why you need to load more than 1000 records ? Sameeh Harfoush On Tue, Sep 8, 2009 at 10:47 AM, faresz wrote: > > We are in the process of testing the new version of Ibatis 3.0 Beta and we > are facing the following

Query List limitation

2009-09-08 Thread faresz
In the older version, list queries could retrieve more than 1,000 records. in iBatis 3 we are not able to retrieve more than 1000 records. This will cause a problem in case we need to get more records and this case is very common. Is there any possible fix for this problem? -- View this message

Class not found in Query Mapping

2009-09-08 Thread faresz
In the previous version, we used to have the ibatis jar in the common domain libraries, no need for it to be in the level of the web application. In the new version we are obliged to include the ibatis jar in the same library folder of our internal jars to cache the Java classes in the mapping fil

Mapping new syntax

2009-09-08 Thread faresz
Does iBatis3 support the old syntax of iBatis 2 like if not so the migration from version 2 to 3 will affect all our mapping/queries definitions and will cause a big overhead for the company. Is there any possibility to migrate without doing all the changes listed, or is there any tool that will

From Ibatis-2- to Ibtais-3-

2009-09-08 Thread faresz
We are in the process of testing the new version of Ibatis 3.0 Beta and we are facing the following problems: 1. Mapping Syntax changes like do not exist anymore in Ibatis 3 Beta The migration from version 2 to 3 Beta will affect all our mapping/query definitions and will cause a big ov