• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SELECT Query Problem

 
sandhiya sindhi
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello dears,
i'm using Sql database. i have made JDBC/ODBC bridge.
in tables my all fields are text. i need only SELECT Query for such i have written as this...
String simple= "SELECT meaning FROM meaning "+" where word '"+s+"' ";
Statement= connection.createStatement();
ResultSet=stmt.executeQuery(simple);
i'm receiving this message when i'm running my Gui Application
"
Connection Error[Microsoft][ODBC SQL Server Driver][SQL Server] The text,ntextand image data type can not be compared or sorted except when using IS NULL or LIKE Operators."
and when i'm clicking on listner buttons my apllication hanged and error come this:
error at Action Performed Fine null
Kindly help me
Thank You
 
JavaHunk
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hey sweetie,
better generate the SQL Query and try to run it from SQL Analizer in
SQL-Server and check what happens or POST the QUERY generatet. Then
only anyone would be able to help you.
You can capture the Query either printing it in Java Console or in Query
Profiler of SQL-Server.
Regards
Javahunk
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic