Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and Relational Databases and the fly likes calling a SQL function within my java code could somebody tell me what I did wrong? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "calling a SQL function within my java code could somebody tell me what I did wrong?" Watch "calling a SQL function within my java code could somebody tell me what I did wrong?" New topic
Author

calling a SQL function within my java code could somebody tell me what I did wrong?

noodle hamilton
Greenhorn

Joined: Jun 08, 2007
Posts: 6
Hi all:
I am just trying to call a simple sql func in my java code, and I got


here is the sql function


I tested on the DB Client and the returned values are all correct.

here is a portion of my code that is calling it


please let me know what I was doing wrong..

Thanks
noodle hamilton
Greenhorn

Joined: Jun 08, 2007
Posts: 6
ok, never mind i figured it out...
it should be setString(2 instead..
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2541
    
  10

You're right, it has to be setString(2,...).
Also, you don't need to wrap the ip between single quotes when you bind the parameter.

Regards, Jan


OCUP UML fundamental and ITIL foundation
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: calling a SQL function within my java code could somebody tell me what I did wrong?
 
It's not a secret anymore!