ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marco Rossi" <mros...@gmail.com>
Subject Re: Problem SQL Maps with Oracle DbLink
Date Fri, 09 Jun 2006 15:00:51 GMT
Diran,
thanks for your replay.
I tried with another Oracle Db version, and the code works. Probably it's an
Oracle problem.

Marco

On 6/9/06, Diran Ayandele <Adediran.Ayandele@sun.com> wrote:
>
> Marco, this isn't really an iBatis question.  You'd be better off
> posting it in an oracle forum.  Anyway, we select over dblinks using
> iBatis without problems.
> 1. Make a synonym in the schema you're using, just for clarity.
> 2. The actual error you're getting is for an unrecognized date format
> which tells me you need to specify date formats when passing dates to
> your query.  The default format is probably different in the remote
> database which might be why it works with the local view and not when
> you go to the tables themselves.  That is assuming your view is a local
> composite of local and remote tables.
>
> Diran
>
> Marco Rossi wrote:
>
> > Hi,
> >
> > I have a problem to map a select with a Oracle  dblink. When a try to
> > execute my code I catch an unpredictable exception (ORA-01821), but if
> > I create a materialized view all works fine.
> > What's wrong?
> >
> > Thanks in advance,
> >
> > Marco
> >
>

Mime
View raw message