help on invalid column number...

[GoSooJJ]

hi all,
i have some problem on understanding this error message.
what is &quot;java.sql.SQLException: [Oracle][ODBC]Invalid column number <1>.&quot; or <2> or <3> error means?
i moved access database to oracle last weekend successfully and now i face with this error. however, some templates are working fine.
does error is relate to date data type?
the database is running under oracle 8 and used jsp code.
again, thx for great site~~~

JJ //

 

[jm99]

Hi GoSooJJ

When I encounter this error it's normally because I've 'forgotten' that column indexes in a ResultSet are not zero-based. Either that or I'm making a call to a statement that takes input parameters and I'm registering too many. Post the code that is spawning the exception and it should be possible to spot.

J