Resultset Not Found Exception

[Former Member]

Hi all, having problem in Data Insertion in SQL server in webdynpro perspective.

SQL exception i.e. (.No Result Set was Produced) is generating after declaring the statement of resultset for executing the query string.

Result Set rs=execute Query (query);

Data is inserting properly but with this exception creation of result set.

Plz tel me how to overcome this exception.If u know any alternative of this plz let me know fast..

Regards:

Hanif

[Former Member · Accepted solution]

Could you paste the code which your using and the error too.

Also do refer this page, there is a small example.

http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/resultset.html

Thanks,

GLM

[Former Member]

answered thanks

[Former Member]

Hi,

How will data insert if resultset is null or having error? And I can't find statement object in your code. Print n Check if connection and statement objects are not null. If statement stmt is also printing, then execute resultset using

ResultSet rs = stmt.executeQuery(query);

while(rs.next){

// write code to print from resultset

}

Also make sure all imports are java.sql.*

Regards,

Harini S