aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
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: 2503
    
    8

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
youtube channel
 
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?