HI:
Does itright the sqlMap like
under?
iterate
property="searchValueList" open="(" close=")"
conjunction="$searchValueList[].andOr$"$searchValueList[].column$$searchValueList[].operator$#searchValueList[].value#/iterate
No, that doesn't work, I tried that too.
You could create a JIRA-issue for it...
Niels
From: 张鑫宇 [mailto:[EMAIL PROTECTED]
Sent: donderdag 3 november 2005 14:52
To: user-java@ibatis.apache.org
Subject: Does iterate tag conjunction property support
Paul,
How does it compare to batch processing?
Zsolt
-Original Message-
From: Paul Benedict [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 8:44 AM
To: user-java@ibatis.apache.org
Subject: Re: Bulk inserts
Yes,
SQL has a notation to INSERT multiple entries at once.
What
On 11/3/05, Paul Benedict [EMAIL PROTECTED] wrote:
Yes,
SQL has a notation to INSERT multiple entries at once.
What you want to do is build a statement like the
following:
INSERT INTO fruit (id, name) VALUES (0, 'Pear'), (1,
'Apple'), (2, 'Peach')
Is that standard ANSI SQL? I know MySql
Can somebody please explain how this work? I need to show results from some
table, i'm using limit/offset statements in SQL query, but I saw iBATIS can
handle pages in result set somehow, so I might not be forced to add
limit/offset statements in the SQL clauses. But I'm wandering how does iBATIS
It doesn't, it just skips results in the ResultSet I believe. If you
want to get optimal performance, roll your own implementation of paging
and use the LIMIT/OFFSET statements, however, it won't be
database-independent.
Niels
-Original Message-
From: Eugeny N Dzhurinsky [mailto:[EMAIL
On Thu, Nov 03, 2005 at 04:07:11PM +0100, Niels Beekman wrote:
It doesn't, it just skips results in the ResultSet I believe. If you
want to get optimal performance, roll your own implementation of paging
and use the LIMIT/OFFSET statements, however, it won't be
database-independent.
Okay,
DB2 supports this syntax.
Jeff Butler
On 11/3/05, Michael Campbell [EMAIL PROTECTED] wrote:
On 11/3/05, Paul Benedict [EMAIL PROTECTED] wrote:
Yes, SQL has a notation to INSERT multiple entries at once. What you want to do is build a statement like the following: INSERT INTO fruit (id, name)
How does it compare to bulk insert? It's faster.
Making 1000 round trips to the database is slower than
1.
Try it out on your database. If it doesn't work, then
you must do a for loop.
--- Michael Campbell [EMAIL PROTECTED]
wrote:
On 11/3/05, Paul Benedict [EMAIL PROTECTED]
wrote:
Yes,
I think I'd look for a native database tool for this - most vendors
provide bulk-loading tools.
I think iBATIS is cool, but a golden hammer it isn't. ;-)
Larry
On 11/3/05, Paul Benedict [EMAIL PROTECTED] wrote:
How does it compare to bulk insert? It's faster.
Making 1000 round trips to the
Title: Sub-List in Result Map Problem.
I am having a problem with nested resultmaps and the sub-lists. I have 2 Result Maps. One contains a collection
Of the second map. The second map maps a complex property. When I execute the query and the are no properties that are
Related, I still get
Title: Null Pointer in iBatis 2.1.5_582
I recently ran into a problem while executing a stored procedure using an inline map in iBatis 2.1.5_582.
Caused by: java.lang.NullPointerException
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:355)
at
Hi I have a problem setting null values in dates. this is my code:
parameter property=p_aci_fec_Infraccion jdbcType=st_aci_fec_Infraccion
javaType=java.util.Date nullValue=NUMERIC null=0 mode=IN/
when i run the code i have this message:
(Error) Attribute 'null' used but not declared.
any
Woah. I was under the impression that internally it's doing what's optimal
by considering what database is being used. I noticed the i believe in
your post. Can you please confirm this? If so, do future releases of IBatis
plan on considering the database when using PaginatedList. It doesn't
On 11/3/05, Zarar Siddiqi [EMAIL PROTECTED] wrote:
Woah. I was under the impression that internally it's doing what's optimal
by considering what database is being used. I noticed the i believe in
your post. Can you please confirm this? If so, do future releases of IBatis
plan on considering
PainatedList is a convenience feature, not a performance feature. Those two goals generally work against each other.
If you're after performance, definitely DO NOT use PaginatedList.
ClintonOn 11/3/05, Michael Campbell [EMAIL PROTECTED] wrote:
On 11/3/05, Zarar Siddiqi [EMAIL PROTECTED] wrote:
The MySql driver loads everything into the memory (unless you use LIMIT),
thus if paginated list just skips records it seems to be use less. Its
functionality can be replaced with List.subList(int fromIndex, int toIndex).
My log just show java.sql.ResultSet returned by ibatis, and that contains
On Fri, Nov 04, 2005 at 08:22:29AM +0100, Zsolt wrote:
The MySql driver loads everything into the memory (unless you use LIMIT),
thus if paginated list just skips records it seems to be use less. Its
functionality can be replaced with List.subList(int fromIndex, int toIndex).
My log just
18 matches
Mail list logo