Well, joins, being the primary operation supported by relation databases,
shouldn't cause you much trouble. Especially if you join on primary key. If
you don't, and your application doesn't belong to most apps where joining
two tables is a non-issue, proper indexing (after you've done some analysis
Well, you can try logging `java.sql.*` if you're not already doing it. The
last statement before error should be what you're looking for.
On Tue, May 12, 2009 at 11:57 PM, sjewett wrote:
>
> Hi All,
>
> We are using iBATIS 2.1.7. I'm getting a java.sql.BatchUpdateException:
> ORA-1: unique
I wonder, what's the motivation behind making Calendar an object property?
If you need some Calendar specific operations, create some accessor/mutator
methods to hide the actual Calendar instance. This way you won't need
explicit TypeHandlers and your implementation won't depend on the Calendar
(wh
I don't really know how you manage to get an IntegrityConstraintsException
when performing selects. Updates and inserts, on the other hand, are
sensitive to parameter placement.
You might be referring to the exception being thrown on update when you feed
newly received object (using the faulty sele
Double check all the possible library conflicts. Huge amount of cryptic
errors happen because of library/parent-first/parent-last issues.
On Mon, Oct 20, 2008 at 4:37 PM, Helder Ribeiro <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Im using ibatis in the SAP XI Server and I got a problem. Locally it wo
I don't see anything wrong, except 'FROM ATABLE o' in your query, but that's
probably a typo, because you would have got an exception by now. Also, you
are searching by ID's - maybe queryForObject is more appropriate in this
case (just a guess)?
Have you tried logging database calls? Do the right p
upported feature
> error.
>
> Have viewed examples where procedures are declared with following notation
>
> ? = call proc (?,?,?,?,?,?)
>
> Have attempted this also and get wrong number of types or arguments.
>
> Any advice much appreciated.
&
You are querying for list - Ibatis tries to map resultset obtained after the
call, which is absent, so you get no data. You should use
sqlMapTemplate().update("procedure", params) and check for the out parameter
in the 'params', under the key specified in the sqlmap.xml parameterMap
(aParameterMap
HAR,mode=OUT#
>
> Clinton
>
>
> On Thu, Sep 11, 2008 at 7:09 AM, Vadim <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I've been thinking how to do this for too long now. Ibatis version is
> > 2.1.0.565, Oracle version is 9. What I'm trying to d
Hello,
I've been thinking how to do this for too long now. Ibatis version is
2.1.0.565, Oracle version is 9. What I'm trying to do is map a statement to
a Java class and get one varchar OUT parameter. PL/SQL function is like
function with_out (
in_param in varchar2,
out_messageout
known limitation (in which case it would be good to
document it somewhere, I guess).
I hope someone knowledgeable about iBATIS internals can voice their
opinion on that...
Thanks,
-Vadim
paulomourajr wrote:
Hi, Grinshpun,
I faced this same problem a couple of hours ago. In my case, I have a
ge
as the error message clearly
shows, the type info is retrievable...
Thanks for any insight!
-Vadim
the result maps may be what you need; but if you truly need to populate
an object that has already been constructed,
I believe there's an overloaded version of queryForObject that takes an
additional parameter of an object instance to be modified. **
[EMAIL PROTECTED] wrote:
Hi Vinay,
Checko
passed in.
Comparing both of these between the two environments might shed some
light on your situation.
-Vadim
[EMAIL PROTECTED] wrote:
values are ok
the question is:
in jdeveloper (embedded oc4j) the queries (all) are ok
in production oc4j no
*"Yee, Richard K CTR
onding
xml files with the substitutions--that is, you add an extra step to the
build process.
-Vadim
Chema wrote:
Hello:
I like to compose the next query
SELECT ID FROM TABLE
WHERE
AND FIELD1 = #field1#
AND FIELD1 IS NULL
Is there anot
S seems to see the interface instead of the class, so be
forewarned. (I've not yet gotten a good case that reproduces this
easily, so I've not yet reported this as a bug).
-Vadim
Eric T. Blue wrote:
Hi,
My company is currently investigating the best strategy for not
exposing certain
number,
or the name of the select statement, would be very helpful.
I wish I could provide examples, but the system I work on is not
connected to the net, and getting data off is a rather painful process.
-Vadim
PS for the record--I do have logging turned on, it is indeed a
lifesaver; and
I was hoping
there might be a more intelligent way to approach this.
If there isn't a better way to do this currently, is it feasible to add
better error reporting facilities into the parser, and are there any
plans to do so?
Thanks for any advice.
-Vadim
s, I've run into the same problem as Paul... haven't really found
a clean workaround for it yet. I do believe this is a bug in iBATIS,
-Vadim
Larry Meadors wrote:
So...I do not understand..your beans are interfaces?
How often do you swap out the implementation of your beans? ;-)
mechanism, so
there's a learning curve to get over :)
Thanks,
-Vadim
Clinton Begin wrote:
A) Why not use the Wiki. (there's already a "Not Yet Documented" section)
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Home
<http://opensource.atlassian.com/
a certain fraction of the simpler
"how do I do X"/"please read the manual"/"but where is the manual" type
of exchanges on the list :)
Thanks for listening :)
-Vadim G.
admit I'm fairly ignorant when it comes to stored procs,
but it seems you'd have to be able to generate the SQL on the fly, which
I doubt they can do).
-Vadim
Yee, Richard K CTR DMDC wrote:
You should do this inside a stored procedure instead of using iBATIS or your
code to d
this to be done :)
(and I appreciate that this is not a trivial task, just expressing a hope :)
-Vadim
Jeff Butler wrote:
There's nothing in iBATIS that will do this. I've done something
similar in the past by adding a getter to the parameter object and
coding the logic in the getter met
or explain in more detail?
Thanks!
-Vadim
Niels Beekman wrote:
Yes, that should work out just fine. See the Developer Guide for some
examples...
-Original Message-
From: Vadim Grinshpun [mailto:[EMAIL PROTECTED]
Sent: woensdag 28 juni 2006 20:58
To: user-java@ibatis.apache.org
Subje
ELECT * FROM
table_foo f, table_bar b
, table_baz z
WHERE f.field = b.field
>z.x_field > #X.value#
>z.y_field = #Y.value#
Thanks,
--Vadim
No, the type in question is a String, which is quite nullable--hence my
surprise that this doesn't work as I'd expect.
(I ran into the int vs Integer issue previously, but a search of the mailing
list archive helped solve that :)
-Vadim
-
Christian Poi
easy way of
getting the exception stack trace to the machine I'm emailing from, but
if it is needed, let me know, I can try to outline the trace a bit.
Again, thanks.
-Vadim Grinshpun
27 matches
Mail list logo
