help! perhaps the problems of configuration of JDBC on Weblogic

[Robert Strong]

I'm using Oracle+Weblogic+JBuilder, I got a very strange problem. When I use PreparedStatement to pass parameters to query data, I cannot get the data, it always throws ObjectNotFoundException. But if I use Statement to query data, it works.
for example.
//Policy: a table in Oracle Database
String sql = "select * from policy where id='"+this.id+"'";
st.executeQuery(sql);
//this works
//but for this
String sql = "select * from policy where id=?";
PreparedStatement ps = con.createPreparedStatement(sql);
ps.setString(this.id);
ps.executeQuery();
//it throws ObjectNotFoundException
any help would be appreciated!
thanx in advance

[Dave Landers]

I assume you meant to say:

String sql = "select * from policy where id=?";
PreparedStatement ps = con.[B]prepareStatement[/B](sql);
ps.setString([B]1,[/B] this.id);

and this.id is of type String?

And what is throwing ObjectNotFoundException? - this would not be thrown by any of the above code, but by an entity bean finder method.