Java Answers Forum - CallableStatement

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
CallableStatement

3 replies on 1 page. Most recent reply: Sep 26, 2003 9:21 AM by sabab

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 3 replies on 1 page

sabab

Posts: 34
Nickname: sabab
Registered: Aug, 2003

CallableStatement

Posted: Sep 25, 2003 9:27 AM

How can i get values from resultset using callablestatemnet
i am attaching my code here

con1=DriverManager.getConnection("jdbc:odbc:dsn1","username","pwd");
CallableStatement cs = con1.prepareCall("{call showEcode}");
ResultSet rs = null;
rs = cs.executeQuery();

in the above code ShowEcode is a SQL Server Stored Procedure
i want to pass a string to this proceudre as an inputparameter and a string as output parameter

pls help

Senthoorkumaran Punniamoorthy

Posts: 335
Nickname: senthoor
Registered: Mar, 2002

Re: CallableStatement

Posted: Sep 25, 2003 4:29 PM

If you do a simple google you will find enough resources for this

Shekhar

Posts: 11
Nickname: shekhar4u
Registered: Aug, 2003

Re: CallableStatement

Posted: Sep 26, 2003 4:00 AM

Hi try this code:

con1=DriverManager.getConnection("jdbc:odbc:dsn1","username","pwd");
CallableStatement cs = con1.prepareCall("{call showEcode(?,?)}");
cs.setString(1,urinputstring);
cs.registerOutParameter(2,Typ es.VARCHAR);
ResultSet rs = null;
rs = cs.executeQuery();
String outValue = cs.getString(2)

it will work....check out

sabab

Posts: 34
Nickname: sabab
Registered: Aug, 2003

Re: CallableStatement

Posted: Sep 26, 2003 9:21 AM

Thanx,, yes it is working

Flat View: This topic has 3 replies on 1 page

Previous Topic

Next Topic


	Web Artima.com