Two Laptop Bag*
The moose likes JDBC and the fly likes Escape characters for variables in sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Escape characters for variables in sql" Watch "Escape characters for variables in sql" New topic
Author

Escape characters for variables in sql

Meghna Bhardwaj
Ranch Hand

Joined: Jun 08, 2007
Posts: 109
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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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%".
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Escape characters for variables in sql
 
Similar Threads
Execute pl/sql function which is having bind variables in java
Running the sql files against database
Resultset
Hibernate-- Lgging SQL query and binding parameters in single statement
Oracle Queries performace