iBatis/JDBC is all dynamic SQL -- at least not static in the DB2 sense.
>From a DB2 doc on SQLSTATE 560B8:
The SQL statement cannot be executed because it was precompiled at a
level that is incompatible with the current value of the ENCODING bind
option or special register.
I believe the term "p
My recollection is that iBatis always eagerly loaded 1 to 1 and many
to 1 associations, and only lazy loaded 1 to many's and many to
many's, or to put it another way, only lazy loads Collections, not
individual objects...
Hugh
-
Which type of Data Source do you use (e.g., JNDI or SIMPLE)? For
SIMPLE, you can specify the schema on the connection URL, e.g.,
(Note: connection URL syntax varies some by database.)
For other Data Source types (e.g., when running under a J2EE
container), the admin tool usually provides a mea
Sorry to hear about the deprecation of Parameter Maps in iBATIS3. I
like them for keeping the SQL parts of our SqlMaps cleaner. Also
seems consistent with use of Result Maps for Selects...
On 7/24/09, Jeff Butler wrote:
> You don't need a parameter map for procedures in iBATIS2. This is
> from
Butler wrote:
> > See here:
> >
> > http://issues.apache.org/jira/browse/IBATIS-375
> >
> > Looks like a fix for this is in 2.3.4.
> >
> > Jeff butler
> >
> >
> > On Tue, Jan 6, 2009 at 3:42 PM, Hugh Ross wrote:
> >>
> >
We are testing some sqlMaps to avoid the N+1 Selects problem that include
OUTER JOINs. Since nulls are coming back in the Result Sets, we are seeing
pojos created with all nulls. Testing with iBatis 2.3.4.
I don't recall seeing this problem mentioned before, but I can't believe no
one else has h
One thing you might consider would be to carry two timestamps in your
POJO(s). One old_ts and one new_ts. Selects or read DAOs could populate
both. Updates would use new_ts in the SET clause, and old_ts in the WHERE
clause. Clients should never change the old_ts.
On 10/10/08, mule_user <[EMAIL
ientImpl --
> perhaps I should release something of the sort as a plug-in?
>
> But I highly recommend you hunt down the actual problem with your
> application.. If you're getting deadlocks, that could either be unclosed
> connections, poorly written stored procedures or resources th
Clinton,
Can you send us a link to more detail on this thread throttling, perhaps in
wiki or release notes?
Thanks...
On 7/17/08, Clinton Begin <[EMAIL PROTECTED]> wrote:
>
> I've removed all thread throttling from iBATIS. It was causing a great
> deal of confusing and people complained about p
was able to achieve throughput of
> 15,000 records per second on millions of rows.
>
>
>
> So they CAN be fast. They aren't just fast by default, and they're not
> for every situation.
>
>
>
> Clinton
>
>
>
> *From:* Hugh Ross [mailto:[EMAIL PROT
I've looked at the docs (In Action book, Developer Guide 2.0, and wiki), and
somehow I've missed this.
I have seen threads in the user-java Mail Archive saying that it can, but
I'm not clear on how.
Thanks...
P.S. Actually, I believe only the Dev Guide mentions RowHandler
specifically, and ther
Actually, it is even harder -- we'd like to use Lazy Loading of the
associations into this hierarchy. I think that means we could not use a
RowHandler, anyway...
On 1/30/08, Hugh Ross <[EMAIL PROTECTED]> wrote:
>
>
> Good indexing, but Outer Join required. We are OK wi
type column in the
> database, look up "discriminator" in the ibatis documentation or mailing
> list archives...
>
>
>
> Clinton
>
>
>
> *From:* Hugh Ross [mailto:[EMAIL PROTECTED]
> *Sent:* January-30-08 9:23 AM
> *To:* user-java@ibatis.apache.org
> *Subject:* Safe
ng to create subclasses based on a type column in the
> database, look up "discriminator" in the ibatis documentation or mailing
> list archives...
>
>
>
> Clinton
>
>
>
> *From:* Hugh Ross [mailto:[EMAIL PROTECTED]
> *Sent:* January-30-08 9:23 AM
> *To:* us
1/30/08, Christopher Lamey <[EMAIL PROTECTED]> wrote:
>
> So are you basically looking at one big query with a bunch of joined
> tables
> or a bunch of smaller queries to pull it all together?
>
> If so, which one would fit better for your app?
>
> On 1/29/08 6:42 PM, "
ed by a
queryForList or queryForObject call? If I don't hear back, I guess I'll try
it to see...
Thanks...
On 1/29/08, Hugh Ross <[EMAIL PROTECTED]> wrote:
>
>
> I have the good fortune to work on a large domain model, part of which
> uses too much inheritance. I do
I have the good fortune to work on a large domain model, part of which uses
too much inheritance. I don't want to use a huge outer join with 15 or 20
tables in it. I'm wondering if I can use RowHandlers to help. In
particular, is it possible for a RowHandler to replace the object passed to
the h
e invoked
> method?
>
> For reporting reasons?
>
> I'm very curious, can you give more details? An example?
>
> On 1/24/08 1:19 PM, "Hugh Ross" <[EMAIL PROTECTED]> wrote:
>
> > Unfortunately, the InvocationHandler for SimplePooledConnection is a
&g
c and recompile (you could also add the missing methods
> to the log proxy classes if you want to stay at 2.2). I'll commit a
> change to make the inner class public so that your code won't break with
> future releases.
>
> Jeff Butler
>
>
>
> On Jan 2
gt; logging is enabled. Proxy upon proxy - it can get complex to unwind these
> things.
>
> I have to wonder - is this really necessary? You can probably set the
> value you mentioned as a driver property and not have to write all this
> untangling code.
>
> Jeff Butler
>
s much
> easier (I would say that 2.3 is quite stable - it's been out over a year).
>
> Jeff Butler
>
>
> On Jan 24, 2008 11:56 AM, Hugh Ross <[EMAIL PROTECTED]> wrote:
>
> >
> > Thanks, Jeff. I'm not finding a getConnection method in the
>
! I just added a WIKI page describing the process:
>
>
> http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=15597591
>
> Jeff Butler
>
>
>
> On Jan 24, 2008 10:03 AM, Hugh Ross <[EMAIL PROTECTED]> wrote:
>
> > Can anyone provide some
Can anyone provide some sample code for this?
I tried, but seemed to be blocked by $proxy objects or odd looking
com.ibm.db2.jcc.b.b objects...
For example, this did not work for me:
java.sql.Connection conn = sqlMapClient.getCurrentConnection();
if (conn instanceof com.ibm.db2.
23 matches
Mail list logo
