|
|
Featured White Papers
- Why choose an Open Source BPM?
- 10 FAQs on Business Process Management
- Best Practices for Getting Started with BPM
- Free Your Devs From The Pain Of Java Redeploys
- Increase Velocity 40% by Using JRebel
- What Developers Want: The End of Application Redeploys
- Developer Productivity Report: Java Tools, Tech, Devs, and Data
- Coding with JRebel: Java Forever Changed
- Utilizing Fast Testing to Transform Java Development
- Do You Really Get Classloaders?
- Pragmatic Continuous Delivery with Jenkins, Nexus, and LiveRebel
- Your Next Java Web App: Less XML, No Long Restarts, Fewer Hassles
- Coding with JRebel, Java Forever Changed
- 2012 Developer Productivity Report: Java Tools, Tech, Devs, and Data
How to execute a Callable Statement
Submitted by Ankit Pandey on Mon, 01/09/2012 - 03:18.
Tags:
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.*;
public class JoinTest {
public static void main(String[] args) {
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
try {
System.out.println("Enter name of emp");
String name=br.readLine();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con= DriverManager.getConnection("Jdbc:Odbc:JoinTest","sa","micro123");
CallableStatement stmt = con.prepareCall("exec getPhone name");
ResultSet rs=stmt.getResultSet();
while (rs.next()){
String name1=rs.getString(1);
int phone=rs.getInt(2);
System.out.println(name1+" "+phone);
}}
catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}Hi friends...
I am using callable statement first time and not able to run the program.
When I try to run program, I got "Microsoft][ODBC Driver Manager] Function sequence error"..
Please tell me the right procedure to use Callable Statement...
Thanks in advance....