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
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
=
--
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.
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
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
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
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
, 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
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
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
: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
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
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
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
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
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
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
>
> 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
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
eger" mode="OUT"/>
> jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
> jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
>
>
> parameterMap="getConfigParmData
.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.
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
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
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
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
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
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:
>
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
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
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
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.
*
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
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
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
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
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
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
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'
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
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
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/
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-
> &
> 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:
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
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
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
?
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
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
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
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
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
>
>
> 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.
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
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
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
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:
> > > >
> > > > >
> > > > >
> > > > >
> > > > >
&
>
> > >
> > >
> > > On Dec 13, 2007 7:38 PM, Brian Parkinson <[EMAIL PROTECTED]> wrote:
> > >
> > > >
> > > >
> > > >
> > > >
> > > > Hi Stefano:
> > > >
> > > >
> > > > Just put that magic line right above the meth
; parki...
> > >
> > >
> > >
> > >
> > > --
> > >
> > > *From:* Stefano Tranquillini [mailto: [EMAIL PROTECTED]
> > > *Sent:* Thursday, December 13, 2007 12:37 PM
> > > * To:* user-java@ibatis
>
> >
> > parki...
> >
> >
> >
> >
> > --
> >
> > *From:* Stefano Tranquillini [mailto:[EMAIL PROTECTED]
> > *Sent:* Thursday, December 13, 2007 12:37 PM
> > *To:* user-java@ibatis.apache.org
> > *
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
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
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
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_
> 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
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
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
: 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
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
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
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
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
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. ;-)
>
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
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
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
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:
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
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
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
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,
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
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
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.
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
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
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
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
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
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=
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
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
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
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
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
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
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
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
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
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
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 - 100 of 136 matches
Mail list logo