This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi. I am having an issue with what I believe to be the JDBC-ODBC bridge. I have used similar SQL at clients using a JDBC Driver but have not used this with JDBC-ODBC. The SQL is rather simple: // the parameter markers are all strings in the // format 'string','string','string', etc. delete from <table> where id not in ( ? ) and state in ( ? ) and code in (? ) I keep getting the error: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Any help would be greatly appreciated.... Thanks! Blaine Mincey firstname.lastname@example.org
Joined: Nov 28, 2000
Well, I was finally able to work around the problem by creating the Statement on the fly instead of using a PreparedStatement. Looks like the more 'elaborate' PreparedStatement was getting hosed through ODBC....if anyone has anything to add, I would love to hear ( read ) it! Thanks again! Blaine