JDBC and moving from 8.0.4 to 8i

From: Phil Britton <phil.britton_at_prismtechnologies.com>
Date: 01 Oct 1999 11:51:13 +0100
Message-ID: <uso3v9wwu.fsf@prismtechnologies.com>

Hi,

we've got an Java application that connect to oracle via JDBC, at the minute it's version 8.0.4. The JDBC calls are a mix of fixed text SQL statements (e.g. "select name from table") and prepared statement calls returning refcursors, calling PL/SQL procedures . After installing 8i I exported a couple of schemas from 8.0.4 and imported them into 8i (without any problems). I then substituted the 8i jdbc classes111.zip in the class path and fired up our app. Without investigating too deeply as yet it seems that our fixed text calls work OK but the prepared statements return the oracle error "00942: table or view does not exist", which is obviously spurious as the table does exist.

Anyone got any ideas? Searching OTN for anything to do with moving from 8.0.4 to 8i and using JDBC has proved fruitless

cheers

Phil Britton

--
Philip W. Britton
Productisation & Support Manager (Asset Lifecycle Databases) PrismTech Ltd, UK.
Tel +44 191 497 9919 http://www.prismtechnologies.com Received on Fri Oct 01 1999 - 05:51:13 CDT