Hi All,
i have stuck with dynamic Sql on Ibatis 3 annotations. Trying to pass List
in dynamic sql as follows:
@Update("update ${schemaName}.fuf uf" +
" set uf.reestr_date = #{reestDate}," +
" uf.reestr_number = #{reestNum}" +
well, sure, I _always_ use java.util.Date..
My sqlMap is an abatorGenerated one.. and it's quite big.
http://ibatis.apache.org/dtd/sql-map-2.dtd";>
(
$oredCriteria[].criteriaWithoutValue[]$
$ore
Look a documentation on commons.dbcp
http://commons.apache.org/dbcp/configuration.html
2010/4/29, Sergey Livanov :
> I read, that maxrequest, maxsessions, maxtransactions were remote from
> ibatis.
> I use ibatis 2.6 + spring2 + Glassfish.
> How I can set the unlimited amount of concurrent transac
Hi,
i am just starting to play with iBatis 3 and can not figure out how to
declare more than one parameter in a select statement in XML without
using the parameterMap attribute. I figured how it works with
annotations, but I would like to do everything in XML.
My select statement looks like this:
Today, I'm having other kind of pb...
My select request return too much rows..
I'm still lauching the same test.. and, in debug mode, i've seen something
wrong here :
protected void addCriterionForJDBCDate(String condition, Date value,
String property) {
addCriterion(condition
Pass a bean or Map with those attributes, and you should be good to go.
On Wed, May 5, 2010 at 2:17 AM, Thomas Mair
wrote:
> Hi,
> i am just starting to play with iBatis 3 and can not figure out how to
> declare more than one parameter in a select statement in XML without
> using the parameterMap
Thanks for your reply Jeff
I am using something very similar (See below) but I am getting a host of
error messages, including:
--- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal
list from JavaBean. Cause java.lang.NumberFormatException: For input string:
""
Caused by: java.
I think your issue relates to a misunderstanding about the "property"
attribute. I see that you have added "ReportParameters" at the front
of all your property references. My guess is that you don't need
that. iBATIS would expect "ReportParameters" to be a property of your
parameter object - and
(a)ibator converts these to java.sql.Date to force iBATIS to use the
DateOnlyTypeHandler for database fields that are truly just dates -
not date/time or timestamp. This is working in lots of tests.
What is the type of the database field? Is it truly just a date, or
is it a timestamp?
Also, in
IIRC, iBATIS doesn't support dynamic SQL in annotations. You'll need
to use an @UpdateProvider and generate the dynamic SQL yourself.
Jeff
On Wed, May 5, 2010 at 2:18 AM, shamim wrote:
>
> Hi All,
> i have stuck with dynamic Sql on Ibatis 3 annotations. Trying to pass List
> in dynamic sql as
Hi
It's not clear from my examples but ReportParameters is the actual name of a
property in the HashMap passed to iBatis (it's used throughout the
application I'm amending).
i.e. I pass a HashMap called, say, MyHashMap to iBatis; within this is a
property called ReportParameters. This in turn
OK.
Nested iterates work in iBATIS 2.2.0 or later.
"ReportParameters" is not really a proper Java property name - you
might try "reportParameters". Maybe thats the problem?
Jeff Butler
On Wed, May 5, 2010 at 10:58 AM, devver wrote:
>
> Hi
>
> It's not clear from my examples but ReportParamet
Has anyone quantified the performance differences between version 2.3.x and
version 3?
Other than the architectural changes (annotations, typing, etc), I am
curious as to the net benefits of upgrading from 2.3.x to 3.
Thanks in advance,
Rob
Clinton
A little more information on this, I reverted back to 240 and the problem I
reported did not occurs after a 24 hour run. I then went to the current release
and the problem reappeared, everything else is the same, so there is an issue.
What it looks like is going on is that connections a
Rob
I have not made any formal measurements, but selects are much faster, and
inserts/updates/deletes are a little slower, but I was not using 2.3.x
'correctly', I was caching sqlmaps when I should not have been.
François
On May 5, 2010, at 12:07 PM, Robert Dare wrote:
> Has anyone quantified
Perhaps with the shiny new SqlBuilder... :-)
On 2010-05-05, Jeff Butler wrote:
> IIRC, iBATIS doesn't support dynamic SQL in annotations. You'll need
> to use an @UpdateProvider and generate the dynamic SQL yourself.
>
> Jeff
>
> On Wed, May 5, 2010 at 2:18 AM, shamim wrote:
>>
>> Hi All,
>>
Two things to do:
* Create a JIRA ticket for this. We'll continue conversation and
investigation there.
* Mount the source and step through one example transaction. See if
you can verify that close isn't being called, and possibly why.
* Finally, out of curiosity, disable caching globally, and
Thank's very much for hints.
shamim wrote:
>
> Hi All,
> i have stuck with dynamic Sql on Ibatis 3 annotations. Trying to pass
> List in dynamic sql as follows:
>
> @Update("update ${schemaName}.fuf uf" +
> " set uf.reestr_date = #{reestDate}," +
>
18 matches
Mail list logo
