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).
