This conversation inspired a rather off-topic question from me, in mysql are
you forced to hardcode the limit/offset in to the SQL like this?
limit $skip$, $max$
In Postgres they can bind as parameters:
limit #limit# offset #offset#
I'm not really a mysql user so I am curious...
-J
On Tue, Jan
Are you upgrading from a version before the two jars were merged into one? I
remember encountering a similar problem when the old second jar was
accidentally left in our classpath and in our lib directory.
-J
On Sun, Feb 8, 2009 at 10:40 PM, Larry Meadors wrote:
> What's the database?
>
> Larry
Call me crazy Rahul, but if you are trying it then would you not
already know what type would be returned simply by examining the type
that is actually returned?
Judging by your code above the "resultClass='int'" above should mean
you are getting a java.lang.Integer back. I *think* it should also b
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+reuse+SQL-fragments
On Mon, Nov 23, 2009 at 9:11 AM, Stephen Friedrich
wrote:
> My application uses a lot of "manual" paging (using ROWNUM and nested selects
> in Oracle PL/SQL).
> For each of these queries there is a second
I would guess that this is a database encoding problem, have you
confirmed that the ">"s are causing a problem or just the non-ascii
characters? If the driver is getting generating invalid UTF16 for Java
(internally) that might be causing the failure... unfortunately this
is a real pain to debug a
This is really just a database/jdbc problem, nothing to do with ibatis
itself. You probably have a precision problem relating to your
fraction (that is too small to show up in the 1.0E+18), setting the
scale on the BigDecimal before sending it to the database might sort
that out for you.
-J
On Ja
> [TDS Driver]Read timed out
This looks to me like a network-level timeout, not a database timeout.
I've only used the open-source jdbc driver for SQL Server but we have
had problems with connection instability if our app is idle for a long
time (MSSQL2005), a ping-query fixed that though. Doesn't
I have encountered something similar to this before and I think there
were 2 elements to the solution. The first was that the system default
CCSID on the AS/400 was not set and I believe the second was that we
could set a jdbc driver property in the toolkit driver to override it
- or something like
't see any info about so far...
> >
> > Cheers
> > Tracey Annison
> >
> >
> >
> >
> > -Original Message-
> > From: j-lists [mailto:[EMAIL PROTECTED]
> > Sent: 19 February 2008 09:10
> > To: user-java@ibatis.apache.org
> >
Let me guess, your boss at Sungard is unhappy that you posted
information about their proprietary data structures to this list?
The bad news is that it is pretty much impossible to remove a message
from this "forum" because it is actually a mailing list - there are
probably hundreds of copies of it
We dump our references to the original SQLMapClient instance and
replace it with a new one (we don't allow anyone to reference it
directly in application code to make sure we don't have any leaks) but
we don't use Spring so I'm not sure how that might restrict your
options.
On Fri, Feb 22, 2008 at
I think the real news here is that alibaba.com is using ibatis! I did
a quick search and found this:
http://code.google.com/p/ibatis-sharding/
It looks like it is a project from the devs at alibaba.
-J
I guess this is a bit of a digression but since we are on the topic...
IMHO finding multiple statements using semicolons would be less than
ideal, allowing the nesting of insert/update/delete/select tags would
be a more structured way to implement it and would remove the SQL
parsing burden from iBa
I have no idea why this is happening to you but I suggest that this article might offer some insight:
http://cafe.elharo.com/java/turkish/
-J
On 11/5/05, Bahri Gencsoy <[EMAIL PROTECTED]> wrote:
Think about the most simple database table, just containing ID column
as an integer:
iBatis does remove the line breaks and if it stops it'll break my production DB2 app!
(And I don't know what it will do to my DB2/400 version)
-J :-)On 11/10/05, Paul Benedict <[EMAIL PROTECTED]> wrote:
I believe the XML spec does not allow the double dash to appear within a body. The -- is res
I for one regard inline parameter maps as something of a neccessary
evil (for dynamic SQL) and would NOT like to see the same thing
introduced for result maps. It is the absence of funny escape sequences
and other complications in the iBatis SQL that makes it such a pleasure
to work with. Unfortuna
A clever use of and where the is in the ${dialect} file will
give some pretty reasonable flexability without the need to exploit any
bugs. I have recently posted a JIRA feature request precisely to help
address key generation aspect of the cross-DB compatability issue more
easily using propertie
Does this mean 2.2 will never be a GA release or that it already is?
On 11/21/06, Clinton Begin <[EMAIL PROTECTED]> wrote:
Hi all,
I'd like to release iBATIS 2.3 sometime this week. The changes listed for
the release are as follows:
o DEPRECATED All PaginatedList related features due to misu
18 matches
Mail list logo
