Why i cannot prepare the statement?

[IPOz]

Hi,friends
I used M$ jdbc driver to manipulate the SQL server 2000 RDBMS.It runs faster than odbc-jdbc bridge but when used in a SessionBean i encountered the following problem:
...
con = getConnection();
stmt = con.prepareStatement("select * from coffees"
...
the prepareStatement worked fine! The coffees table in sql2000 has COL_NAME, PRICE fields.
However,
stmt = con.prepareStatement("select * from coffees where (COF_NAME=?)"
will throw "Unable to create PreparedStatement!" exception !!!

I was frustrated now.please help me figure it out!

Best Regards!

IPO_z@cmmail.com
Garbage in,Garbage out

 

[meadandale]

Well, if your post is any indicator, you say the column name is "COL_NAME" but you try to prepare using "COF_NAME". Also, you don't need the parenthesis and in fact they may be causing the error.

 

[IPOz]

Thanks for your response! It is a type error
Now i have solved the problem by adding "SelectMethod=cursor" in SQL properties.

Regards! IPO_z@cmmail.com
Garbage in,Garbage out

 

[IPOz]

Thanks for your response! It is a type error
Now i have solved the problem by adding "SelectMethod=cursor" in SQL properties.

Regards! IPO_z@cmmail.com
Garbage in,Garbage out