File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3753

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

[OCA 8 Book] [Blog]
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

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

Good Luck,
I agree. Here's the link:
subject: java code inside sql functions?
It's not a secret anymore!