You will need a result map (as you do, but just mentioning it because it is
required) and queryForMap as Larry said:
Map result = (Map)
queryForMap("getProperties", null, "propName", "propValue");
SELECT PropName, PropValue FROM Properties
-Original M
Use $this$ instead of #this# and you'll get subsitution instead of
parameterization - but be careful, you are responsible for all
escaping and type conversion, and opening yourself up to SQL
injection. Unless you are VERY sure that you need to do this...look
for a better solution.
Larry
On 5/10
http://ora-00911.ora-code.com/
My guess is that $schema$ is not defined.
Larry
On 5/10/07, Nguyen Trong Hoan <[EMAIL PROTECTED]> wrote:
Hi all,
In my project I use ibatis, but while executing sql statement
"getNoticeFromAdmin", I've got the following error:
Error executing query for object
Hi all,
In my project I use ibatis, but while executing sql statement
"getNoticeFromAdmin", I've got the following error:
Error executing query for object. Cause: syntax error or access rule
violation - Statement id (getNoticeFromAdmin). More detail:
--- The error occurred in
jp/imagecity/
We have a query that is running very slow when running through iBatis
against DB2. If we pull that query and run through Aqua Data studio
with raw SQL (w/o bind variables) it runs fast. It seems that DB2 is
picking a different query plan with the bind variables then when we use
raw SQL. We even
I'm working with a small team doing a Proof of Concept at a customer
location. We're looking at iBATIS as a DAO solution however we have many
stored procedures that return upwards of 10k rows. Our previous solution cut
the number of rows returned to a fixed limit.
Is there any way to do this usin
Excellent. I hope it serves them well. :-)
Thanks for the update.
Clinton
On 5/10/07, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
I'm attending JavaOne this week in San Francisco and of course I had to
stop by the book store to see if they had a copy of "iBatis In Action".
Sadly on Tuesd
No, it doesn't call setMaxRows. Probably a legacy decision for driver
compatibility reasons, but I suppose 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 PROTECTE
queryForMap(...)
On 5/10/07, Collin Peters <[EMAIL PROTECTED]> wrote:
Hello All,
I'm wondering if iBatis can take a simple query that returns
name/value pairs (i.e. two columns of many records) and store it into
a *single* hashmap
So the results of the query look something like:
name | val
Hello All,
I'm wondering if iBatis can take a simple query that returns
name/value pairs (i.e. two columns of many records) and store it into
a *single* hashmap
So the results of the query look something like:
name | value
name1 | value 1
name2 | value 2
name3 | value 3
etc
And at
oh.. got it.
I used MyISAM.
I should use InnoDB if I want to use transaction.
Thank you so much Larry. :)
On Thursday 10 May 2007 22:37, Larry Meadors wrote:
> InooDB or MyISAM?
>
> Larry
>
> On 5/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > Yes It is MySQL.
> >
> > On Thursday 10 Ma
InooDB or MyISAM?
Larry
On 5/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Yes It is MySQL.
On Thursday 10 May 2007 21:28, Larry Meadors wrote:
> Is it MySQL?
>
> Larry
>
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-%3A-How-
Yes It is MySQL.
On Thursday 10 May 2007 21:28, Larry Meadors wrote:
> Is it MySQL?
>
> Larry
>
Is it MySQL?
Larry
On 5/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Dear Experts,
I am trying to use Transaction with iBatis DaoManager.
I need to make sure all deletion must be completed or the transaction should
be roll-backed.
Here is my bean:
-
Dear Experts,
I am trying to use Transaction with iBatis DaoManager.
I need to make sure all deletion must be completed or the transaction should
be roll-backed.
Here is my bean:
---
public void deleteF0002(List p_list
This error doesn't seem to be related to iBATIS. See here:
http://www-1.ibm.com/support/docview.wss?uid=swg21208123
Jeff Butler
On 5/9/07, Tom Henricksen <[EMAIL PROTECTED]> wrote:
We are adding some non iBatis code and trying to tap in to the iBatis
connection for some code analysis purpo
Hi Meindert,
those columns which i had mentioned are common across all tables. Having a
common base class also helps as i can reuse a lot. The other important thing
i gain is alongwith namespaces and spring support it is possible to have as
less code as possible. My action classes, DAO, DAO impl w
Not to be nasty but wouldn't it be better to normalize the database and put
createBy, createDate, modifiedBy etc in his own table/class?
That's what I like about ibatis, I will only fetch this kind of data when I
actual going to use it.
On 5/9/07, Ashok Madhavan < [EMAIL PROTECTED]> wrote:
I'm attending
JavaOne this week in San Francisco and of course I had to stop by the book store
to see if they had a copy of "iBatis In Action". Sadly on Tuesday, Day one, of
the conference I found no copies on display. Surely this was an oversight on
someone's part because I saw many copies
20 matches
Mail list logo
