Hello Sir,
I got a remote object which is pointing to a single record at a time (Bean Managed Persistence). Now i have written a business method such as
public int Invoice_Count(int po_ID) throws Remote Exception
{
PreparedStatement pst = con.(query="select count(*) from apa_invoice
where po_id = ?");
ResultSet rs=pst.executeQuery();
return(Integer.parseInt(rs.getInt(1)));
}
Here i have code snippet only...
Now my question is whether the remote object which is currently pointing a single record can handle this type of query which is for a whole table. Whether this code will successfully execute or not.
Thanks
I got a remote object which is pointing to a single record at a time (Bean Managed Persistence). Now i have written a business method such as
public int Invoice_Count(int po_ID) throws Remote Exception
{
PreparedStatement pst = con.(query="select count(*) from apa_invoice
where po_id = ?");
ResultSet rs=pst.executeQuery();
return(Integer.parseInt(rs.getInt(1)));
}
Here i have code snippet only...
Now my question is whether the remote object which is currently pointing a single record can handle this type of query which is for a whole table. Whether this code will successfully execute or not.
Thanks