Hi,
I'm using the "selectKey" with insert commands. It works great.
We are using a development database based in SQLite, and the select is like
this: select max(id)+1 from TABLE
Now, we are moving our project to the production enviroment, a Oracle 10g
database, and in this scenario we'll use a seq
AFAIK the root of the problem is that when iBatis handles resultset of left
joining master table with child table the child table columns may be all
NULL and it's not quite clear whether child table indeed contained
corresponding row with NULL elements or there was no result found in the
child tabl
I'd suggest that you do your development against an Oracle 10g
database. This really is the best solution.
But, if that's not really an option, I guess you could maintain a
separate set of sql maps for each DB. Or, maybe use Ant replacement
variables for your build to swap out the correct s
Why not using an XML-Entity and load different DTDs, this way you have
your standard mapping files and only the small Entity thing is switched
by including this or that DTD.
Tom
Ian Zabel schrieb:
I'd suggest that you do your development against an Oracle 10g database.
This really is the best
Use a properties file to specify the statements, and then include them
from within the selectKey statement. There was a post about this a while
back, but I can't find it. You could look in the documentation to see if
there's any information about including properties.
Niels
___
Ibator where clauses are always in this form:
(x && y && z) || (a && b && c)
You can use boolean algebra to refactor your query into something that can
be accomplished in ibator. For example:
(bool1 not true && date1 is null && date2 between testdate1 and testdate2 &&
string1 is null) ||
(bool1
Hello,
Using the latest build of iBATIS and Oracle REF Cursors, we're running
into a problem with certain rows not coming back in the ResultSet. It
seems to be certain data in the rows that makes them not return.
For example, we have a column called INTERNAL_INVOICE_NBR. With the
following values
iBATIS seems to have a problem with handling RefCursors as OUT
parameters in stored procedures. I don't know how you're attempting to
use iBATIS in your project, but in house here we've found that stored
functions (where the Cursor is returned from the function and not
fetched into an out para
Could you send your Ibatis configs. I am having data like those successfully
processed.
On Tue, Aug 12, 2008 at 2:57 PM, Jeff Stahl <[EMAIL PROTECTED]> wrote:
> iBATIS seems to have a problem with handling RefCursors as OUT parameters
> in stored procedures. I don't know how you're attempting to
Very interesting. How do you map something like that?
Thanks,
Ian.
On Aug 12, 2008, at 5:57 PM, Jeff Stahl wrote:
iBATIS seems to have a problem with handling RefCursors as OUT
parameters in stored procedures. I don't know how you're attempting
to use iBATIS in your project, but in house h
It shouldn't... :-/
Can you provide a failing test case?
On Tue, Aug 12, 2008 at 3:57 PM, Jeff Stahl <[EMAIL PROTECTED]> wrote:
> iBATIS seems to have a problem with handling RefCursors as OUT parameters
> in stored procedures. I don't know how you're attempting to use iBATIS in
> your project,
Thanks.
Can I make a feature request that enables Example Classes to construct
queries in a more dynamic way. It would be nice to be able to combine
clauses as either 'OR' or 'AND' like
criteria1 = example.createCriteria().andField1EqualTo(testValue);
criteria2 = example.createCriteria().andF
12 matches
Mail list logo
