Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Escape characters for variables in sql

 
Meghna Bhardwaj
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI All,

I am trying to execute a query on Oracle db. I am unable to substitute my variables in the sql statement. The sql is:

select prod_type_nm from prod_type_dim
where (prod_type_nm like ':INTNL_DEST%' OR prod_type_nm Like ':INTNL_DOMESTIC_DEST%' );

:INTNL_DEST and :INTNL_DOMESTIC_DEST are the variables which should be replaced. However this sql does not work, when I execute it using hardcoded values its fine.

My Dao extends NamedParameterJdbcDaoSupport of the Spring Framework.

Any help will be appreciated. I can provide more details if needed.

Many thanks!
 
Paul Clapham
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wouldn't try to do that. I prefer to use features already built into Java when they exist, rather than features that don't. In this case the feature in question is a PreparedStatement. Define your query like this:and use the setString() method to set the parameters to something like "42%".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic