Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and the fly likes java code inside sql functions? 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 "java code inside sql functions?" Watch "java code inside sql functions?" New topic

java code inside sql functions?

rish obe

Joined: Jun 19, 2007
Posts: 6
I am running a sql query which uses some sql functions like date_add() or max()

Query is something like : delete from <tablename> where date=date_add(<date>,interval <expression> unit)

I wish to write the above query in java code
The problem is i am not able to pass the parameters to the sql functions in java code.

"delete from student where date=date_add("+date_variable+","+parameter_@+")"

How can this be done.
Any inputs?

Many thanks!
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3700

Can you post your java code? It's hard to know what you're doing wrong without see the JDBC code.

My Blog: Down Home Country Coding with Scott Selikoff
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

The usual way to achieve your aim is to use a PreparedStatement.

Good Luck,
It is sorta covered in the JavaRanch Style Guide.
subject: java code inside sql functions?
Similar Threads
HibernateException while using native sql query
Doubt Regarding PreparedStatement
stuck up in the problem
Hibernate not deleting rows
'Syntax Error in Query operator' MS Access