This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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 Building Microservices this week in the Design 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: 2543
    
  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
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: calling a SQL function within my java code could somebody tell me what I did wrong?
 
It's not a secret anymore!