Shubham Semwal wrote:I'm getting the following error -
"Unknown column 'std_int' in 'where clause"
As already mentioned by Tapas Chand, there seems to be a mismatch between the parameter name of the
getidbelow procedure (
std_id) and the column name in the query (
std_int).
As a side note: if you are using a
JDBC 4.0 compliant driver, you no longer need to explicitly load JDBC drivers using
Class.forName(). The JDBC drivers are automatically loaded during initialitzation, thanks to the
Java SE Service Provider mechanism (SPM). So you can remove
line1 from your code snippet and the code will still work as intended.
Hope it helps!
Kind regards,
Roel