Re: iBatis queryforList not working for dynamic Stored Proc

2009-12-07 Thread abdesai
44) >> at >> org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27) >> at >> org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37) >> at >> org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner

Re: iBatis queryforList not working for dynamic Stored Proc

2009-11-02 Thread Jeff Butler
at > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) > at > org.eclipse.jdt.intern

iBatis queryforList not working for dynamic Stored Proc

2009-11-02 Thread abdesai
= -- View this message in context: http://old.nabble.com/iBatis-queryforList-not-working-for-dynamic-Stored-Proc-tp26157123p26157123.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-03 Thread Larry Meadors
t; > >> > http://www.mail-archive.com/user-java@ibatis.apache.org/msg13636 >> > >> > >> > >> > Just a note, the XML returned from ibatis is quite limited, I personally >> > use >> > XStream to serialize java beans  to XML (or JSON) and bac

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread Fred Janon
N) and back to java beans > > > > > > > > meindert > > > > From: Fred Janon [mailto:fja...@gmail.com] > > Sent: 02 July 2009 09:53 AM > > To: user-java@ibatis.apache.org > > Subject: Re: queryForObject/queryForList where is the documentation for

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread Larry Meadors
t; > From: Fred Janon [mailto:fja...@gmail.com] > Sent: 02 July 2009 09:53 AM > To: user-java@ibatis.apache.org > Subject: Re: queryForObject/queryForList where is the documentation for the > "Object parameter"? > > > > Thanks. It seems though that there are mor

RE: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread meindert
uite limited, I personally use XStream to serialize java beans to XML (or JSON) and back to java beans meindert From: Fred Janon [mailto:fja...@gmail.com] Sent: 02 July 2009 09:53 AM To: user-java@ibatis.apache.org Subject: Re: queryForObject/queryForList where is the documentation for the &q

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread Fred Janon
, or $id$ and $description$ if you want to do a literary > replacement. > > > > > > *From:* Fred Janon [mailto:fja...@gmail.com] > *Sent:* 02 July 2009 05:59 AM > *To:* user-java@ibatis.apache.org > *Subject:* queryForObject/queryForList where is the documentation for the > &quo

RE: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-01 Thread meindert
these parameters like #id# and #description#, or $id$ and $description$ if you want to do a literary replacement. From: Fred Janon [mailto:fja...@gmail.com] Sent: 02 July 2009 05:59 AM To: user-java@ibatis.apache.org Subject: queryForObject/queryForList where is the documentation for the &quo

queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-01 Thread Fred Janon
Sorry for the basic question: how to write a query with mutiple parameters? I am reading the iBatis in Action book, browsing the distribution, the wiki, the Javadoc and I can't find documentation or examples for the different forms of the parameter for queryForObject or queryFo

Re: Error with ibatis runing queryForList

2008-10-22 Thread Ashish Kulkarni
:55:33 -0400 > From: [EMAIL PROTECTED] > To: user-java@ibatis.apache.org > Subject: Error with ibatis runing queryForList > > Hi > > I am gettig following error when trying to sqlSession.queryForList() > > > > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransact

RE: Error with ibatis runing queryForList

2008-10-22 Thread Yamil Bracho
Would you mind to us your mapping and java code.. ? Date: Wed, 22 Oct 2008 15:55:33 -0400 From: [EMAIL PROTECTED] To: user-java@ibatis.apache.org Subject: Error with ibatis runing queryForList Hi I am gettig following error when trying to sqlSession.queryForList

Error with ibatis runing queryForList

2008-10-22 Thread Ashish Kulkarni
Hi I am gettig following error when trying to sqlSession.queryForList() com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:776) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:141) at com.ibatis.sqlmap.engin

RE: queryForList()

2008-10-17 Thread Poitras Christian
That is, unfortunately, dependent on your database. On MySQL it would look like this. SELECT * FROM SomeTable LIMIT skipCount, maxCount Limiting number of results in the queryForList can force your database to return all 10198 records (depending on java connector) even if iBATIS will remove

Re: queryForList()

