Invoke a table-valued function using JDBC
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

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
About | Sitemap | Contact