After having the connection Object you can call any Stored Procedure using following Code.
Here spGetEventClient is the Stored procedure accepts one Argument.
try {
conn = dataSource.getConnection();
CallableStatement cs1 = conn.prepareCall("{call spGetEventClient(?)}");
cs1.setInt(1,13264);
ResultSet rs1 = cs1.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Wednesday, June 4, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment