Re: [JDBC] sequences in JDBC

2001-09-26 Thread Nick Fankhauser
Thanks Dave! That's exactly what I needed to know. -Nick > The problem is that it is treating "nextval..." as a literal string and > then trying to convert it to a number (as that is the column's type). You > need to change it to this: > > final String address_lineInsert = "insert into address_li

Re: [JDBC] sequences in JDBC

2001-09-26 Thread Dave Harkness
At 01:47 PM 9/26/2001, Nick Fankhauser wrote: >I'm trying to use a sequence via JDBC, but I'm having a problem. > >The prepared statement I'm using looks like this: > >final String address_lineInsert = "insert into address_line( address_id, >address_line_id, address_line_text) values (?,?,?)"; Th

[JDBC] sequences in JDBC

2001-09-26 Thread Nick Fankhauser
I'm trying to use a sequence via JDBC, but I'm having a problem. The prepared statement I'm using looks like this: final String address_lineInsert = "insert into address_line( address_id, address_line_id, address_line_text) values (?,?,?)"; I set the values like so: insertAddressLine.setString