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 [EMAIL PROTECTED] 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@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@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).