[hibernate-dev] sanitize input

[tibi]

hi,

i have a strange problem.

when i sanitize my inputs the index is not used any more.

details:
i use mssql 2005
i have a query like this:

//NOT USING THE INDEX!
String queryStr = "select * from USER_ING_EOM with  
(index(NON_CLUSTERD_INDEX_MAIL)) ";
         queryStr += " where MAIL=? ";
         final Query query = session.createSQLQuery(queryStr);
         query.setText(0, content.getManagerEmail1());
         final List result = query.list();

//USING THE INDEX FINE!
String queryStr = "select * from USER_ING_EOM with  
(index(NON_CLUSTERD_INDEX_MAIL)) ";
         queryStr += " where MAIL='" + content.getManagerEmail1();
         final Query query = session.createSQLQuery(queryStr);
         query.setText(0, content.getManagerEmail1());
         final List result = query.list();

first i had hsql but that was not using the index either.

could it be that the sanitizing makes it unpossible for mssql 2005 to  
use the index?


thanks

tibi

_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev