When I try to attach a parameter to the stored procedure, I get

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'data_Events' because it is not full-text indexed

I invest in this way

  String query ="{call "+QUERY_GET_EVENTS+"(?,?,?,?,?,?,?,?)}"; PreparedStatement stmt = con.prepareStatement(query); stmt.setInt(1,0); stmt.setDate(2,null); stmt.setDate(3,null); stmt.setInt(4,0); stmt.setString(5,""); stmt.setByte(6, (byte) 0); stmt.setLong(7,0); stmt.setLong(8,0);

Types of input parameters:

  [dbo].[sql_GetEvents] @stream int = null , @dateFrom datetime = null , @dateTo datetime = null , @user int = null , @text nvarchar(max) = null , @super bit = null , @markInFrom bigint = null , @markInTo bigint = null
  • As far as I understand, you are using full-text search predicates, and a full-text index is not created. - msi
  • Do I understand correctly that the problem is in the database? - kalugin1912
  • Not so much in the database as in the absence of a full-text index, which, generally speaking, is not stored in the database. - msi

0