java.sql.SQLException: ORA-01008: not all variables bound

[bill.bruyn]

Is it illegal to use prepared statements in custom finders coded in a bean? I can't imagine why the following should throw this SQLException. Unless I don't know what I'm doing. Which is entirely possible, I suppose. Can anyone enlighten me?

...
Connection con = datasource.getConnection();
String sql = "SELECT user_id FROM principal WHERE last_name = ?";
PreparedStatement stmt = con.prepareStatement(sql);
stmt.setString(1, "Grossman");
ResultSet rs = stmt.executeQuery();
...


Thanks,

Bill

[kryptontri]

are you sure this is not oracle related ? or even related to the driver ?
I cannot see anything wrong with the code though ?

[bill.bruyn]

No, running the same with a Connection derived from DriverManager.getConnection() works as expected...

Other thoughts?

If it's useful, I'm using JBoss 2.2.2/Tomcat 3.2.2 and Oracle's type 4 driver.

[bill.bruyn]

Outside the bean, that is... I didn't try that inside the bean - I suppose I could try that...

[bill.bruyn]

Gee whiz. Nevermind, the whole thing was my mistake. I'm running late and I guess I'm starting to panic a little. I apologize for wasting everyone's time.