Without knowing everything about your setup, I believe
your problem is due to the fact that Oracle JDBC
drivers implement ROWID as a Java string.
Regards,
Satar
- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> Okay, I'll preface this by saying we did find a work
> around but this
> was strange and I wondered if any of you had run
> into this.
>
> Background:
>
> two 8.1.6.0 databases, one is Solaris 2.8 32 bit and
> the other is
> Solaris 2.6
>
> the local database is on the 2.8 machine, call it
> users
> the remote database is on the 2.6 machine, call it
> compdata
>
> Public database link from users to compdata
>
> private synonym events for events_at_compdata in the
> users database.
>
> log into sqlplus, select * from events where id=#
> works fine
>
> via the java program & jdbc 1.1, select * from
> events where id=#
> returns the first row you selected, no matter what
> id you subsequently
> give it. So id=4 as the first selected means that
> whatever id you now
> give it, it will return the data from id 4.
>
> drop the public synonym, create a copy of the events
> table on users.
>
> sqlplus AND the program run fine
>
> go back to the synonym across the link and the
> program blows up,
> sqlplus is fine (at least it's consistent)
>
> change the program code to
>
> select * from events_at_compdata
>
> and the program is fine
>
> so something is wrong not with the database, but
> with java settings, or
> jdbc drivers (1.1) or ?????
>
> All other accesses with other links between the two
> databases are fine.
>
> The only other thing we could think of was that that
> program runs on an
> app server with an older version of WebSphere.
>
> Any ideas on what would cause this? As I said, we
> have a work around
> (hard-code the link) but I'd like not to have to do
> that
>
> Rachel
>
> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: satar naghshineh
INET: satarnag_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Oct 02 2001 - 15:20:58 CDT