Very Computer

Hello,

I am trying to call a SQL Server stored procedure that needs a parameter.
My sample code looks like this so far:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn =
DriverManager.getConnection("jdbc:microsoft:sqlserver://clarksql-1:1433;Data
baseName=lcr","sa","");
CallableStatement cstmt = conn.prepareCall("{call MLSListings_GetByID}");
ResultSet rs = cstmt.executeQuery();

How and Where do I insert the value for the stored procedures parameter?

Thanks for the help!!

Brandon Olson

CallableStatement cstmt = conn.prepareCall("{call MLSListings_GetByID(?)}");
cstmt.setObject(1, YourParameter);
ResultSet rs = cstmt.executeQuery();

Volker Berlin
i-net software

Brandon Olson schrieb in Nachricht ...

Quote:>Hello,

>I am trying to call a SQL Server stored procedure that needs a parameter.
>My sample code looks like this so far:

>Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
>Connection conn =
>DriverManager.getConnection("jdbc:microsoft:sqlserver://clarksql-1:1433;Dat
a
>baseName=lcr","sa","");
>CallableStatement cstmt = conn.prepareCall("{call MLSListings_GetByID}");
>ResultSet rs = cstmt.executeQuery();

>How and Where do I insert the value for the stored procedures parameter?

>Thanks for the help!!

>Brandon Olson