java called from JNDI...getting resultset

[rajansss]

Hello, I wanted to call a Stored Procedure which is calling an RPG program thats returning one result set from JAVA. I am trying to alter an application that is already written in java accessing iseries RPG (business logic ). Currently this program uses PCML to call RPG, which I want to replace it by calling Stored procedure. I have pasted the half written code below. Can anybody please help on how to do that. Basically i want to get the result set from RPG in Java Thanks Connection con = null; CallableStatement sqlCall; sqlCall = con.prepareCall("CALL RSRINIVA.TESTPROC(?,?)"); //sqlCall.set sqlCall.execute(); ResultSet rs = sqlCall.getResultSet(); while(rs.next())

---

Code

[Guest.Visitor]

java called from JNDI...getting resultset

Rajansss, JNDI is the java api for name/object mapping reference stored in memory which has nothing to do with what you're trying to accomplish. Anyway, if you're trying to get the data from SP then see the code below. PCML also works great but unfortunately it has limitations as well. Good luck, Gio

---

Code