Hi,
sorry people!
The column in question is defined in the db as not nullable.
Strangely stmt.executeUpdate("insert into table1 (id) values(null)");
doesn´t throw an error but a prepared statement does.
Again: sorry for wasting your time.
Cheers,
Mark

--- In IB-Java@y..., Krzysztof Golko <krzysztofgolko@y...> wrote:
> Are you sure you're using the same version of
> InterClient and InterServer?
>
> --- info@w... wrote:
> > Hi,
> > i got the jdk1.3 version of interclient.jar.
> > I now get the following messge:
> >
> > [interclient] Invalid operation to set a
> > non-nullable input parameter to nu=
> > ll.
> > See API reference for exception
> > interbase.interclient.InvalidOperationExcep=
> > tion
> > interbase.interclient.InvalidOperationException:
> > [interclient] Invalid oper=
> > ation
> > to set a non-nullable input parameter to null.
> > See API reference for exception
> > interbase.interclient.InvalidOperationExcep=
> > tion
> > at
> >
> interbase.interclient.PreparedStatement.setNull(interbase/interc=
> > lient
> > /PreparedStatement.java:402)
> >
> > I?m trying to trigger the filling of an
> > "autoincrement" field (using an ins=
> > ert-trigger) using a prepared statement. When i use
> > the Statement class it w=
> > orks!
> > ie. stmt.executeUpdate("insert into table1 (id)
> > values(null)");
> >
> > Any ideas?
> > TIA,
> > Mark
> >
> >
> > --- In IB-Java@y..., "alexander sokolov"
> > <sokolov@s...> wrote:
> > > It looks like you have interclient for jdk1.2, not
> > 1.3
> > >
> > > Look at
> > >
> > >
> >
> http://www.kpi.com.au/interbase/files/interclient.jar
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: <info@w...>
> > > To: <IB-Java@y...>
> > > Sent: Wednesday, October 17, 2001 18:33
> > > Subject: [IB-Java] setNull( col,
> > java.sql.Types.INTEGER) doesn?t work!
> > >
> > >
> > > Hi,
> > > using IB6 + Interclient 2 + JDK1.3.
> > > Get following error-message:
> > >
> > > java.lang.VerifyError: (class:
> > interbase/interclient/ErrorKey, method: _$=
> > 37=
> > > 2 signature:
> > (Ljava/lang/String;Ljava/lang/String;I)V) Expecting
> > to find =
> > uni=
> > > tialized object on stack
> > >
> > > Mind you that?s what i always get when some sql
> > error happens!
> > >
> > > Anybody experienced this/ got a solution?
> > >
> > > TIA
> > > Mark
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > IB-Java-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com