Re: jdbc driver problems

[Quoted] [Quoted] Thanks fro the advice, but the problem is not in the code. As I wrote I have [Quoted] this problem only passing from oracle 8.0.5 to oracle 8.1.6 and switching [Quoted] drivers accordingly.

Ciao,

    Manuel

"C. Ferguson" wrote:

> Hi,
> double check your code:
> For each placeholder you specified in the PreparedStatement, you must [Quoted]
> bind a value to it before executing...
>
> String myupdate = "update table foo set col1 = ?, col2 = ?, col3 = ? where
> something = ?";
>
> (Note 4 placeholders: col1, col2, col3 are varchar2's and something is a
> number)
>
> PreparedStatement foo = con.prepareStatement(myupdate);
> foo.setString(1, 'This');
> foo.setString(2, 'is ');
> foo.setString(3, 'a test');
> foo.setInt(4, 5);
>
> foo.executeUpdate();
>
> (woa, just noticed you cross-posted to everybody and their dog...please
> refrain from this type of behavior...a good bet to get answers from is the
> server group, although you probably could have gotten this answer from a [Quoted]
> java users group...)
>
> hth,
> cindy
>
> Emanuele de Rinaldis wrote:
>
> > Hi all,
> >
> > I've a problem in the upgrading from oracle 8.0.5 to oracle 8.1.6:
> >
> > when I use the jdbc drivers for oracle 8.0.5 I don't manage to get the
> > connection to oracle 8.1.6 , but when I use the drivers for oracle 8.1.6
> > I get errors from preparedStatement.executeUpdate() method calls:
> >
> > ORA-01008: not all variables bound
> >
> > I tried either with jdk 1.2 and jdk 1.3 but the problem still persist.
> >
> > Does anybody know how to solve the problem ? Any help will be really [Quoted]
> > apreciated...
> >
> > Thanks,
> >
> > Manuel de Rinaldis

--
LION bioscience AG, Waldhofer Str. 98, D-69123 Heidelberg
Voice +49-(0)6221-4038-273   Fax +49-(0)6221-4038-290
EMail emanuele.rinaldis_at_lionbioscience.com