2008-10-17 Thread John Chien
in queryForList. Some connectors don't use maximum count to limit the number of results sent from the database. In these cases limiting number of results in the SQL statement is your only choice. I would go with solution 1 unless you cannot use a RowHandler. Christian -Original Me

RE: queryForList()

2008-10-17 Thread Poitras Christian
It would be better if your code would do one of the following. 1) Use a RowHandler. This is optimized for these kind of queries. 2) Use maxCount in your SQL statement and not in queryForList. Some connectors don't use maximum count to limit the number of results sent from the database. In

queryForList()

2008-10-17 Thread John Chien
Dear Sir: I used the SQLMAP' s API queryForList to get data back from database. There are many data in database, so I the one that has four input parameters. The SQLMAP XML syntax should return me 10198 records, if runs without loop. I have already tested this by plugin the values. Ho

Re: Ibatis queryForList in Sybase Database

2008-06-26 Thread prabho
> > 06/25/2008 04:25 PM > Please respond to > user-java@ibatis.apache.org > > > To > user-java@ibatis.apache.org > cc > > Subject > Ibatis queryForList in Sybase Database > > > > > > > > Hi all, > > When I am trying to execu

Re: Ibatis queryForList in Sybase Database

2008-06-26 Thread Christopher . Mathrusse
ED]> 06/25/2008 04:25 PM Please respond to user-java@ibatis.apache.org To user-java@ibatis.apache.org cc Subject Ibatis queryForList in Sybase Database Hi all, When I am trying to execute a stored procedure in Sybase Database, it is failing, if the entry is not present in the DB ta

Re: Ibatis queryForList in Sybase Database

2008-06-26 Thread Gwyn Evans
eger" mode="OUT"/> > jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> > jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/> > > > parameterMap="getConfigParmData

Ibatis queryForList in Sybase Database

2008-06-25 Thread prabho
.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) Can anyone, let me know how to fix this issue?? Regards Prabhu -- View this message in context: http://www.nabble.com/Ibatis-queryForList-in-Sybase-Database-tp18123663p18123663.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: queryForList with multiple parametrs

2008-03-30 Thread Nedda Kaltcheva
dzizes wrote: > > Hi, > > I was wandering how queryForList with 2 (or more) parameters. Below my > select in sqlmap.xml > > > SELECT A, B > FROM tableAB > WHERE A = '14' AND B = '01' > > > List respons

RE: queryForList with multiple parametrs

