Posted By:
Lakshmi_Vaidhyam
Posted On:
Monday, February 23, 2009 10:10 PM
hello all, i have SQL server 2005. There is a table-valued function getdepartments() in the database which returns a table. i need to invoke that function in my java program. try { getConnection(); CallableStatement cStmt = conn_.prepareCall("{? = call getdepartments()}"); cStmt.registerOutParameter(1,Types.BINARY); cStmt.executeQuery(); rs = (ResultSet) cStmt.getObject(1); } i have written this code to make that happen but this doesn seem to work properly. I am very new to programming in java. Could somebody please help me out. thank you
More>>
hello all,
i have SQL server 2005. There is a table-valued function getdepartments() in the database which returns a table. i need to invoke that function in my java program.
try
{
getConnection();
CallableStatement cStmt = conn_.prepareCall("{? = call getdepartments()}");
cStmt.registerOutParameter(1,Types.BINARY);
cStmt.executeQuery();
rs = (ResultSet) cStmt.getObject(1);
}
i have written this code to make that happen but this doesn seem to work properly.
I am very new to programming in java. Could somebody please help me out.
thank you
<<Less
