Whats the best way one can consume a Java API in .Net. How to deal with java objects in .Net.

Question

Hello guys,

I have a .net application which is basically a trade blotter. Once the trade is blotted by the trader in the application, they need to STP the trade directly to another system from my application rather than feeding into the 3rd system manually.

The system which they need to STP the trade has an API developed around, which is java based. I intend to use the JAVA API in .net to stp those trade from my application.

Could you guys provide inputs on the best way to consume the java api in .net. Also can we convert a java api to .Net dll so can be consumed directly ?
Also seems the challenge could be dealing with java objects. Any suggestions pls ?

Awaiting reply and thnks in advance.


Shirish T.

Answer 1

Answer 2

The issue is in Admission.aspx.cs page, you have the below code.
protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
    {
        string value1 = GridView1.SelectedRow.Cells[4].Text;
        string value2 = GridView1.SelectedRow.Cells[5].Text;
        //Label1.Text = value1;
        //Label1.Text = Session["tm"].ToString();
        Session["prgfee"] = GridView1.SelectedRow.Cells[6].Text;
        //Label1.Text = Session["prgfee"].ToString();
        if (Convert.ToInt32(value1) <= Convert.ToInt32(Session["tm"]))
        {
            obj.Save_Rec(objprp);
            Response.Redirect("~/confirm.aspx");
        }


You are not setting objprp to some value. Before that You are setting

 nsadm.clsstadmdetprp objprp = new nsadm.clsstadmdetprp();
so all the columns in the objprp will be set to 0 if its int. In your case usercode is int, so it sets null.this save method tries to save with userid as 0, but there are no records for userid in tb_usr table for value 0. So throwing error "foreign key conflict"
Get the user details in session and set to objprp in admission.aspx page

Answer 3

ya sure, i have shared the code, you can check it

basically what i am doing here is,

student will register first(register.aspx),  (table tb_usr gets the value when user registers), than after his successful registration, he will be redirected to the page(admission.aspx) where he can take admission in a particular programme,and when he opt to take admission, error occurs that i asked for.

Answer 4

yes, that particular user has record in user table.

Answer 5

I meant the user code which you are trying to save in admission table. Does that particular user has a record in user table?

Answer 6

yes, usrcod do exist in table tb_usr

Answer 7

this is because the column usercode which you are passing and trying to save is not present in table User.

Check whether the usercode exists in tb_Usr