2008-03-28 Thread Jason Kratz
You either have to pass in a parameter map or a class. This is well documented in the user guide. -Original Message- From: dzizes [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 10:18 AM To: user-java@ibatis.apache.org Subject: queryForList with multiple parametrs Hi, I was

queryForList with multiple parametrs

2008-03-28 Thread dzizes
Hi, I was wandering how queryForList with 2 (or more) parameters. Below my select in sqlmap.xml SELECT A, B FROM tableAB WHERE A = '14' AND B = '01' List responseList = sqlMap.queryForList("getAB", "?", "?"); Plea

RE: Re: Question about queryForList and Oracle ref cursors

2008-03-11 Thread Jesse Reimann
Ok thanks to everyone for the info. I've switched over to using the update method since it is the correct usage. I thought it might be something like that but wasn't sure since I was able to use queryForList when passing in the HashMap. I did notice as Sundar mentioned that with the H

RE: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Jason Bennett
user-java@ibatis.apache.org Subject: Re: Re: Question about queryForList and Oracle ref cursors Jason, This is what you will have to do, 1. Map an object to the columns being returned from the cursor in your sq-map-config file. i.e you should have an entry like this 2. You would h

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Sundar Sankar
st of the how to do it. I am again reiterating the point that queryForList doesnt work for SP's. It returns a list only for queries. The result of SP is in the map that you passed. I hope I have helped. -S On Mon, Mar 10, 2008 at 6:13 PM, Jason Bennett <[EMAIL PROTECTED]> wrote: >

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Jeff Butler
queryForList only works for things that return result sets. Oracle ref cursors are a "sort of" result set, but the ref cursor is a *parameter* to a callable statement, rather than being *returned from* the stored proc. This is an important difference. Because of this, iBATIS (and

RE: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Jason Bennett
One problem I had in this scenario is when I pass parameters to the function, and expect a cursor back. I had to map the returning parameter, since I had mapped all the in parameters. This prevented me from using queryForList() as I wanted to. Am I doing anything wrong, or does passing parameters

RE: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Sundar Sankaranarayanan
Jesse, I don't think the query for list makes much of an impact in calling stored procedures. U will have to do a inputMap.get("resultParameter) to get the output. The surprising thing is the map is loaded, if you call queryForList or update or any of the methods. I really

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Jesse Reimann
Ryan I guess you didn't read my original post. I tried both the Hashmap method of queryForList and the way you suggested. The only way I can actually get a populated List back is using the HashMap. If I do it this way : return getSqlMapClientTemplate().queryForList("TEST_TESTPROC.

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Ryan Shelley
* queryForList()* or *queryForObject()*. Use queryForList() if you expect more than one result object, or queryForObject() if you expect only one result Object. ... If your procedure does not return result sets, or only returns result sets in OUT parameters, then use the *update()* method. -Ryan On

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Ryan Shelley
In the one you had, you were creating an empty HashMap, executing the queryForList method passing in the empty HashMap, and then converting the still empty HashMap to a list and returning that to your method. queryForList doesn't take an object parameter to store the results in, it takes an o

RE: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Jesse Reimann
Ryan that's exactly what I did that wouldn't work. It returns to me a List that has 10 elements all which are NULL. Jesse

Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Ryan Shelley
Try: *public* List selectCDDRpt() { return getSqlMapClientTemplate().queryForList("TEST_TESTPROC.GET_CDDRPT"); } You're returning a list of rows, no extra work is required. Use the Hashmap if you need to pass values INTO the stored procedure. -Ryan On Mon, Mar 10, 2008 at

Question about queryForList and Oracle ref cursors

2008-03-10 Thread Jesse Reimann
I've successfully been able to use iBATIS to retrieve and map data from an Oracle ref cursor using the examples posted on the Wiki. I do have a questions about queryForList(string) method. I can retrieve my List successfully if my dao code looks like this: public List selectC

RE: queryForList/Map/Object... rollbacks

2008-03-07 Thread Clinton Begin
the next example. >> Both queryForObject and queryForList start their own transaction. Right? >> Creating and tearing down transactions are expensive Yes. So it's actually both _faster_ and _safer_ to explicitly demarcate a separate transaction like: try { sq

Re: queryForList/Map/Object... rollbacks

2008-03-07 Thread Michael Schall
ject(select count(*) from categories;) > > List list = sqlmap.queryForList(select * from categories;) > Both queryForObject and queryForList start their own transaction. Right? > > > Creating and tearing down transactions are expensive, and most cases (for > me at least) don'

Re: queryForList/Map/Object... rollbacks

2008-03-05 Thread Michael Schall
elect count(*) from categories;) List list = sqlmap.queryForList(select * from categories;) Both queryForObject and queryForList start their own transaction. Right? Creating and tearing down transactions are expensive, and most cases (for me at least) don't need this type of isolation. I would like to opt in

RE: queryForList/Map/Object... rollbacks

2008-03-05 Thread Clinton Begin
ope. Clinton From: Michael Schall [mailto:[EMAIL PROTECTED] Sent: March-05-08 10:49 AM To: user-java@ibatis.apache.org Subject: Re: queryForList/Map/Object... rollbacks I saw the commitRequired, but why are we creating the transaction in the first place? Or is this a Sybase requirement that t

RE: queryForList/Map/Object... rollbacks

2008-03-05 Thread Clinton Begin
riginal Message- From: Christopher Lamey [mailto:[EMAIL PROTECTED] Sent: March-05-08 10:45 AM To: user-java@ibatis.apache.org Subject: Re: queryForList/Map/Object... rollbacks Doh! Forgot about "commitRequired" - been using Spring for everything lately. Sorry about that. On 3/

Re: queryForList/Map/Object... rollbacks

2008-03-05 Thread Michael Schall
lbacks. If it was already set to false, it is entirely > > possible that SimpleDataSource was entirely responsible for the > aggressive > > rollbacks -- thus we should probably make that configurable too. > > > > Clinton > > > > -Original Message- > &

Re: queryForList/Map/Object... rollbacks

2008-03-05 Thread Christopher Lamey
> possible that SimpleDataSource was entirely responsible for the aggressive > rollbacks -- thus we should probably make that configurable too. > > Clinton > > -Original Message- > From: Christopher Lamey [mailto:[EMAIL PROTECTED] > Sent: March-04-08 5:07 PM > To:

Re: queryForList/Map/Object... rollbacks

2008-03-05 Thread Michael Schall
I would like to make this configurable by adding a property and code something like the following... Thoughts? Mike public List queryForList(SessionScope sessionScope, String id, Object paramObject, int skip, int max) throws SQLException { List list = null; MappedStatement ms

RE: queryForList/Map/Object... rollbacks

2008-03-04 Thread Clinton Begin
h-04-08 5:07 PM To: user-java@ibatis.apache.org Subject: Re: queryForList/Map/Object... rollbacks That is not the default iBATIS behavior, I'm guessing your container is getting involved. >From what I understand, the SIMPLE datasource type is generally for standalone programs, not for apps

Re: queryForList/Map/Object... rollbacks

2008-03-04 Thread Christopher Lamey
is this default behavior of iBatis to create a transaction and roll > it back for even a select? > > > > Would JTA change this? > > > > Thanks, > > Tom > > > > > > -Original Message- > From: Jeff Butler [mailto:[EMAIL P

RE: queryForList/Map/Object... rollbacks

2008-03-04 Thread Tom Henricksen
? Would JTA change this? Thanks, Tom -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 3:53 PM To: user-java@ibatis.apache.org Subject: Re: queryForList/Map/Object... rollbacks What transaction manager are you using? Is this an EJB

Re: queryForList/Map/Object... rollbacks

2008-03-04 Thread Jeff Butler
de and could not find anything. Used p6spy and found > that every time queryForXXX is called I received a rollback. Stepping > through the queryForList code in SqlMapExecutorDelegate.java the > autoStartTransaction starts a transaction if none is present and since we > d

queryForList/Map/Object... rollbacks

2008-03-04 Thread Tom Henricksen
rollback. Stepping through the queryForList code in SqlMapExecutorDelegate.java the autoStartTransaction starts a transaction if none is present and since we don't have commitRequired set, the autoEndTransaction will cause a rollback. I assume there is a good reason to start the transaction

Re: queryForList returns only one row even though SQL query returns many

2008-01-11 Thread Stephen Boyd
l this > query > from a unit test, using queryForList(), it only returns one row. However > it > prints out the following to the console: > > 15:18:27,696 DEBUG PreparedStatement:27 - {pstm-11} Executing > Statement: > select distinct g.condition_group_id as i

queryForList returns only one row even though SQL query returns many

2008-01-11 Thread dandante
Hi, I have an IBATIS select query. I also have logging at the DEBUG level so I can see what queries are sent to my database (mysql). When I call this query from a unit test, using queryForList(), it only returns one row. However it prints out the following to the console: 15:18:27,696 DEBUG

Re: queryForList()

2007-12-21 Thread Koka Kiknadze
> > > It seems not give me what I expect as mentioned in the question. > Can not think of any explanation except that maybe you do not have an ORDER BY clause in your select, so that each time you execute queryForList the records are not returned in the same guaranteed order.

Re: queryForList()

2007-12-20 Thread John Chien
Yes. That's the reason I am asking the question. It seems not give me what I expect as mentioned in the question. Larry Meadors wrote: Did you try it? Larry On Dec 20, 2007 1:09 PM, John Chien <[EMAIL PROTECTED]> wrote: Question about : public List queryForList(String st

Re: queryForList()

2007-12-20 Thread Larry Meadors
Did you try it? Larry On Dec 20, 2007 1:09 PM, John Chien <[EMAIL PROTECTED]> wrote: > > Question about : > > public List queryForList(String statementName, Object parameterObject, > int skipResults, int maxResults) throws SQLException > > Suppose I have a list of 1

queryForList()

2007-12-20 Thread John Chien
Question about : public List queryForList(String statementName, Object parameterObject, int skipResults, int maxResults) throws SQLException Suppose I have a list of 1625 elements. The first time I call using queryForList(statementName, parameterObject, 0, 500) will give me

Re: QueryforList and Generics

2007-12-13 Thread Jeff Butler
this is valid for all? > > > > maybe in the bean or something else? > > > > bye > > > > > > > > > > > > > > > > > > > > > > > > On Dec 13, 2007 7:38 PM, Brian Parkinson <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > > > > > > > &

Re: QueryforList and Generics

2007-12-13 Thread Larry Meadors
> > > > > > > > > > On Dec 13, 2007 7:38 PM, Brian Parkinson <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > > > > > > Hi Stefano: > > > > > > > > > > > > Just put that magic line right above the meth

Re: QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
; parki... > > > > > > > > > > > > > > > -- > > > > > > *From:* Stefano Tranquillini [mailto: [EMAIL PROTECTED] > > > *Sent:* Thursday, December 13, 2007 12:37 PM > > > * To:* user-java@ibatis

Re: QueryforList and Generics

2007-12-13 Thread Jeff Butler
> > > > > parki... > > > > > > > > > > -- > > > > *From:* Stefano Tranquillini [mailto:[EMAIL PROTECTED] > > *Sent:* Thursday, December 13, 2007 12:37 PM > > *To:* user-java@ibatis.apache.org > > *

RE: QueryforList and Generics

2007-12-13 Thread Niels Beekman
One thing you could do is introduce a utility method that accepts an extra 'resultClass' argument, something like this: @SuppressWarnings("unchecked") public List queryForList(Class resultClass, String id, Object parameterObject) { return queryForList

Re: QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
t:* Thursday, December 13, 2007 12:37 PM > *To:* user-java@ibatis.apache.org > *Subject:* Re: QueryforList and Generics > > > > Where? > but, this is the only way to resolve? > there isn't a methtod to resolve it? > > On Dec 13, 2007 7:33 PM, Jeff Butler <[EM

RE: QueryforList and Generics

2007-12-13 Thread Brian Parkinson
Subject: Re: QueryforList and Generics Where? but, this is the only way to resolve? there isn't a methtod to resolve it? On Dec 13, 2007 7:33 PM, Jeff Butler <[EMAIL PROTECTED] > wrote: Add this annotation: @SuppressWarnings("unchecked") Jeff Butler On Dec 13, 2

Re: QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
PM, Stefano Tranquillini < > [EMAIL PROTECTED]> wrote: > > > Hi everybody. > > I've a problem. How i can resolve the warning when i try to do this: > > > > List contatti = null; > > contatti = > > sqlMap.getSqlMap().queryForList("get_Contatti_

Re: QueryforList and Generics

2007-12-13 Thread Jeff Butler
> contatti = > sqlMap.getSqlMap().queryForList("get_Contatti_from_Nome_Cognome_Questionario_aggiungi", > aq); > > the warning is: > found : java.util.List > required: java.util.List > > tnx > bye > > > -- > Stefano

QueryforList and Generics

2007-12-13 Thread Stefano Tranquillini
Hi everybody. I've a problem. How i can resolve the warning when i try to do this: List contatti = null; contatti = sqlMap.getSqlMap().queryForList("get_Contatti_from_Nome_Cognome_Questionario_aggiungi", aq); the warning is: found : java.util.List required: java.uti

RE: "No operations allowed after connection closed" occasionally when using queryForList

2007-05-31 Thread Meindert
fter connection closed" occasionally when using queryForList I have had this error with mysql, check to see that you are not creating more than one Sqlclient. Secondly you have lazy loading on so ensure you are not calling a get on mapped object outside of the transaction. -Origina

RE: "No operations allowed after connection closed" occasionally when using queryForList

2007-05-31 Thread James, Steven
: Donnerstag, 31. Mai 2007 16:51 To: user-java@ibatis.apache.org Subject: "No operations allowed after connection closed" occasionally when using queryForList Hi there, I'm using the code mentioned below (with try catches and such) and it seems to work fine 90% of the time. However, occas

"No operations allowed after connection closed" occasionally when using queryForList

2007-05-31 Thread CppPlease
tabase with 1 table. Also using mysql-connector-java-3.1.7-bin.jar. Help is much appreciated, Thanks in advance. -- View this message in context: http://www.nabble.com/%22No-operations-allowed-after-connection-closed%22-occasionally-when-using-queryForList-tf3846980.html#a10895483 Sent from

Re: QueryForList : How does maxRows work?

2007-05-14 Thread Clinton Begin
nt a few douzain. >> >> Clinton Begin wrote: >> > >> > PS: if it hasn't been made clear by my previous posts, if you call >> > queryForList with a maxRows attribute, it will only request that many >> rows >> > back from the database. I

Re: QueryForList : How does maxRows work?

2007-05-14 Thread BenBaril
want a few douzain. >> >> Clinton Begin wrote: >> > >> > PS: if it hasn't been made clear by my previous posts, if you call >> > queryForList with a maxRows attribute, it will only request that many >> rows >> > back from the database. It w

Re: QueryForList : How does maxRows work?

2007-05-13 Thread Clinton Begin
the cost of the bandwidth, as we don't want to get back 1000s of rows when we only want a few douzain. Clinton Begin wrote: > > PS: if it hasn't been made clear by my previous posts, if you call > queryForList with a maxRows attribute, it will only request that many rows > b

Re: QueryForList : How does maxRows work?

2007-05-13 Thread BenBaril
r by my previous posts, if you call > queryForList with a maxRows attribute, it will only request that many rows > back from the database. It won't bring back all 10k. This of course > depends on the driver, but I've never seen one that does something that > silly. ;-) >

Re: QueryForList : How does maxRows work?

2007-05-11 Thread Clinton Begin
PS: if it hasn't been made clear by my previous posts, if you call queryForList with a maxRows attribute, it will only request that many rows back from the database. It won't bring back all 10k. This of course depends on the driver, but I've never seen one that does somet

Re: QueryForList : How does maxRows work?

2007-05-11 Thread Clinton Begin
rove performance for you, we can probably add it. If so, > please > open a JIRA ticket for it. > > Clinton > > On 5/10/07, BenBaril <[EMAIL PROTECTED]> wrote: >> >> >> I'm wondering on how the implementation of maxRows works when calling >> q

Re: QueryForList : How does maxRows work?

2007-05-10 Thread BenBaril
pose we're well past that now. If you > think > it will improve performance for you, we can probably add it. If so, > please > open a JIRA ticket for it. > > Clinton > > On 5/10/07, BenBaril <[EMAIL PROTECTED]> wrote: >> >> >> I'm won

Re: QueryForList : How does maxRows work?

2007-05-10 Thread Clinton Begin
il <[EMAIL PROTECTED]> wrote: I'm wondering on how the implementation of maxRows works when calling queryForList. Does it execute a stmt.setMaxRows(maxRows); or does it receive all the rows from the database, parse then trim? Thanks, Benjamin Baril -- View this message in context:

QueryForList : How does maxRows work?

2007-05-10 Thread BenBaril
I'm wondering on how the implementation of maxRows works when calling queryForList. Does it execute a stmt.setMaxRows(maxRows); or does it receive all the rows from the database, parse then trim? Thanks, Benjamin Baril -- View this message in context: http://www.nabble.com/QueryForList-%3

queryForList() - skip, max

2007-01-06 Thread Tegan Clark
Guys, I'm digging in the 2.2.0.638 code to enhance it to allow for a queryForIterator() method on the SqlMapExecuter interface and I think I might have found a small bug. The queryForList() with the skip and max specified doesn't seem to work when the ResultSet is returned

Re: Cached list from queryForList() ...

2006-11-15 Thread Eric Tan
a copy of the cached object and modifications are made to this copy and not the cached object. Regards, Eric - Original Message From: Eric Tan <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Wednesday, 8 November 2006 12:26:15 AM Subject: Re: Cached list from queryF

Re: Cached list from queryForList() ...

2006-11-07 Thread Eric Tan
read/write cache works?Thanks,Eric- Original Message From: Larry Meadors <[EMAIL PROTECTED]>To: user-java@ibatis.apache.orgSent: Monday, 6 November 2006 11:29:55 PMSubject: Re: Cached list from queryForList() ...Yes: Make sure that the cache is not marked as read-only.LarryOn 11/6/06,

Re: Cached list from queryForList() ...

2006-11-06 Thread Larry Meadors
Yes: Make sure that the cache is not marked as read-only. Larry On 11/6/06, Eric Tan <[EMAIL PROTECTED]> wrote: Hi, I was testing Spring Acegi Security's AfterInvocationProviderManager which deals with domain object instance security (ACL). With ibatis caching enabled and queryF

Cached list from queryForList() ...

2006-11-06 Thread Eric Tan
Hi,I was testing Spring Acegi Security's AfterInvocationProviderManager which deals with domain object instance security (ACL). With ibatis caching enabled and queryForList(), I realised that returned result list was the actual cached list. With AfterInvocationProviderManager performing o

Re: groupBy with queryForList with skip and max

2006-09-18 Thread Javier Urbaneja
Thank you very much, Larry.On 9/18/06, Larry Meadors <[EMAIL PROTECTED]> wrote: Yes, it is skipped rows.LarryOn 9/18/06, Javier Urbaneja <[EMAIL PROTECTED]> wrote:> It seems (for the results i'm getting now) that in> " > queryForList(java.lang.String id,>  java.

Re: groupBy with queryForList with skip and max

2006-09-18 Thread Larry Meadors
Yes, it is skipped rows. Larry On 9/18/06, Javier Urbaneja <[EMAIL PROTECTED]> wrote: It seems (for the results i'm getting now) that in " queryForList(java.lang.String id, java.lang.Object parameterObject, int skip, int max) Executes a mapped SQL SELECT statement that

groupBy with queryForList with skip and max

2006-09-18 Thread Javier Urbaneja
It seems (for the results i'm getting now) that in"queryForList(java.lang.String id, java.lang.Object parameterObject, int skip, int max)Executes a mapped SQL SELECT statement that re

Re: "queryForList" problem

2006-09-13 Thread Nathan Maves
You need to specify your resultClass as string and then call queryForList On 9/13/06, Okan Çetin <[EMAIL PROTECTED]> wrote: Hi all; I want to get some data from database that using ibatis The code: Integer user_id=usr.getuser_id (); List list=sqlMapper.queryForList("getEventidFro

Re: "queryForList" problem

2006-09-13 Thread Jeff Butler
Set your resultClass to java.lang.Integer.  With your current setup, you are asking iBATIS to return a List of Lists.   Jeff Butler  On 9/13/06, Okan Çetin <[EMAIL PROTECTED]> wrote: Hi all;I want to get some data from database that using ibatisThe code:Integer user_id=usr.getuser_id ();List list

Re: "queryForList" problem

2006-09-13 Thread Larry Meadors
Make it resultClass="java.lang.String" or resultClass="string" instead. Larry On 9/13/06, Okan Çetin <[EMAIL PROTECTED]> wrote: Hi all; I want to get some data from database that using ibatis The code: Integer user_id=usr.getuser_id (); List list=sqlMapper.queryForList("getEventidFromAttend

"queryForList" problem

2006-09-13 Thread Okan Çetin
Hi all;I want to get some data from database that using ibatisThe code:Integer user_id=usr.getuser_id ();List list=sqlMapper.queryForList("getEventidFromAttendance",user_id); And the xml file is:..     select event_id from PUBLIC.attendance    where user_id = #user_id#  ..The problem:String sample=

Re: queryForList is returning a List of Lists?

2006-08-18 Thread Kevin Pauli
the two tables and retrieve LandAnimals by number of feet:            SELECT * FROM animals, land_animals         WHERE animal_id = land_animal_id AND num_feet = #value#     For some reason I cannot fathom, queryForList("getLandAnimalByNumberOfFeet", 4) is returning a List of Lists of

Re: queryForList is returning a List of Lists?

2006-08-18 Thread Jeff Butler
    WHERE animal_id = land_animal_id AND num_feet = #value#     For some reason I cannot fathom, queryForList("getLandAnimalByNumberOfFeet", 4) is returning a List of Lists of LandAnimals, instead of just a List of LandAnimals.  And queryForObject() returns a List of LandAnimals, inste

queryForList is returning a List of Lists?

2006-08-18 Thread Kevin Pauli
T * FROM animals, land_animals         WHERE animal_id = land_animal_id AND num_feet = #value#     For some reason I cannot fathom, queryForList("getLandAnimalByNumberOfFeet", 4) is returning a List of Lists of LandAnimals, instead of just a List of LandAnimals.  And queryForObject() returns a

Re: Urgent help needed -- queryForList() problem

2006-07-21 Thread Nathan Maves
Could use please post your sqlMap query and result map. On Jul 21, 2006, at 9:57 AM, [EMAIL PROTECTED] wrote:     Hi,      In my application I am using Ibatis as datamapper and firebird as the backend.   In my database, I have 10 records and I want to get first 5 of them.   Here I am using    

Urgent help needed -- queryForList() problem

2006-07-21 Thread rambabu.piridi
    Hi,      In my application I am using Ibatis as datamapper and firebird as the backend.   In my database, I have 10 records and I want to get first 5 of them.   Here I am using sqlMap.queryForList("getUsersList", null, 0, 5) to retrive the first 5 records from the databas

Re: Warnings at queryForList

2006-04-08 Thread Enrique Ferreyra
I think this thread answer why the annotation (SuppressWarnings) is necessary, in general :) Thanks Ben Munat escribió: duh... good point... boundaries between libraries and app code is one place where generics really get annoying... that and typing the damn types over and over. b Jeff Bu

Re: Warnings at queryForList

2006-04-07 Thread Ben Munat
duh... good point... boundaries between libraries and app code is one place where generics really get annoying... that and typing the damn types over and over. b Jeff Butler wrote: On a side note to the ibatis devs, what's the road map for having ibatis query methods return type-specific col

Re: Warnings at queryForList

2006-04-07 Thread Jeff Butler
On a side note to the ibatis devs, what's the road map for having ibatis query methods return type-specific collections? Will you ever do so (since that would break backwards compatibility, right?)?   It's not just a backwards compatibility problem...   The problem with iBATIS returning type speci

Re: Warnings at queryForList

2006-04-07 Thread Ben Munat
You should be able to suppress the warnings by adding the annotation "@SuppressWarnings("unchecked")" on the methods that use raw Collections. You could also put the return value of queryForList in a raw List (no generics) and then copy those items into a type-specific

Re: Warnings at queryForList

2006-04-07 Thread Enrique Ferreyra
on; -Xlint This field can be found under Project Properties=>Build=>Compiling MEINDERT -Original Message- From: Enrique Ferreyra [mailto:[EMAIL PROTECTED] Sent: 07 April 2006 01:19 PM To: user-java@ibatis.apache.org Subject: Warnings at queryForList Maybe this is a more java lagua

RE: Warnings at queryForList

2006-04-07 Thread Meindert
PM To: user-java@ibatis.apache.org Subject: Warnings at queryForList Maybe this is a more java laguage question than ibatis, but someone can tell me how to avoid this warnings ? Not suppressing them, doing the things fine. C:\svnjava\ccem-base\src\com\ccem\megatone\base\LegajoPick.java:144: warning: [unch

  1   2   >